Introduction
Fields
Stored in filecontrol
| SMF Field | DB Column name | Description | Unit |
|---|---|---|---|
| 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 | |
| A17FNAM | name | File name | |
| A17FLOC | location | Set to "R" if remote | |
| A17DT | data_table_fields |
|
|
| A17DSRLS | rls | RLS/Non-RLS Indicator R = RLS BLANK = NON-RLS |
|
| A17DSNAM | dataset_name | Dataset name | |
| A17DSRD | get_requests | GET requests | |
| A17DSGU | getupdate_requests | GET/UPDATE requests | |
| A17DSBR | browse_requests | Browse requests | |
| A17DSWRA | add_requests | ADD requests | |
| A17DSWRU | update_requests | UPDATE requests | |
| A17DSDEL | local_delete_requests | DELETE requests | |
| A17DSXCP | vsam_excp_requests_data | VSAM EXCP requests - DATA | |
| A17DSIXP | vsam_excp_requests_index | VSAM EXCP requests - INDEX | |
| A17DSTSW | wait_on_string_total | Wait on string total | |
| A17DSHSQW | wait_on_string_highest | Wait on string highest | |
| A17DTTYP | close_table |
|
|
| A17DTRDS | read_browse_requests | READ/BROWSE requests | |
| A17DTRNF | source_reads_issued | Source reads issued | |
| A17DTAVR | adds_resulting_from_reads | ADDs resultings from readsADDS RESULTING FROM READS | |
| A17DTADS | add_requests_via_api | ADD requests via API | |
| A17DTARJ | adds_rejected_by_exit | ADDs rejected by exit | |
| A17DTATF | adds_when_table_full | ADDs when table full | |
| A17DTRWS | rewrite_requests | Rewrite requests | |
| A17DTDLS | delete_requests | DELETE requests | |
| A17DTSHI | highest_table_record_count | Highest table record count | |
| A17DTSIZ | current_table_record_count | Current table record count | |
| A17DTALT | total_storage_allocated | Storage allocated - Total | kilobyte |
| A17DTUST | total_storagein_use | Storage in use - Total | kilobyte |
| A17DTALE | entries_storage_allocated | Storage allocated - Entries | kilobyte |
| A17DTUSE | entries_storage_in_use | Storage in use - Entries | kilobyte |
| A17DTALI | index_storage_allocated | Storage allocated - Index | kilobyte |
| A17DTUSI | index_storage_in_use | Storage in use - Index | kilobyte |
| A17ALD | data_storage_allocated | Storage allocated - Data | kilobyte |
| A17DTUSD | data_storage_in_use | Storage in use - Data | kilobyte |
| A17DTRRS | read_retries_for_a_sdt | READ retries for a SDT | |
| A17DSDNB | no_buffers_data | No buffers - Data | |
| A17DSINB | no_buffers_index | No buffers - Index | |
| A17POOL | lsrpool_id | LSRPOOL ID | |
| A17STRNO | no_strings | No strings | |
| A17RNAME | remote_name | Remote name | |
| A17RSYS | remote_sysid | Remote SYSID | |
| A17DSTYP | dataset_type | Dataset type | |
| A17DBSNM | base_dataset_name | Base dataset name | |
| A17DSASC | no_active_strings | No active strings | |
| A17DSASW | no_string_waits | No string waits | |
| A17LOPNT | file_open_time_local_stck | File open time (Local) | |
| A17LCLST | file_close_time_local_stck | File close time (Local) | |
| A17GOPNT | file_open_time_gmt_stck | File open time (GMT) | |
| A17GCLST | fileclosetimegmtstck | File close time (GMT) | |
| A17DSBRU | browse_for_update_count | Number of browse for UPDATE | |
| A17RLSWT | rls_request_wait_timeouts | RLS requests wait timeouts | |
| A17DTCON | number_of_changed_responses | Number of changed responses for a CFDT using contention, number of lock waits for a CFDT using locking | |
| A17DTCFP | coupling_facility_data_table | Coupling facility data table pool name | |
| A17DTLDS | number_of_loading_responses | Number of loading responses | |
| A17FCXCC | no_exclusive_control_conflicts | No exclusive control conflicts | |
| A17_FILE_DEFINE_SOURCE | group_installed_from | Group installed from | |
| A17_FILE_CHANGE_TIME | change_create_time | Change/Create time | |
| A17_FILE_CHANGE_USERID | change_userid | Change user ID | |
| A17_FILE_CHANGE_AGENT | change_agent | Change agent | |
| A17_FILE_INSTALL_AGENT | install_agent | Install agent | |
| A17_FILE_INSTALL_TIME | install_create_time | Install/Create time | |
| A17_FILE_INSTALL_USERID | install_userid | Install user ID |