SoFunction
Updated on 2025-04-14

IBM DB2 daily maintenance summary (II)

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