The db2 tutorial we are watching is: IBM DB2 daily maintenance summary (II). Which command should I use to install DB2?
INSTALLP Command
11. Can multiple DB2 databases be installed under the same operating system?
OK
12. How to stop the instance?
DB2STOP
13. How to start an instance?
DB2START
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
INSTALLP Command
11. Can multiple DB2 databases be installed under the same operating system?
OK
12. How to stop the instance?
DB2STOP
13. How to start an instance?
DB2START
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