IBM DB2 Daily Maintenance Summary (ii) _DB2

Source: Internet
Author: User
Tags db2 db2 error ibm db2 lowercase
The DB2 tutorial you are looking at is: IBM DB2 Daily Maintenance Rollup (ii). Which command does the 10.AIX use to install the DB2?
INSTALLP command
  
11. Can you install multiple DB2 databases under the same operating system?
OK
  
12. How do I stop an instance?
Db2stop
  
13. How do I start the instance?
Db2start
  
14. How do I modify the value of a registered entry?
Db2set can modify
Such as:
Sets a parameter for the current instance
Db2setparameter=value
  
Set the parameters of a global level
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 "!" before the order. As a prefix
db2=>! Dirc:\
  
16. What if the command is too long in CLP?
Use "\" as a continuation symbol
  
17. How do I get the syntax-related information for the DB2 command?
DB2? Show all DB2 commands
DB2? Command Display commands information
DB2? SQLNNNN shows the explanation of this sqlcode.
DB2? DB2NNNN Display this DB2 error explanation information
  
18. How do I view the current CLP settings?
Db2=>listcomandoptions
  
19. How do I update specific settings for the current CLP session?
Db2updatecommandoptionsusingoptions ...
  
What command can 20.COMMANDWINDOWS invoke?
Db2cmd command
  
21. The default name for the Management Server is?
Under Unix for Db2as
Under Windows for DB2DAS00

22. Common commands for managing DB2 server instances?
Db2adminstart Start DB2 Management Server instance
Db2adminstop Stop DB2 Admin Server instance
Dasicrtunix Create DB2 Management Server instance
Dasidropunix Remove DB2 Admin Server instance
DB2ADMINCREATEWINDOWSOROS/2 Create DB2 Management Server instance
DB2ADMINDROPWINDOWSOROS/2 Remove DB2 Admin Server instance
DB2GETADMINCFG Display configuration parameters for DB2 Management Server
Db2updateadmincfg Modify the configuration parameters of the DB2 Management Server
Db2resetadmincfg set the configuration parameters of the DB2 Management Server to the default value
  
What kinds of 23.db2 directory?
System Database Directory
Local Database Directory
Node Directory
DCS Directory
Manage Node Directory
  
24. How do I view the system database directory?
Listdbdirectory
  
25. How do I view the database server directory?
Listnodedirectory

<

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.