Configuration: Database (DB2 UDB for UNIX and Windows) 

You can access information on database configuration by calling the DBA Cockpit and choosing Configuration ® Database in the navigation frame of the DBA Cockpit. The Configuration: Database screen appears.

The following information is displayed:

Tabstrip	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 on each tabstrip 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>

In multi-partition environment, the parameters can vary for each partition.

In addition, you can maintain the database configuration parameters. For more information, see Maintaining the Database Configuration.

For more detailed information on these parameters, see the IBM DB2 online documentation.