Login
        Contents x
        SMF 110-2 DB2 Entry stats
        • 04 Mar 2024
        • 2 Minutes to read
        • Contributors
        • Print
        • Dark
          Light
        Contents

        SMF 110-2 DB2 Entry stats

        • Updated on 04 Mar 2024
        • 2 Minutes to read
        • Contributors
        • Print
        • Dark
          Light
        Article summary

        Introduction

        Fields

        Stored in db2entrystats

        SMF FieldDB Column nameDescription
        record_typeValue is always C103
        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
        D2R_DB2ENTRY_NAMEnameName of the installed DB2ENTRY
        D2R_PLAN_NAMEplan_nameName of the plan
        D2R_PLANEXIT_NAMEplan_exit_nameName of the dynamic plan exit
        D2R_AUTHIDauth_idID to be used for security checking
        D2R_AUTHTYPEauth_typeAuth type
        1. Not Applicable
        2. User ID
        3. OPID
        4. Group
        5. Sign ID
        6. Term
        7. TXID
        D2R_ACCOUNTRECacco_untrecAccount rec setting
        1. None
        2. TXID
        3. Task
        4. UOW
        D2R_THREADWAITthread_awaitThread wait setting
        1. Yes
        2. No
        D2R_PRIORITYpriorityThread Priority
        1. Not Applicable
        2. HIGH
        3. EQUAL
        4. LOW
        D2R_CALLScallsNumber of SQL calls
        D2R_SIGNONSsignonsNumber of DB2 sign-ons performed
        D2R_COMMITScommitsNumber of two phase commits performed for units of work using this DB2ENTRY
        D2R_ABORTSabortsNumber of units of work using this DB2ENTRY that were rolled back
        D2R_SINGLE_PHASEsingle_phaseNumber of units of work using the DB2ENTRY that used single-phase commit, either because they were read-only UOWs, or because DB2 was the only recoverable resource updated in the UOW
        D2R_THREAD_REUSEthread_reuseNumber of times CICS transactions using the DB2ENTRY were able to reuse an already created Db2 thread
        D2R_THREAD_TERMthread_termNumber of terminate thread requests made to Db2 for threads of this DB2ENTRY
        D2R_THREAD_WAIT_OR_OVERFLthread_wait_or_overflowNumber of times all available threads in the DB2ENTRY were busy and a transaction had to wait for a thread to become available, or overflow to the pool and use a pool thread instead
        D2R_THREAD_LIMITthread_limitMaximum number of threads allowed
        D2R_THREAD_CURRENTthread_currentNumber of active threads
        D2R_THREAD_HWMthread_hwmPeak number of active threads
        D2R_PTHREAD_LIMITp_thread_limitMaximum number of protected threads allowed
        D2R_PTHREAD_CURRENTp_thread_currentNumber of protected threads
        D2R_PTHREAD_HWMp_thread_hwmPeak number of protected threads
        D2R_TASK_CURRENTtask_currentNumber of CICS tasks
        D2R_TASK_HWMtask_hwmPeak number of CICS tasks
        D2R_TASK_TOTALtask_totalNumber of completed tasks
        D2R_READYQ_CURRENTreadyq_currentNumber of CICS tasks waiting for a thread to become available
        D2R_READYQ_HWMreadyq_hwmPeak number of CICS tasks that waited for a thread to become available
        D2R_PARTIAL_SIGNONSpartial_signonsNumber of DB2 partial sign-ons performed
        D2R_THREAD_CREATEthread_createNumber of create thread requests made to DB2
        D2R_REUSELIMIT_COUNTreuselimit_countNumber of times the reuselimit has been reached by a thread
        D2R_DEFINE_SOURCEdefine_sourceGroup installed from
        D2R_CHANGE_TIMEchange_timeChange/Create time
        D2R_CHANGE_USERIDchanger_user_idChange user ID
        D2R_CHANGE_AGENTchange_agentChange agent
        D2R_INSTALL_AGENTinstall_agentInstall agent
        D2R_INSTALL_TIMEinstall_timeInstall/Create time
        D2R_INSTALL_USERIDinstall_user_idInstall user ID
        What's Next
        Change password!
        Changing your password will log you out immediately. Use the new password to log back in.
        Change profile
        Success!
        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.
        Logout