SMF 110-2 File Control
    • 04 Mar 2024
    • 2 Minutes to read
    • Contributors
    • Dark
      Light

    SMF 110-2 File Control

    • Dark
      Light

    Article summary

    Introduction

    Fields

    Stored in filecontrol

    SMF FieldDB Column nameDescriptionUnit
    record_typeValue is always C067
    SMFSIDsidSID
    SMFDTErecord_date_timeDatetime recorded
    SMFSSIDssidSSID
    SMFSTRVNprod_versionProd version
    SMFSTPRNproduct_nameProduct name (generic application ID)
    SMFSTSPNspecific_appl_idSpecific application ID
    SMFSTMFLrec_maintindicRecord maintenance indicator
    SMFSTDTKdom_tokenDomain token
    SMFSTDIDdom_idDomain ID
    SMFSTRQTuerir_stats_typeUSS/EOD/REQ/INT/RRT stats type
    SMFSTDATcollect_dateCollection date
    SMFSTCLTcollect_timeCollection time
    SMFSTINTinterv_timeInterval time
    SMFSTINOinterv_numberInterval number
    SMFSTRTKreq_tokenRequest token
    SMFSTLRTlast_reset_timeLast reset time
    SMFTCSTcics_start_timeCICS start time
    SMFSTJBNjob_nameJob name
    SMFSTRSDjob_reader_dateJob reader date
    SMFSTUIFuser_idUser ID
    SMFSTPDNos_product_levelOperating system product level
    A17FNAMnameFile name
    A17FLOClocationSet to "R" if remote
    A17DTdata_table_fields
    • R : Remote Table
    • S : Associated File
    • T : SDT
    • L : Coupling Facility (Locking Model)
    • K : Coupling Facility (Contention Model)
    • X : Updates via AIX
    A17DSRLSrlsRLS/Non-RLS Indicator
    R = RLS
    BLANK = NON-RLS
    A17DSNAMdataset_nameDataset name
    A17DSRDget_requestsGET requests
    A17DSGUgetupdate_requestsGET/UPDATE requests
    A17DSBRbrowse_requestsBrowse requests
    A17DSWRAadd_requestsADD requests
    A17DSWRUupdate_requestsUPDATE requests
    A17DSDELlocal_delete_requestsDELETE requests
    A17DSXCPvsam_excp_requests_dataVSAM EXCP requests - DATA
    A17DSIXPvsam_excp_requests_indexVSAM EXCP requests - INDEX
    A17DSTSWwait_on_string_totalWait on string total
    A17DSHSQWwait_on_string_highestWait on string highest
    A17DTTYPclose_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)
    A17DTRDSread_browse_requestsREAD/BROWSE requests
    A17DTRNFsource_reads_issuedSource reads issued
    A17DTAVRadds_resulting_from_readsADDs resultings from readsADDS RESULTING FROM READS
    A17DTADSadd_requests_via_apiADD requests via API
    A17DTARJadds_rejected_by_exitADDs rejected by exit
    A17DTATFadds_when_table_fullADDs when table full
    A17DTRWSrewrite_requestsRewrite requests
    A17DTDLSdelete_requestsDELETE requests
    A17DTSHIhighest_table_record_countHighest table record count
    A17DTSIZcurrent_table_record_countCurrent table record count
    A17DTALTtotal_storage_allocatedStorage allocated - Totalkilobyte
    A17DTUSTtotal_storagein_useStorage in use - Totalkilobyte
    A17DTALEentries_storage_allocatedStorage allocated - Entrieskilobyte
    A17DTUSEentries_storage_in_useStorage in use - Entrieskilobyte
    A17DTALIindex_storage_allocatedStorage allocated - Indexkilobyte
    A17DTUSIindex_storage_in_useStorage in use - Indexkilobyte
    A17ALDdata_storage_allocatedStorage allocated - Datakilobyte
    A17DTUSDdata_storage_in_useStorage in use - Datakilobyte
    A17DTRRSread_retries_for_a_sdtREAD retries for a SDT
    A17DSDNBno_buffers_dataNo buffers - Data
    A17DSINBno_buffers_indexNo buffers - Index
    A17POOLlsrpool_idLSRPOOL ID
    A17STRNOno_stringsNo strings
    A17RNAMEremote_nameRemote name
    A17RSYSremote_sysidRemote SYSID
    A17DSTYPdataset_typeDataset type
    A17DBSNMbase_dataset_nameBase dataset name
    A17DSASCno_active_stringsNo active strings
    A17DSASWno_string_waitsNo string waits
    A17LOPNTfile_open_time_local_stckFile open time (Local)
    A17LCLSTfile_close_time_local_stckFile close time (Local)
    A17GOPNTfile_open_time_gmt_stckFile open time (GMT)
    A17GCLSTfileclosetimegmtstckFile close time (GMT)
    A17DSBRUbrowse_for_update_countNumber of browse for UPDATE
    A17RLSWTrls_request_wait_timeoutsRLS requests wait timeouts
    A17DTCONnumber_of_changed_responsesNumber of changed responses for a CFDT using contention, number of lock waits for a CFDT using locking
    A17DTCFPcoupling_facility_data_tableCoupling facility data table pool name
    A17DTLDSnumber_of_loading_responsesNumber of loading responses
    A17FCXCCno_exclusive_control_conflictsNo exclusive control conflicts
    A17_FILE_DEFINE_SOURCEgroup_installed_fromGroup installed from
    A17_FILE_CHANGE_TIMEchange_create_timeChange/Create time
    A17_FILE_CHANGE_USERIDchange_useridChange user ID
    A17_FILE_CHANGE_AGENTchange_agentChange agent
    A17_FILE_INSTALL_AGENTinstall_agentInstall agent
    A17_FILE_INSTALL_TIMEinstall_create_timeInstall/Create time
    A17_FILE_INSTALL_USERIDinstall_useridInstall user ID

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.