The whole process of manually adding a database to DB2 (1)

The following articles mainly show you the correct operation steps for manually adding a database to DB2 and the description of the test environment used to implement the operation steps, the following is a description of the specific solution. I hope it will help you in your future study.

Test environment: Windows XP

DB2 version information

 
 

  
  
D:DB2BIN>db2level  
 
 

DB2 1085i instance "DB2" uses "32" bit and DB2 code release version "SQL09050", with the level ID "03010107 ".

Refer to "DB2 v9.5.0.808", "s071001", and "NT3295" with revision package "0 ".

The product uses the DB2 copy name "DB2COPY1" installed in "D: DB2.

D: DB2BIN> db2licm-l

Product name: "DB2 Express-C"

License type: "unsecured"

Expiry date: "permanent"

Product identifier: "db2expc"

Version info: "9.5"

Max number of CPUs: "2"

D: DB2BIN>

Create a database

Step 1: Install DB2 (omitted)

Step 2: Configure related directories

 
 

  
  
mkdir d:db2study  
  
  
db2set DB2_CREATE_DB_ON_PATH=YES 
 
 

Note: The database I created should be stored in the d: db2study directory. Because I want to manually add the database path to DB2 IN THE create script, activate the DB2_CREATE_DB_ON_PATH registry key.

Step 3: Start a DB2 instance

D: DB2BIN> db2

(C) Copyright IBM Corporation 1993,2007

DB2 client 9.5.0 command line Processor

You can issue Database Manager commands and SQL statements from a command prompt. For example:

 
 

  
  
db2 => connect to sample  
  
  
db2 => bind sample.bnd 
 
 

For general help, enter :?.

For Command help, enter :? Command, where command can be

The first few keywords for manually adding Database Manager commands in DB2. For example:

? Catalog database is used to help with the catalog database Command

? CATALOG is used to help all CATALOG commands.

To exit the db2 interaction mode, enter QUIT at the command prompt. In non-interactive mode, all commands must be prefixed with "db2.

To LIST the settings of the current command options, enter list command options.

For more help, see Online Reference Manual.

Db2 => db2start

The DB20000I DB2START command is successfully completed.

Db2 =>