Summary of tips on using IBM DB2 database

1. View the Local node directory

Command Window ENTER: DB2 list node Directory

2. Cataloging a TCP/IP node

Command window: DB2 catalog TCPIP node remote server OSType

3. Cancel the node catalog

DB2 uncatalog Node

4. View the System database directory

DB2 List Database Directory

5. View the local database directory

DB2 List Database directory on < letter >

A database in the local database directory that is not available in the System database directory can be accessed by selecting < database > right-clicking in the control center and then entering the database name you want to add or clicking the Refresh button to select the database.

6. Catalogue Database

DB2 catalog database as at node

7. Cancel the database catalog

DB2 Uncatalog Database

8. Testing the connection of a remote database

DB2 Connect to user using

9. Set default mode

Any user can set the default mode for a particular database connection by setting the current schema private register, with the initial default value being the permission ID of the currently session user.

Set schema =

Can be used interactively by the user or in an application, and this statement has no effect if the bundle is bound with the dynamicrules bind option. This statement is not under transaction control.

10. Code page settings

Set up a character set when creating a database

Create DATABASE using CodeSet territory

Cases:

Create database dbtest using CodeSet IBM-437 territory US

You can also set the code page for the entire database, and in win2000/nt/xp, add the variable in My Computer--> properties--> Advanced--> environment variable db2codepage =, example: db2codepage = 437 or Db2codepage = 1386. Alternatively, in the IBM DB2 Command window, enter Db2set db2codepage=1386, which needs to be restarted after the DB2 is in effect.