Online Documentation for SQL Manager for DB2

Database Properties


The Database Properties dialog allows you to view/edit a number of the DB2 database variables which can be changed to optimize database performance.

 

To open the dialog, right-click the Database in DB Explorer and select the btnDBProperties Database Properties... context menu item, or use the Properties button on the DB Explorer toolbar.

 

menuDatabaseProperties

 

Database variables

Recovery

Logs

Maintenance

Applications

Performance

Status

Environment

Monitor