The DB2 tutorial you are looking at is: IBM DB2 Daily Maintenance Summary (iii). What is the default port for the 26.DB2 instance's server?
50000
Server name is DB2CDB2
27.db2udb server-side authentication types are available?
SERVER
Server_encrypt
CLIENT
Dce
Dce_server_encrypt
Kerberos
Krb_server_encrypt
What type of authentication does the 28.DB2 client have?
SERVER
Server_encrypt
Dcs
Dcs_encrypt
CLIENT
Dce
What are the types of permissions in the 29.DB2?
Sysadm System Administrative Permissions
Sysctrl System control permissions
Sysmaint System maintenance Rights
Dbadm Database Administrative permissions
Load operation permissions on a table
30. What kind of permissions cannot be authorized by Grant?
Sysam
Sysctrl
Sysmaint
To do this the permissions must modify the Database Manager configuration parameters
31. What are the types of tables?
Permanent table (base table)
Temporary table (description table)
Temporary tables (derived tables)
32. How do I know how many tables a user has?
SELECT*FROMSYSIBM. Systableswherecreator= ' USER '
33. How do I know the function under the user?
Select*fromiwh.userfunction
SELECT*FROMSYSIBM. Sysfunctions
34. How do I know the view number under the user?
Select*fromsysibm.sysviewswherecreator= ' USER '
35. How do I know the current DB2 version?
Select*fromsysibm.sysversions
36. How to know the number of trigger under the user?
SELECT*FROMSYSIBM. Systriggerswhereschema= ' USER '
37. How do I know the status of Tablespace?
SELECT*FROMSYSIBM. Systablespaces
38. How do I know the status of sequence?
SELECT*FROMSYSIBM. Syssequences
39. How do I know the status of a schema?
SELECT*FROMSYSIBM. Sysschemata
40. How do I know the status of index?
SELECT*FROMSYSIBM. sysindexes
41. How do I know the status of a table's fields?
SELECT*FROMSYSIBM. Syscolumnswheretbname= ' AAAA '
42. How do I know the DB2 data type?
SELECT*FROMSYSIBM. Sysdatatypes
43. How do I know the bufferpools situation?
SELECT*FROMSYSIBM. Sysbufferpools
44.DB2 the field of the table to modify the limit?
Only the VARCHAR2 type can be modified and can only be increased and not reduced.
45. How do I see the structure of a table?
Describletabletable_name
OR
Describleselect*fromschema. table_name
<
