Parameters with their status set in the code
The following table lists the parameters that directly set their status, and their status changes when conditions change. The product code sets the status variables for the parameters when you issue certain commands or when it detects that certain conditions exist. These internal status changes overwrite whatever changes are made through PATROL Configuration Manager.
Status for the DB2 UDB EE and DB2 UDB EEE parameters
Parameter | Status |
|---|---|
CheckConfig | This DB2_PARAM parameter monitors the validity of the user ID and password that has been configured to monitor each instance. When it determines that this monitoring user and password is not valid, all the parameters for the instance, excluding the CheckConfig parameter itself, are set to OFFLINE (set .../status, OFFLINE). The application classes under this instance are set to OFFLINE using the change_state() PSL function. The CheckConfig parameter, a standard parameter, continues to monitor. When it determines that the monitoring user and password is valid, all the instance parameters and application classes under this instance are set to OK. |
DB2ServerOK | The /DB2/instance > Database Administration > Database Modes > Start Database Manager menu command sets the /DB2_PARAM/ instance /DB2ServerOK status to OK (EE only). The DB2EEE_NODE > nodeNumberIcon, RMB > Acknowledge DB2ServerOK Alarmmenu command sets the /DB2EEE_NODE/ node_instance /DB2ServerOK parameter status to OK. This can be the current node or all nodes depending on the menu selection. TheDB2_PARAM>Acknowledge DB2ServerOK Alarm menu command sets the /DB2_PARAM/instance /DB2ServerOK parameter status to OK. The status of the /DB2_PARAM/DB2ServerOK parameter is set to ALARM during CollInstance collection for EE or Refresh Parameters from the DB2|DB2_PARAM icon under the following conditions:
|
DatabaseSize | /DB2/DB2DB_CAPACITY |DB2EEEDB_NODE_CAPACITY|DB2EEE_DB_PARAM/ DatabaseSize is set to OFFLINE if a value cannot be collected. This might be due to permissions accessing the file system (documented in online Help) or an SQL error that was returned from DB2. Status for the DB2EEE_DB_PARAM parameters are set to OFFLINE, excluding AveElapsedTime, ElapsedTime and DatabaseSize, when CollDatabase collection for EEE (or Refresh Parameters from the DB2EEE_DB_PARAM |DB2EEE_DB icon) does not occur due to any of the following:
|
Deadlocks | /DB2DB_LOCK|DB2EEE_DB_PARAM/Deadlocks text standard parameter status is set to ALARM when a deadlock is detected. PATROL Configuration Manager does not support the configuration of deadlock detection. The DB2DB_LOCK|DB2EEE_DB > Deadlock Detection > Pause Deadlock Detection menu command sets the Deadlocks parameter status to OFFLINE. The DB2DB_LOCK|DB2EEE_DB > Deadlock Detection > Acknowledge Deadlock Alarm menu command sets the Deadlocks parameter status to OK. |
AveElapsedTime ElapsedTime | The DB2DB_PERFORMANCE |DB2EEEDB_NODE_PERFORMANCE| DB2EEE_DB_PARAM > Advanced Performance Monitor > Remove menu command sets the .../AveElapsedTime and .../ElapsedTime parameters to OFFLINE. The DB2DB_PERFORMANCE| DB2EEEDB_NODE_PERFORMANCE| DB2EEE_DB_PARAM > Advanced Performance Monitor > Stop menu command sets the status of the .../AveElapsedTime and .../ElapsedTime parameters to OFFLINE. The status of the (DB2DB_PERFORMANCE| DB2EEEDB_NODE_PERFORMANCE| DB2EEE_DB_PARAM) AveElapsedTime and ElapsedTime parameters is set to OFFLINE when (DB2UDB_COLLECTORS|DB2EEE_COLLECTORS) CollPerformance determines that the specified number of execution times has been completed. You can specify how many times you want collection to run; see Advanced Performance Monitor > Configure (under Scheduling). |
TableSpaceIO | The DB2DB_PERFORMANCE| DB2EEEDB_NODE_PERFORMANCE > Table Space I/O Monitor > Configure menu command sets the .../TableSpaceIO parameter status to OFFLINE. The DB2DB_PERFORMANCE| DB2EEEDB_NODE_PERFORMANCE > Table Space I/O Monitor > Start menu command sets the .../TableSpaceIO parameter status to OK. TheDB2DB_PERFORMANCE| DB2EEEDB_NODE_PERFORMANCE > Table Space I/O Monitor > Stop menu command sets the .../TableSpaceIO parameter status to OFFLINE. |
InDoubtTrans | The DB2DB_RECOVERY| DB2EEEDB_NODE_RECOVERY > Indoubt Transaction Monitor > Acknowledge Alarm menu command sets the .../InDoubtTrans parameter status to OK. The DB2DB_RECOVERY| DB2EEEDB_NODE_RECOVERY > Indoubt Transaction Monitor > Stop menu command sets the .../InDoubtTrans parameter status to OFFLINE. The DB2EEEDB_NODE_RECOVERY/ DB2DB_RECOVERY > Indoubt Transaction Monitor > Start menu command sets the .../InDoubtTrans parameter status to OK. If Indoubt Transaction monitoring is started (by a menu command or /DB2Config/.../indoubt) and no indoubt transactions are reported during CollDatabase collection, the InDoubtTrans parameter status is set to OK. The Start Indoubt Monitor and Process Indoubt Transactions menu commands are currently disabled. |
ReorgCheck | The DB2DB_RECOVERY |DB2EEEDB_NODE_RECOVERY > Reorg Check > Acknowledge Alarm menu command sets the .../ReorgCheck parameter status to OK. TheDB2DB_RECOVERY |DB2EEEDB_NODE_RECOVERY > Reorg Check > Configure menu command sets the .../ReorgCheck parameter status as follows:
The DB2DB_RECOVERY| DB2EEEDB_NODE_RECOVERY/ ReorgCheck parametercollection code sets the ReorgCheck parameter status to ALARM. If the parameter has met the criteria of the configuration, its value is set to 1. ReorgCheck is a standard parameter. |
BackupCount | The DB2DB_RECOVERY| DB2EEEDB_NODE_RECOVERY > Backup Monitor > Configuremenu command sets the .../BackupCount parameter status as follows:
|
BackupTime | The DB2DB_RECOVERY| DB2EEEDB_NODE_RECOVERY > Backup Monitor > Configuremenu command sets the .../BackupTime parameter status as follows:
|
InDoubtTrans AveElapsedTime ElapsedTime TableSpaceIO | The DB2UDB_COLLECTORS| DB2EEE_COLLECTORS/ConfigUpdates parameter executes if /DB2Config/KMConfigUpdated is detected. Then, the following actions occur:
|
DiagLogOK | If Automatic Alarm Acknowledgment is enabled for (DB2_DIAGLOG|DB2EEE_DIAGLOG)DiagLogOK through Configuration > Configure KM Defaults > DB2 Global Settings (/DB2Config/DB2|DB2EEE/AutoAckDiagLogOK ) and the DiagLogOK parameter is in the ALARM state, its status is set to OK. For DB2_DIAGLOG|DB2EEE_DIAGLOG parameters, if CollDiaglog collection finds that the .../db2diag.log file does not exist, the DB2_DIAGLOG|DB2EEE_DIAGLOG parameters have their status set to OFFLINE excluding DiagLogOK. The status of the (DB2_TSP|DB2EEE_TSP) PhyReads/PhyWrites parameters is set to OK when the(DB2_DIAGLOG|DB2EEE_DIAGLOG) > Acknowledge DigLogOK Alarm menu command is selected. |
ProblemDB2Agents | If Automatic Alarm Acknowledgment is enabled for (DB2_PARAM|DB2EEE_PARAM)ProblemDB2Agents through Configuration > Configure KM Defaults > DB2 Global Settings (/DB2Config/DB2|DB2EEE/ AutoAckProblemDB2Agents ), and the ProblemDB2Agents parameter is in the ALARM state, its status is set to OK. |
DB2ServerOK | If DB2ServerOK parameter action has been configured through Configuration > Configure KM Defaults > DB2 Instance Settingsto Restart Server if the following file does not exist, its status changes as follows:
Status of the DB2EEE_NODE parameters, excluding ChannelFailures and DB2ServerOK, is set to OFFLINE during (DB2EEE_COLLECTORS) CollInstance collection andDB2EEE_NODE > Refresh Parameters menu command execution if any of the following conditions exists:
If no problems are found during execution of the (DB2EEE_COLLECTORS) CollInstancecollection and the DB2EEE_NODE > Refresh Parameters menu command, the DB2ServerOK parameter status is set to OK. During (DB2EEE_COLLECTORS) CollInstance collection and execution of the DB2EEE_NODE > Refresh Parameters menu command, when FCMBufferPoolUtil, FCMMsgAnchorUtil, FCMConnEntryUtil, FCMReqBlockUtil, PctActiveFCMConns are not collected because only one node is configured for the instance, the DB2ServerOK parameter status is set to OFFLINE. |
DB2ServerOK | The status of the /DB2_PARAM/DB2ServerOK parameter is set to OK during CollInstance collection for EE or Refresh Parameters from the DB2|DB2_PARAM icon if the SQL1032 or SQL1224 errors are not found. |
PostThreshSorts | If the sort monitor switch is not set during (DB2EEE_COLLECTORS) CollInstance collection and execution of the DB2EEE_NODE > Refresh Parameters menu command, the PostThreshSorts parameter status is set to OFFLINE. The status of this DB2EEE_PARAM parameter is set to OFFLINE if the sort monitor switch is not set during CollInstance collection for EEE or Refresh Parameters from the DB2EEE|DB2EEE_PARAM icon. The status is set to OFFLINE during CollInstance collection for EE or Refresh Parameters from the DB2|DB2_PARAM icon if the sort monitor switch is not set. |
PctAgentsRegd PctAgentsIdle | If the MAXAGENTS dbm configuration variable is not set (maxagents == " ") during (DB2EEE_COLLECTORS) CollInstance collection and execution of the DB2EEE_NODE > Refresh Parameters menu command, the status of the PctAgentsRegd and PctAgentsIdle parameters is set to OFFLINE. The status of these DB2EEE_PARAM parameters are set to OFFLINE during CollInstance collection for EEE or Refresh Parameters from the DB2EEE|DB2EEE_PARAM icon if the MAXAGENTS dbm configuration variable is not set (maxagents == " "). The status is set to OFFLINE during CollInstance collection for EE or Refresh Parameters from the DB2|DB2_PARAM icon if the MAXAGENTS dbm configuration variable is not set (maxagents == " "). |
ApplIdleTime CpuUtil NumApplDeadlocks NumApplLockTimeouts SystemCPUTimebyAgent UserCPUTimebyAgent | Shipped Active for DB2_AGENT|DB2EEE_AGENT | DB2EEE_SUBAGENT. The DB2_AGENT|DB2EEE_AGENT |DB2EEE_SUBAGENT parameters are set to OFFLINE if they are not collected during (DB2UDB_COLLECTORS|DB2EEE_COLECTORS) CollAgent or execution of theDB2_AGENT|DB2EEE_AGENT|DB2EEE_SUBAGENT Refresh Parameters menu command. You can activate the remaining parameters if you are interested in monitoring them. Parameter data is not collected when the specific monitor switch affecting them is OFF. See specific parameter online Help for monitor switch dependency.
|
AveDirReadTime AveDirWriteTime AveNumPgsReadPerAsyncReq AveNumSectorsRead AveNumSectorsWritten AvePgCleanWriteTime AvePgReadTime AvePgWriteTime AvePrefetchReadTime AveSyncBPReadTime BPDataPgCleanEff BPDataWriteReadRatio BPIndxPgCleanEff BPIndxWriteReadRatio BufferPoolHitRatio DataPgHitRatio DBPrefetchEffRatio IndxPgHitRatio SyncBPHitRatio | DB2EEE_BP_NODE parameters are set to OFFLINE if they are not collected during CollBufferpool collection. These parameters are not collected when the BUFFERPOOL switch is OFF. |
AppsConnToDB | DB2EEEDB_NODE_CAPACITY|DB2DB_CAPACITY/ AppsConnToDB parameter is set to OFFLINE except when a SQL1611 error is returned (no applications connected to database). If CollDatabase collection does not occur due to sockets failure, channel failure, or SQL error, such as 1611W (no data returned, often caused by no application connected to database) or 1032N (no database manager started), then the following parameters are set to OFFLINE:
Parameters collected by CollDatabase are set OFFLINE if not collected. They are not collected if the monitor switch governing their collection is OFF. See specific parameter online Help for monitor switch requirement. |
ResponseExecTime | Status is set to OFFLINE if ResponseExecTime is not enabled through (DB2DB_PERFORMANCE| DB2EEEDB_NODE_PERFORMANCE)/ ResponseExecTime during CollDatabase collection. This is the default setting. See the Performance > ResponseExecTime Monitor > Enable/Disable menu command for more details. (DB2DB_PERFORMANCE| DB2EEEDB_NODE_PERFORMANCE)/ ResponseExecTime parameter status is set to OFFLINE during CollDatabase collection if any of the following conditions are true:
The DB2EEE_DB_PARAM)/ResponseExecTime parameter status is set to OFFLINE during CollDatabase collection for EEE (or Refresh Parameters from the DB2EEE_DB_PARAM|DB2EEE_DB icon) if ResponseExecTime is not enabled. This is the default setting; see DB2EEE_DB_PARAM > ResponseExecTime Monitor > Enable/Disablemenu command for more details. |
ResponseExecTime | The (DB2EEE_DB_PARAM)/ResponseExecTime parameter is set to OFFLINE during CollDatabase collection for EEE (or Refresh Parameters from the DB2EEE_DB_PARAM|DB2EEE_DB icon), if ResponseExecTime is enabled and no command is found in the .../db2/response.sql* file. ResponseExecTime is enabled from theDB2EEE_DB_PARAM > ResponseExecTime Monitor > Enable menu command or by the /DB2Config/DB2EEE_DB_PARAM/ MonitorResponseExecTime configuration variable. The (DB2DB_PERFORMANCE|DB2EEE_DB_PARAM)/ ResponseExecTime parameter is set to OFFLINE during CollDatabase collection if ResponseExecTime is enabled, the.../db2/response.sql* file does not exist, and the PSL code is unable to create the file. CollDatabase is initiated for EEE (or by the Refresh Parameters from the DB2EEE_DB_PARAM |DB2EEE_DB icon). The (DB2EEE_DB_PARAM)/ResponseExecTime parameter status is set to OFFLINE during CollDatabase collection for EEE (or Refresh Parameters from the DB2EEE_DB_PARAM|DB2EEE_DB icon), if ResponseExecTime is enabled and DB2 returns SQL1032 (database manager not started). |
AgentsRegd ARATest CommittedPrivateMem FCMBufferPoolUtil FCMConnEntryUtil FCMMsgAnchorUtil FCMReqBlockUtil LocConnExecInDBM LocConnectsToDBM MaxAgentOverflows MaxAgentsRegd MaxAgentsWaiting MaxCoordAgents NumIdleAgents PctAgentsFromPool PctAgentsIdle PctAgentsRegd PctAgentsWaitForTkn PctPipedSortReqsAcc PostThreshSorts RemConnExecInDBM RemConnectsToDBM TotSortHeapAlloc UpdateAgentAppFiles | The status of the DB2EEE_DB_PARAM parameters (excluding ChannelFailures, CheckConfig, DB2AllServersOK, KMSocketsOK, and ProblemDB2Agents) is set to OFFLINE if CollInstance collection for EEE or Refresh Parameters from the DB2EEE|DB2EEE_PARAM icon does not occur due to
Under these conditions the DB2_PARAM parameters are set to OFFLINE, excluding ChannelFailures, CheckConfig, DB2ServersOK, and ProblemDB2Agents. |
FCMBufferPoolUtil FCMMsgAnchorUtil FCMConnEntryUtil FCMReqBlockUtil | The status for these DB2EEE_PARAM parameters is set to OFFLINE when CollInstance collection for EEE (or Refresh Parameters from DB2EEE|DB2EEE_PARAM icon) does not collect data for them due to having only one node configured for the instance. |
PctPagesUsed SpaceLeft | The status of the (DB2_TSP|DB2EEE_TSP) PctPagesUsed and SpaceLeft parameters are set to OFFLINE if (DB2UDB_COLLECTORS|DB2EEE_COLLECTORS) CollTablespaces could not determine the available space for SMS tablespaces. This status is due to a permissions issue. For further reference, see the online Help for PctPagesUsed and SpaceLeft. The status of the (DB2_TSP|DB2EEE_TSP) PctPagesUsed and SpaceLeft parameters is set to OFFLINE during (DB2UDB_COLLECTORS|DB2EEE_COLLECTORS) CollTablespaces for SMS tablespace and Remote Database. If an SQL error occurs for (DB2UDB_COLLECTORS|DB2EEE_COLLECTORS) CollTablespaces, all DB2_TSP|DB2EEE_TSP parameters are set to OFFLINE. The status for all the DB2_TSP|DB2EEE_TSP parameters is set to OFFLINE during (DB2UDB_COLLECTORS|DB2EEE_COLLECTORS) CollTablespaces if a SQL error occurs. |
PhyReads and PhyWrites | When collecting tablespace data for the PhyReads and PhyWrites parameters with (DB2UDB_COLLECTORS | DB2EEE_COLLECTORS) CollTablespaces, the status of the (DB2_TSP|DB2EEE_TSP) PhyReads and PhyWrites parameters are set to OFFLINE if any of the following events occur:
The cause might be the BUFFERPOOL switch being set to OFF. See the online Help for PhyReads and PhyWrites. |