IBM DB2 daily maintenance summary (III)

The db2 tutorial we are watching is: IBM DB2 daily maintenance summary (III). 26. What is the default port of the server for the DB2 instance?
50000
Server name is DB2CDB2

27. Are there any authentication types on the DB2UDB server side?
SERVER
SERVER_ENCRYPT
CLIENT
DCE
DCE_SERVER_ENCRYPT
KERBEROS
KRB_SERVER_ENCRYPT

28. Are there any authentication types of DB2 clients?
SERVER
SERVER_ENCRYPT
DCS
DCS_ENCRYPT
CLIENT
DCE

29.What types of permissions are there in DB2?
SYSADM system management permissions
SYSCTRL system control permissions
SYSMAINT system maintenance permissions
DBADM database management permissions
LOAD permission to perform LOAD operations on tables

30. What kind of permissions cannot be authorized through GRANT?
SYSAM
SYSCTRL
SYSMAINT
To change the permissions, you must modify the database manager configuration parameters

31. What are the types of tables?
Permanent table (base table)
Temporary table (instruction table)
Temporary table (derived table)

32. How to know how many tables a user has?
SELECT*='USER'

33. How to know the functions under the user?
select*
select*

34. How to know the number of VIEWs under the user?
select*='USER'

35. How to know the current version of DB2?
select*

36. How to know the number of TRIGGERs under the user?
select*='USER'

37. How to know the status of TABLESPACE?
select*

38.How to know the status of SEQUENCE?
select*

39. How to know the status of SCHEMA?
select*

40.How to know the status of INDEX?
select*

41. How to know the status of the fields in the table?
select*='AAAA'

42. How to know the data type of DB2?
select*

43.How to know the status of BUFFERPOOLS?
select*

44. What are the fields modification restrictions of DB2 tables?
Only VARCHAR2 type can be modified and can only be increased but not decreased.

45. How to view the structure of the table?
DESCRIBLETABLETABLE_NAME
OR
DESCRIBLESELECT*FROMSCHEMA.TABLE_NAME