Routine maintenance Summary of IBM DB2 (2)

Source: Internet
Author: User
Tags db2 error ibm db2

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

<

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.