Shulou(Shulou.com)06/01 Report--

Db2 parameter view

1. View all existing DB2 configuration file registries

Db2set-lr

2. View all DB2 configuration file registries that have been set up

Db2set-all

3. Set up the DB2 configuration file registry

Db2set DB2COMM=TCPIP

To set the DB2 profile registry to multiple values:

Db2set DB2COMM=TCPIP,NPIPE,LOCAL

4. View the configuration parameters of DB2 database manager:

Db2 get dbm cfg

Db2 get dbm cfg show detail will display more detailed information

5. Update the database manager configuration parameters (instance level). The syntax is

UPDATE DBM CFG USING {YOUR PARAMETER YOUR DESIRED VALUE}

[IMMEDIATE | DEFERRED]

The last optional parameter is the effective configuration.

For example:

Update dbm cfg using INTRA_PARALLEL YES IMMEDIATE

6. DB2 database configuration parameters (database level)

Display database configuration parameters

Db2 get db cfg

7. How to set the default database configuration parameters

Db2 reset db cfg

8. Db2 get db cfg for erpdb to view database parameters

Db2 get dbm cfg view instance if modified, the db2systm file is binary, so use the command to modify it.

Db2 get db cfg for erpdb | grep-I catalogcache to view the modified parameters

9. View the management server DAS

Db2 get admin cfg

10. View the database directory

Db2 list db directory om dbpath

11. View the tablespace

Db2 list tablespaces

12. View the tablespace container

Db2 list tablespaces show detail

13. List containers

Db2 list tablespaces containers for 2

14. Rename tablespace

Rename tablespace t1 to t2

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.