Managing database partitions at the node

You can perform database management tasks on the partition servers in your DB2 configuration by using the commands available in the DB2EEE_DB_NODE application class menu. The commands allow you to monitor attributes of a database that are associated with a particular partition server (node) or perform crash recovery for the partition.

To access the menu, in the database icon window for the selected database, open the DB2EEE_DB_NODE container and select the partition with which you want to work.

Note

The commands discussed in the following tasks execute only on the single node partition.

To complete database administration tasks for a node partition

Right-click on the partition icon and select Database Administration.
select any of the following menu items:
- List Applications, in the Application Mgmt menu
- Show, Update, or Reset the database configuration in the Configuration Mgmt menu
- List Tablespaces, List Tablespace Containers, and Quiesce Tablespaces in the Tablespace Mgmt menu
- Restart a database and Process Indoubt Transactions in the Recovery Mgmt menu to perform crash recovery for a database partition

To restart a database to recover from a crash

To restart a database at the partition, right-click on the partition icon and select Database Administration > Recovery Mgmt > Restart.
If the connection to the database is re-established, select DatabaseAdministration > Recovery Mgmt >Process Indoubt Transactions to complete pending transactions at the partition.
The Process Indoubt Transactions menu command is currently disabled.

To process indoubt transactions that are in an incomplete or unknown state

Right-click on a database partition icon and select Database Administration > Recovery Mgmt > Process Indoubt Transactions.
The Process Indoubt Transactions menu command is currently disabled.
If indoubt transactions exist, select a transaction from the list and select a processing action from the following options:

Note

Repeat the selection process for each transaction. Only one transaction can be processed at a time.

To run a report showing information about a database on a partition

Right-click on the database partition icon and select Reports to view a variety of information about the database on the selected partition.

The reports available are as follows:

Bufferpool Info
Connection Info
Database Activity Info
General Info
I/O Activity Info
Lock Info
Logging Activity Info
Sort Activity
SQL Statement Activity
Table Activity Info
Applications Info
Tablespace Info

To refresh and chart parameter values

From the DB2EEE_DB_NODE menu, select the following commands to update and display parameter values for the node partition:

select Refresh Parameters to refresh parameter values for the database at the selected node partition.
select Chart Parameters to display a graph correlating all parameter values associated with the database at the node partition.