Tag Archive | cfg

List Database Configuration parameters

 

1)Login as a DB2 Instance User
2)Execute ” db2 get db cfg” as the Instance User
3)This command returns information only for the partition on which it is executed.
4)This command returns values of individual entries in a specific database configuration file.

Database Configuration for Database
[db2inst1@mercury ~]$ db2 get db cfg

Screeshot : Database Configuration
db2getdbcfg

5) The output shows various parameters like “Path of Logs” ” Page Size ” Etc