Introduction
Fields
Stored in mqconnection
| SMF Field | DB Column name | Description |
|---|---|---|
| record_type | Value is always C067 | |
| SMFSID | sid | SID |
| SMFDTE | record_date_time | Datetime recorded |
| SMFSSID | ssid | SSID |
| SMFSTRVN | prod_version | Prod version |
| SMFSTPRN | product_name | Product name (generic application ID) |
| SMFSTSPN | specific_appl_id | Specific application ID |
| SMFSTMFL | rec_maintindic | Record maintenance indicator |
| SMFSTDTK | dom_token | Domain token |
| SMFSTDID | dom_id | Domain ID |
| SMFSTRQT | uerir_stats_type | USS/EOD/REQ/INT/RRT stats type |
| SMFSTDAT | collect_date | Collection date |
| SMFSTCLT | collect_time | Collection time |
| SMFSTINT | interv_time | Interval time |
| SMFSTINO | interv_number | Interval number |
| SMFSTRTK | req_token | Request token |
| SMFSTLRT | last_reset_time | Last reset time |
| SMFTCST | cics_start_time | CICS start time |
| SMFSTJBN | job_name | Job name |
| SMFSTRSD | job_reader_date | Job reader date |
| SMFSTUIF | user_id | User ID |
| SMFSTPDN | os_product_level | Operating system product level |
| MQG_QMGR_NAME | queue_manager_name | Queue manager name |
| MQG_MQ_RELEASE | mq_vvrr_release | Release of MQ VVRR |
| MQG_CONNECTION_STATUS | connection_status | Connection status
|
| MQG_RESYNCMEMBER | resync_member | Resync member setting
|
| MQG_INITIATION_QUEUE | init_queue | Initiation queue name |
| MQG_TTASKS | tasks | Number of current tasks |
| MQG_TFUTILEATT | futile_attempts | Number of futile attempts |
| MQG_TAPI | total_calls | Number of calls |
| MQG_TAPIOK | total_calls_comp_o_k | Number of calls comp ok |
| MQG_TCALL | total_flows | Number of flows |
| MQG_TCALLSYNCCOMP | total_calls_comp_sync | Number of calls comp sync |
| MQG_TCALLIO | total_calls_need_i_o | Number of calls need I/O |
| MQG_TWAITMSG | total_real_get_wait | Number of real GET wait |
| MQG_TSUBTASKED | total_calls_switched | Number of calls switched |
| MQG_TOPEN | total_open | Number of OPEN |
| MQG_TCLOSE | total_close | Number of CLOSE |
| MQG_TGET | total_get | Number of GET |
| MQG_TGETWAIT | total_get_wait | Number of GET wait |
| MQG_TPUT | total_put | Number of PUT |
| MQG_TPUT1 | total_put1 | Number of PUT1 |
| MQG_TINQ | total_inq | Number of INQ |
| MQG_TSET | total_set | Number of SET |
| MQG_INDOUBTUOW | indoubt_u_o_ws | Number of indoubt units of work |
| MQG_UNRESOLVEDUOW | unresolved_u_o_ws | Number of unresolved units work |
| MQG_RESOLVECOMM | resolved_committed_u_o_ws | Number of resolved committed UOWs |
| MQG_RESOLVEBACK | resolved_backout_u_o_ws | Number of resolved backout UOWs |
| MQG_TBACKUOW | total_resolved_backout_u_o_ws | Number of backout UOWs |
| MQG_TCOMMUOW | total_committed_u_o_ws | Number of committed UOWs |
| MQG_TTASKEND | total_tasks | Number of tasks |
| MQG_TSPCOMM | total_single_phase_comms | Number of single phase comms |
| MQG_T2PCOMM | total2_phases_comms | Number of 2 phase comms |
| MQG_TCB | total_c_b | Number of MQG_TCB |
| MQG_TCONSUME | total_consumed_msgs | Number of message consumed |
| MQG_TCTL | total_ctl | Number of MQCTL calls issued |
| MQG_TSUB | total_su_b | Number of MQSUB calls issued |
| MQG_TSUBRQ | total_subrq | Number of MQSUBRQ calls issued |
| MQG_TSTAT | total_stat | Number of MQSTAT calls issued |
| MQG_TCRTMH | total_crtmh | Number of MQCRTMH calls issued |
| MQG_TDLTMH | total_dltmh | Number of MQDLTMH calls issued |
| MQG_TSETMP | total_setmp | Number of MQSETMPH calls issued |
| MQG_TINQMP | total_inqmp | Number of MQINQMP calls issued |
| MQG_TDLTMP | total_dltmp | Number of MQDLTMP calls issued |
| MQG_TMHBUF | total_mhbuf | Number of MQMHBUF calls issued |
| MQG_TBUFMH | total_bufmh | Number of MQBUFMH calls issued |
| MQG_MQCONN_NAME | total_mqcon_n | Name of the installed MQCONN definition for the CICS region, which defines the attributes of the connection between CICS and WebSphere MQ |
| MQG_MQNAME | mq_name_from_mq_conn | Name of the WebSphere MQ queue manager or queue-sharing group |
| MQG_CONNECT_TIME_GMT | connect_time_gmt | Connection time (GMT) |
| MQG_CONNECT_TIME_LOCAL | connect_time_local | Connection time (Local) |
| MQG_DISCONNECT_TIME_GMT | disconnect_time_gmt | Disconnection time (GMT) |
| MQG_DISCONNECT_TIME_LOCAL | disconnect_time_local | Disconnection time (Local) |
| MQG_MQCONN_DEFINE_SOURCE | group_installed_from | Group installed from |
| MQG_MQCONN_CHANGE_TIME | change_create_time | Change/Create time |
| MQG_MQCONN_CHANGE_USERID | change_user_id | Change user ID |
| MQG_MQCONN_CHANGE_AGENT | change_agent | Change agent |
| MQG_MQCONN_INSTALL_AGENT | install_agent | Install agent |
| MQG_MQCONN_INSTALL_TIME | install_create_time | Install/Create time |
| MQG_MQCONN_INSTALL_USERID | install_user_id | Install user ID |