14. How to modify the value of the registration item?
DB2SET can be modified
like:
Set a parameter of the current instance
DB2SETPARAMETER=VALUE
Set a global parameter
DB2SETPARAMETER=VALUE-G (lowercase)
View a list of all variables that can be set in the configuration file registry
DB2SET-LR (lowercase)
15. How to execute operating system commands in CLP?
Add "!" as the prefix before the command
DB2=>!DIRC:\
16. What should I do if the command is too long in CLP?
Use "\" as the continuation symbol
17. How to obtain syntax-related information of DB2 commands?
DB2? Show all DB2 commands
DB2?COMMAND display command information
DB2?SQLnnnn displays the SQLCODE explanation information
DB2?DB2nnnn displays the explanation information of this DB2 error
18. How to check the settings of the current CLP?
DB2=>LISTCOMANDOPTIONS
19. How to update the specific item settings of the current CLP session?
DB2UPDATECOMMANDOPTIONSUSINGOPTIONS...
Which command can be used to call?
DB2CMD command
21. What is the default name of the management server?
DB2AS under UNIX
DB2DAS00 under WINDOWS
22. Commonly used commands to manage DB2 server instances?
DB2ADMINSTART starts the DB2 management server instance
DB2ADMINSTOP Stop DB2 Management Server Instance
Create a DB2 management server instance under DASICRTUNIX
Delete DB2 management server instance under DASIDROPUNIX
Create a DB2 management server instance under DB2ADMINCREATEWINDOWSOROS/2
Delete DB2 management server instance under DB2ADMINDROPWINDOWSOROS/2
DB2GETADMINCFG displays configuration parameters of DB2 management server
DB2UPDATEADMINCFG modify the configuration parameters of DB2 management server
DB2RESETADMINCFG sets the configuration parameters of the DB2 management server to the default value
23. What are the types of DB2 directories?
System database directory
Local database directory
Node Directory
DCS Directory
Manage node directory
24. How to view the system database directory?
LISTDBDIRECTORY
25. How to view the database server directory?
LISTNODEDIRECTORY
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
[1] [2] Next page
The db2 tutorial I am looking at is: 1000 common fool questions for DB2 (one). DCS_ENCRYPTCLIENT
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 above 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
46. How to quickly clear a large table?
ALTERTABLETABLE_NAMEACTIVENOTLOGGEDINITALLYWITHEMPTYTABLE
47. How to view the database package?
select*
48. How to view the stored procedures of the database?
SELECT*
49. How to view the constraints of tables?
SELECT*='AAAA'
50.How to view the complete constraints for references of a table?
SELECT*='AAAA'
Previous page [1] [2]