Managing DB2 applications, agents, and subagents

A DB2 application is any application that connects to a DB2 database. To monitor and manage the applications and the coordinating agents and subagents associated with those applications, use the commands provided in the DB2EEE_APP, DB2EEE_AGENT, and DB2EEE_SUBAGENT menus.

For example, you can run a report to get general information or summary information about an application, or you can use the SQL Snapshot facility and SQL Explain to generate SQL information reports.

You can also list the applications associated with a DB2 instance, a database, or a node from the object's icon menu, and force applications offline. This KM also enables you to set the degree of parallelism for applications.

To run the SQL snapshot and SQL explain facilities

Warning

If you are using DB2 UDB EEE version 6, fixpack U469453 is required to run the SQL Snapshot and SQL Explain commands. You must install the fixpack before you can use these facilities. If you attempt to run the commands without the fixpack in version 6, the database manager will crash.

Right-click on the DB2EEE application icon to open the menu and select one of the following commands from the SQL Snapshot menu:

  • SQL Information (runs a snapshot report)
  • SQL Explain (runs a DB2-explained report)

Note

For more information about monitoring SQL statement activity, see Using-the-SQL-Viewer-facility.

To run an application report

Right-click on the DB2EEE application icon and select Reports > General to get general information about the application, or select one of the following Summary reports:

  • Application Agents
  • Subagent Parameters

The Application Agents report gives configuration and status information for all agents on all nodes associated with the application.

The*Subagent Parameters* report displays the parameters information for all nodes running a subagent for the application.

Note

You can also run applications reports from the DB2 instance menu, discussed in To run reports that give information about applications running in the instance.

To list applications and force applications

To list applications, select the List Applications command from the DB2EEE instance menu, the database menu, the node menu, or the database partition menu.

To force applications offline, select the Force Application command from the DB2EEE instance menu, from a database menu, or from the application's coordinating agent or a subagent.

Note

Ensure that all operations that cannot be interrupted have completed successfully before you force an application offline. If you force an application before it has completed, the halted operation must be successfully completed before the database can be made available again. You cannot force an application that is hung in an indoubt transaction. The indoubt transaction must be processed before the application can be forced offline. See To process indoubt transactions that are in an incomplete or unknown state for more information.

To set the runtime degree of parallelism for applications running in an instance

  1. Right-click the DB2EEE instance icon and select Database Administration > Applications Mgmt > Set Runtime Degree.
  2. In the Set Runtime Degree window, enter a number for the degree of parallelism and select the application option to which it applies.

 

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