Common DB2 management commands

DB2 management commands are used to manage DB2 databases. The following describes commonly used DB2 management commands in detail. If you are interested in this, take a look.

The commonly used DB2 management commands described below can be entered and run through the "command line processor" or the "command Editor" Gui manager in the "db2 control center.
Db2 management Commands include SQL commands, which are different from db2 system commands.

DB2 management commands

Instance level:

1) Start the Database Manager instance

Db2start

2) Stop the Database Manager instance

Db2stop

3) Get Database Manager Configuration Settings

Get dbm cfg

4) display the current value and latency value of the Database Manager Parameters

Get dbm cfg show detail

5) return the value of the DB2INSTANCE environment variable.

Get instance

6) disconnect all applications from the database

Force application all

7) connect to the instance using the password

Attach to user using

Database level:

8) explicitly connect to the database with the user and password

Connect to [[user] using]

9) activate the database explicitly

Activate database

10) explicitly invalidates the database

Deactivate database

11) disconnect from the current database

Connect reset

12) display the current value and delay value of database configuration parameters

Get db cfg show detail

13) display the database configuration settings of the database

Get db cfg

14) Configure database Parameters

Update to value

Update db cfg for using

15) List tables in the database

List tables [for {user | all | system | schema}] [show detail]

If no parameter is specified, the current user's table is listed by default.

16) displays the column information of a table or view.

Describe table

17) display the table space identifier, name, type, content, and status

List tablespaces [show detail]

18) display container information with the specified tablespace

List tablespace containers for [show detail]

In-depth discussion of DB2 table connection principles

Common DB2 cycle usage

DB2 Directory structure

DB2 column functions and scalar functions

DB2 Directory view description