Learning Visually with Examples [Electronic resources] نسخه متنی

1.

First, you want to know how many instances you have in your computer, so you enter:

db2ilist 

2.

Then, to find out which of these instances is the current active one, you enter:

db2 get instance 

With the

db2ilist command, you found out there were two instances defined on this computer,

DB2 and

myinst . With the

db2 get instance command, you learned that the

DB2 instance is the current active instance.

3.

You would now like to list the databases in the

myinst instance. Since this one is not the current active instance, you first switch to this instance temporarily in the current Command Window:

set DB2INSTANCE=myinst 

4.

You again issue

db2 get instance to check that

myinst is now the current instance.

5.

To list the databases defined on this instance you issue:

db2 list db directory 

This command shows that you only have one database (

MYDB2 ) in this instance.

6.

You want to try creating a new database called

TEMPORAL , so you execute:

db2 create database temporal 

The creation of the database takes some time because several objects are created by default inside the database. Issuing another

list db directory command now shows two databases:

MYDB2 and

TEMPORAL .

7.

You connect to the

MYDB2 database (

db2 connect to mydb2 ) and check which tables you have in this database (

db2 list tables for all ). You also check how many table spaces are defined (

db2 list tablespaces ).

8.

Next, you want to review the contents of the database configuration file (db cfg) for the

MYDB2 database:

db2 get db cfg for mydb2 

9.

To review the contents of the Database Manager Configuration file (dbm cfg) you issue:

db2 get dbm cfg 

10.

At this point, you want to practice changing the value of a dbm cfg parameter, so you pick the INTRA_PARALLEL parameter which has a value set to YES. You change its value to NO as follows:

db2 update dbm cfg using INTRA_PARALLEL NO 

11.

You learned at the class that this parameter is not "configurable online," so you know you have to stop and start the instance. Since there is a connection to a database in the current instance (remember you connected to the

MYDB2 database earlier from your current Command Window), DB2 will not allow you to stop the instance. Enter the following sequence of commands:

db2 terminate (terminates the connection) 
db2stop 
db2start