Sampled and on-demand tables
Sampled and on-demand tables list the tables that are used in IBM® MQ Monitoring Agent, their data collection mode, and their supported operating systems. Data collection is categorized as follows:
- Sampled
- This data is collected regularly at a specific time interval. Data that is returned by a query that uses sampled data represents values that are recorded during the sample interval processing. Please see the SAMPINT parameter setting for the sample interval that the agent is using. Note that for most sampled data, there are three levels of data: current, recent, and historical. The table available for situations and main workspaces contains the most current sample of data. The so-called short-term history table contains recent samples of data for several intervals as maintained in agent memory. The so-called long-term history table is used for historical collection recording and display. .
- On-demand
- For on-demand data, the same table is used for situations, workspaces and historical collection recording and display.
- Background-collected
- This data is collected in the background when it is published by the queue manager (in events or accounting and statistics reports). Querying this data results in a maximum of one row of data per event or queue manager report returned (depending on the query parameters). Most of this data is optionally produced by the queue manager according to the parameter settings in the queue manager. Some of the data is produced by the queue manager on an interval basis, and there are parameters for the queue manager that control the length of the interval. See Data collection for workspaces for more information about setting queue manager parameters to produce this data.
Attribute group name | Data collection type | Applicable for Historical/ODP data recording | Supported operating systems | Table Name |
---|---|---|---|---|
Application Connections | On-demand | Yes | All | QMCONNAPP |
Application Debug Trace | Sampled | No | z/OS® systems | QM_DETR |
Application Debug Trace Details | Sampled | No | z/OS systems | QM_DETD |
Application Debug Trace Selection | Sampled | No | z/OS systems | QM_DETS |
Application Long-Term History | Sampled | Yes | z/OS systems | QM_APAL |
Application Short-Term History | Sampled | No | z/OS systems | QM_APAS |
Application Statistics | Sampled | No | z/OS systems | QM_APAI |
Application Queue Long-Term History | Sampled | Yes | z/OS systems | QM_APQL |
Application Queue Short-Term History | Sampled | No | z/OS systems | QM_APQS |
Application Queue Statistics | Sampled | No | z/OS systems | QM_APQU |
Application Topology | On-demand | No | All | QMAPPTOP |
Application Transaction/Program Long-Term History | Sampled | Yes | z/OS systems | QM_APTL |
Application Transaction/Program Short-Term History | Sampled | No | z/OS systems | QM_APTS |
Application Transaction/Program Statistics | Sampled | No | z/OS systems | QM_APTI |
Buffer Manager Long-Term History | Sampled | Yes | z/OS systems | QMLHBM |
Buffer Manager Short-Term History | Sampled | No | z/OS systems | QMSHBM |
Buffer Pools | Sampled | No | z/OS systems | QMBUFFS |
Channel Data | On-demand | Yes | All | QMCH_DATA |
Channel Definitions | Sampled | Yes | All | QMCHANNEL |
Channel Definition Details | On-demand | No | All | QMCH_DEF |
Channel Initiator Detail | Sampled | Yes | z/OS systems | QMCHANIN |
Channel Initiator Control | Sampled | Yes | z/OS systems | QMCHINCTL |
Channel Initiator Tasks | Sampled | Yes | z/OS systems | QMCHINTSK |
Channel Long-Term History | Sampled | Yes | All | QMCH_LH |
Channel Short-Term History | Sampled | No | All | QMCH_SH |
Channel Statistics | Sampled | No | All | QMCHANS |
Channel Status | On-demand | Yes | All | QMCHAN_ST |
Channel Summary | Sampled | Yes | All | QMCHAN_SUM |
Connection Objects | On-demand | Yes | All | QMCONNOBJ |
Current Events | Background-collected | No | All | QMEVENTC |
Current Queue Manager Status | On-demand | Yes | All | QMCURSTAT |
Event Archive | Background-collected | Yes | All | QMEVENTL |
Event details | Background-collected | No | All | QMEV_DET |
Event History | Background-collected | No | All | QMEVENTH |
Listener Status | On-demand | Yes | All systems | QMLSSTATUS |
Log Data Set Status | On-demand | Yes | z/OS systems | QMDSPUSAGE |
Log Manager Long-Term History | Sampled | Yes | z/OS systems | QMLHLM |
Log Manager Short-Term History | Sampled | No | z/OS systems | QMSHLM |
Managers | Sampled | No | All | QMANAGER |
Manager Definition Details | Sampled | No | All | QMAN_DEF |
Message Data | On-demand | No | All | QMMSG_DATA |
Message Delete | On-demand | No | All | QMMSG_DEL |
Message Details | On-demand | No | All | QMMSG_DET |
Message Manager Long-Term History | Sampled | Yes | z/OS systems | QMLHMM |
Message Manager Short-Term History | Sampled | No | z/OS systems | QMSHMM |
Message Retry | On-demand | No | All | QMMSG_RET |
Message Statistics | On-demand | Yes | All | QMMSG_STAT |
Message Summary | On-demand | No | All | QMMSG_SUM |
MQSeries® Events | Background-collected | No | All | QMEVENTP |
MQ Action Log | Background-collected | Yes | All | QMACTLOG |
Namelist | On-demand | Yes | All | NAMELIST |
Object Attribute Details | On-demand | No | All | QMATTR |
Page Sets | Sampled | No | z/OS systems | PAGESETS |
Page Set Long-Term History | Sampled | Yes | z/OS systems | QMPS_LH |
Page Set Short-Term History | Sampled | No | z/OS systems | QMPS_SH |
Process Information | On-demand | Yes | z/OS systems | QMPROC |
Publish Subscribe Status | On-demand | Yes | All | QMPUBSUB |
QSG Coupling Facility Structure Backups | Sampled | Yes | z/OS systems | QSG_CFBKUP |
QSG Coupling Facility Structure Connections | Sampled | Yes | z/OS systems | QSG_CFCONN |
QSG Coupling Facility Structures | Sampled | Yes | z/OS systems | QSG_CFSTR |
QSG Channels | Sampled | Yes | z/OS systems | QSG_CHANS |
QSG QMgrs | Sampled | Yes | z/OS systems | QSG_QMGR |
QSG Queues | Sampled | Yes | z/OS systems | QSG_QUEUES |
QSG CF Structure SMDS Status | Sampled | Yes | z/OS systems | QSG_CFSMDS |
QSG CF Structure SMDS Connections | Sampled | Yes | z/OS systems | QSG_SMDSCN |
Queue Data | On-demand | Yes | All | QMQ_DATA |
Queue Definition Details | On-demand | No | All | QMQ_DEF |
Queue Definitions | Sampled | Yes | All | QMQUEUE |
Queue Handle Status | On-demand | Yes | All | QMQ_HDL_ST |
Queue Long-Term History | Sampled | Yes | All | QMQ_LH |
Queue Short-Term History | Sampled | No | All | QMQ_SH |
Queue Statistics | Sampled | No | All | QMQUEUES |
Queue Status | On-demand | Yes | All | QMQ_QU_ST |
SMDS Long-Term History | Sampled | Yes | z/OS systems | LH_SMDS |
SMDS Short-Term History | Sampled | No | z/OS systems | SH_SMDS |
SMDS Statistics | Sampled | No | z/OS systems | SMDS_STATS |
SMDS Usage | On-demand | Yes | z/OS systems | QMSMDS |
SMF Data | Sampled | No | z/OS systems | QM_SMF |
Subscription Definitions | On-demand | Yes | All | QMSUBDEF |
Subscription Status | On-demand | Yes | All | QMSUBST |
TCPIP Started Listeners | Sampled | Yes | z/OS systems | QMLISTEN |
Topic Definitions | On-demand | Yes | All | QMTPCDEF |
Topic Manager Long-Term History | Sampled | Yes | z/OS systems | QMLHTM |
Topic Manager Short-Term History | Sampled | No | z/OS systems | QMSHTM |
Topic Publishers | On-demand | Yes | All | QMTPCPUB |
Topic Status | On-demand | Yes | All | QMTPCST |
Topic Subscribers | On-demand | Yes | All | QMTPCSUB |