--- title: "SMF 110-2 File Control" slug: "smf-110-2-file-control" updated: 2024-03-04T15:08:39Z published: 2024-03-04T15:08:39Z canonical: "docs.zetaly.io/smf-110-2-file-control" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.zetaly.io/llms.txt > Use this file to discover all available pages before exploring further. # SMF 110-2 File Control ## 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 | - R : Remote Table - S : Associated File - T : SDT - L : Coupling Facility (Locking Model) - K : Coupling Facility (Contention Model) - X : Updates via AIX | | | 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 | - C : CICS Maintained Table close - S : User Table Source close - P : CICS Table Partial close - U : User Maintained Table close - L : Coupling Facility Table close (Locking Model) - K : Coupling Facility Table close (Contention Model) | | | 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 | |