Chatta subito con l'assistenza
Chat con il supporto

Spotlight on DB2 6.9.3 - User Guide

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release Getting started with Spotlight on IBM DB2 LUW Desktop features specific to Spotlight on IBM DB2 LUW Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns Buffer Pool Analysis drilldown Client Application Analysis drilldown Database Analysis drilldown Database Manager Summary drilldown Diagnostic Log drilldown FCM Analysis drilldown Tablespace Analysis drilldown Top SQL drilldown Operating System drilldown Workload Management Analysis drilldown
Spotlight on IBM DB2 LUW alarms Spotlight on IBM DB2 LUW Options Tuning SQL statements in Spotlight on IBM DB2 LUW
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

State

The current state of the activity:

State

Description

CANCEL_PENDING

The WLM_CANCEL_ACTIVITY has canceled the activity because no agent was working on a request for the activity. The activity is actually canceled the next time a user issues a request as part of the activity.

EXECUTING

Agents are currently working on a request for the activity.

IDLE

No agent is currently processing a request for the activity.

INITIALIZING

A user has issued a request for the activity, but the activity has not started execution. At this point, predictive thresholds determine whether execution should proceed.

QP_CANCEL_PENDING

The query patroller has canceled the activity because no agent was working on a request for the activity. The activity is actually cancel the next time a user issues a request as part of the activity.

QP_QUEUED

The query patroller has placed the activity in a queue to await execution.

QUEUED

The Workload Manager has placed the activity in a threshold queue to await execution; or, in a PDF (database partitioning feature) environment, the activity is in the process of obtaining threshold tickets via a remote procedure call from the coordinator agent.

TERMINATING

Activity execution has just completed. DB2 is in the process of removing the activity.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione