Summary of routine maintenance of IBM DB2 (III)

Source: Internet
Author: User
Tags db2 client ibm db2 types of tables

The db2 tutorial is: Daily maintenance Summary of IBM DB2 (3 ). 26. What is the default port of the DB2 instance server?
50000
The server name is DB2CDB2.
  
27. What are the authentication types on the DB2UDB server?
SERVER
SERVER_ENCRYPT
CLIENT
DCE
DCE_SERVER_ENCRYPT
KERBEROS
KRB_SERVER_ENCRYPT
  
28. What are the authentication types of the DB2 client?
SERVER
SERVER_ENCRYPT
DCS
DCS_ENCRYPT
CLIENT
DCE
  
29. What types of permissions does DB2 have?
SYSADM System Management permission
SYSCTRL system control permission
SYSMAINT system maintenance permission
DBADM database management permission
Permission to LOAD a table
  
30. Which of the following permissions cannot be granted through GRANT?
SYSAM
SYSCTRL
SYSMAINT
To modify this permission, you must modify the Database Manager configuration parameters.
  
31. What types of tables are there?
Permanent Table (base table)
Temporary table (description table)
Temporary table (derived table)
  
32. How many tables does a user have?
SELECT * FROMSYSIBM. SYSTABLESWHERECREATOR = 'user'
  
33. How do I know the functions under a user?
Select * fromIWH. USERFUNCTION
Select * fromsysibm. SYSFUNCTIONS

34. How do I know the number of views under a user?
Select * fromsysibm. sysviewsWHERECREATOR = 'user'
  
35. How do I know the current DB2 version?
Select * fromsysibm. sysvERSIONS
  
36. How do I know the number of triggers under a user?
Select * fromsysibm. SYSTRIGGERSWHERESCHEMA = 'user'
  
37. How do I know the status of TABLESPACE?
Select * fromsysibm. SYSTABLESPACES
  
38. How do I know the SEQUENCE status?
Select * fromsysibm. SYSSEQUENCES
  
39. How do I know the SCHEMA status?
Select * fromsysibm. SYSSCHEMATA
  
40. How do I know the INDEX status?
Select * fromsysibm. SYSINDEXES
  
41. How do I know the status of table fields?
Select * fromsysibm. SYSCOLUMNSWHERETBNAME = 'aaa'
  
42. How do I know the DB2 data type?
Select * fromsysibm. SYSDATATYPES
  
43. How do I know the BUFFERPOOLS status?
Select * fromsysibm. SYSBUFFERPOOLS
  
44. Restrictions on modifying fields in the DB2 table?
Only the VARCHAR2 type can be modified and can be increased or not decreased.
  
45. How to view the table structure?
DESCRIBLETABLETABLE_NAME
OR
DESCRIBLESELECT * FROMSCHEMA. TABLE_NAME
  
  
<

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.