Database Configuration Parameters
Certain parameters are configured when you run the scripts to configure the database. You can log in to the database as an instance owner to view the parameters.
Viewing the parameters
To view the database codeset, log in as the instance owner and run the following command.
db2 get db cfg for <database name> | grep 'Database code set'To see all parameters that are configured, run the following command.
db2 get db cfg for <database name>List of parameters
The following table lists the parameters that are configured in the database.
| Parameter | Value | |
|---|---|---|
| Parameters that are configured during the creation of the database | Codeset | UTF-8 |
| Pagesize | 32 K | |
| Parameters that are configured after the creation of the database. | AUTO_REVAL | DEFERRED_FORCE |
| DECFLT_ROUNDING | ROUND_HALF_UP | |
| STMT_CONC | LITERALS | |
| CATALOGCACHE_SZ | 1000 | |
| SOFTMAX | 100 | |
| DBHEAP | 80000 | |
| LOGFILSIZ | 25600 | |
| LOGPRIMARY | 100 | |
| LOGSECOND | 20 |