Forcing termination of the Query Monitor Subsystem

During certain operations, Db2 Query Monitor enters a temporary state during which the Query Monitor Subsystem cannot be canceled. When this occurs, retry the cancel command at a later time. In the unlikely event that the Query Monitor Subsystem still does not respond to the cancel command, you can use the MVS force command to force the termination of the Query Monitor Subsystem.

Before you begin

The force command should only be used under the advice of IBM® Software Support, after all other methods of shutting down the Query Monitor Subsystem have been attempted and have failed.

Unpredictable results can occur after issuing the force command, including the termination of any monitored Db2 subsystems.

Before you use the force command, obtain a dump of the Query Monitor Subsystem address space, all Db2 Query Monitor data spaces, and the monitored Db2 DBM1 address spaces.

About this task

Procedure

You can force the termination of the Query Monitor Subsystem in SDSF by entering the force command:

FORCE taskname, ARM: Forces the termination of the Query Monitor Subsystem started task, taskname. This command should only be used after all other methods of shutting down the Query Monitor Subsystem have failed.

For example:

FORCE CQMPROC, ARM