The db2 tutorial is: Daily maintenance Summary of IBM DB2 (2 ). 10. Which command is used to install DB2 under AIX?
INSTALLP command
11. How many DB2 databases can be installed in the same operating system?
Yes
12. How do I stop an instance?
DB2STOP
13. How do I start an instance?
DB2START
14. How do I modify the value of the registration item?
DB2SET can be modified
For example:
Sets a parameter for the current instance.
DB2SETPARAMETER = VALUE
Set a global Parameter
DB2SETPARAMETER = VALUE-G (lower case)
View the list of all variables that can be set in the configuration file Registry
DB2SET-LR (lower case)
15. How to execute operating system commands in CLP?
Add "! "As prefix
DB2 =>! DIRC :\
16. What should I do if the command in CLP is too long?
Use "\" as the continuation symbol
17. How to obtain the syntax information of DB2 commands?
DB2? Show all DB2 commands
DB2? COMMAND: displays COMMAND information.
DB2? SQLnnnn displays the explanation of this SQLCODE
DB2? DB2nnnn displays the explanation of this DB2 Error
18. How do I view the current CLP settings?
DB2 => LISTCOMANDOPTIONS
19. How to update the specific settings of the current CLP session?
DB2UPDATECOMMANDOPTIONSUSINGOPTIONS...
20. Which command can be used to call COMMANDWINDOWS?
DB2CMD command
21. What is the default name of the management server?
DB2AS in UNIX
DB2DAS00 in WINDOWS
22. Commonly Used commands for managing DB2 server instances?
DB2ADMINSTART start the DB2 management server instance
DB2ADMINSTOP stop the DB2 management server instance
Create a DB2 management server instance in DASICRTUNIX
Delete A DB2 management server instance under DASIDROPUNIX
Create a DB2 management server instance under DB2ADMINCREATEWINDOWSOROS/2
Delete A DB2 management server instance under DB2ADMINDROPWINDOWSOROS/2
DB2GETADMINCFG displays the configuration parameters of the DB2 Management Server
DB2UPDATEADMINCFG modify the configuration parameters of the DB2 Management Server
DB2RESETADMINCFG sets the configuration parameters of the DB2 Management Server to the default value.
23. What types of DB2 directories are divided?
System database directory
Local Database directory
Node directory
DCS directory
Manage node Directories
24. How do I view the system database directory?
LISTDBDIRECTORY
25. How to view the database server directory?
LISTNODEDIRECTORY
<