Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Db2 parameter view

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report