Skip to Content

Managing database operations and configuration

The database application class menu in PATROL for DB2 UDB provides the commands that enable you to manage the activities of your DB2 databases in a parallel or partitioned configuration. These tasks include starting and stopping a database, viewing and updating the database configuration file, running database reports, and managing connected applications. You can also process ad hoc queries with the SQL Processor command, discussed in Performing ad hoc queries in a database#Performingadhocqueriesinadatabase-19410.

Warning

Note

To configure database performance monitoring that enables you to capture timing statistics during specific SQL execution, see Configuring advanced performance monitoring for a database#Configuringadvancedperformancemonitoringforadatabase-73107.

To start and stop a DB2 database

Warning

Note

When you activate a database by using the Activate Database command, the startup overhead occurs before the first application connects to the database. When you start database services by using this command, you must use the Deactivate Database command to shut down the database.

  1. Right-click on the DB2EEE database icon for the selected database and select Database Administration > Database Mgmt.

  2. select one of the following commands:
    • Activate Database
    • Deactivate Database

To update the database configuration

  1. Right-click on the DB2 database icon and select Database Administration > Configuration Mgmt.
  2. select one of the following commands:
    • Show DB Configuration
    • Update DB Configuration
    • Reset DB Configuration

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for DB2 Universal Database 9.0