31 management commands of the DB2 database (1)

Whether you are a senior DBA or a newbie to DB2, you must master the management commands of the DB2 database. The following describes 31 commonly used DB2 management commands, hope to help you.

1. view the local node directory
In the command window, enter db2 list node directory.

2. cataloguing a TCP/IP Node
Command window: db2 catalog tcpip node remote server ostype

3. Cancel node Cataloguing
Db2 uncatalog node

4. view the system database directory
Db2 list database directory

5. view the local database directory
Db2 list database directory on <drive letter>
If the database is in the local database directory but not in the system database directory, you can right-click <database> in the control center and choose add, enter the name of the database to be added or click the refresh button to select a database. After joining the database, you can access the database.

6. cataloguing Database
Db2 catalog database as at node

7. Cancel database Cataloguing
Db2 uncatalog database

8. Test the remote database connection.
Db2 connect to user using

9. Set the default mode