Summary of routine maintenance of IBM DB2 (III)

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