Configuration: Database (DB2 UDB for UNIX and Windows) 
Configuration: Database (DB2 UDB for UNIX and Windows)
You can access information on database configuration by calling transaction DB6COCKPIT and choosing Configuration ® Database in the navigation frame of the DBA Cockpit. The Configuration: Database screen appears.
The following information is displayed:
Group |
Description |
Common |
Common information on the database, for example, release level and country code |
Performance |
Information on optimization and I/O |
Memory |
Information on the memory available for the database and the application |
Logging |
Information on log files and logging parameters |
Backup and Recovery |
Information on recovery availability, Tivoli Storage Management (TSM) and backups |
Locks |
Information on locks, for example, the percentage of lock lists per application |
Space |
Information on containers and tablespaces |
Application |
Information on applications that connect to the database |
The database parameters for each group are displayed with a short description and a keyword. This keyword is the name of the parameter and is displayed in brackets. If you need to change a parameter use the following command:
UPDATE DATABASE CONFIGURATION for <system> using <keyword> = <value>
If your database is DB2 UDB EEE for UNIX and Windows, the parameters can vary for each partition.
For more detailed information on these parameters, see the IBM DB2 online documentation.