Mainframe Server Component Implementation › Input Parameters › SQL Syntax Trace Example Output

SQL Syntax Trace Example Output

DBR: Statement for UserID: USERID01        .                       
DECLARE SQL_CUR_CA_1 CURSOR FOR select * from sysadm.muf_identity  
DBR: Statement for UserID: USERID02        .                             
DECLARE SQL_CUR_CA_1 CURSOR FOR select tab1.D_MUF_ENABLE, 
tab1.D_MUF_START_DATETIME, tab1.D_MUF_END_DATETIME, tab1.D_MUF_TYPE,      
tab1.D_MUF_TOTALROW, tab1.D_MUF_DURATION, tab1.MUF_NAME, 
tab1.ELAPSED_SECONDS,          tab1.CPU_SECONDS, tab1.DB_REQUESTS, tab1
.DATA_MGR_REQUESTS, tab1.REL_MGR_REQUESTS,          tab1.SQL_REQUESTS, 
tab1.REL_SQL_REQUESTS, tab1.PHYSICAL_IO, tab1.PHYSICAL_READS,         
tab1.REL_PHYS_READS, tab1.PHYSICAL_WRITES, tab1.REL_PHYS_WRITES, 
tab1.SEQ_READ_AHEAD,          tab1.REL_SEQ_READ_AHEAD, tab1.ACCOUNTING_IO, 
tab1.REL_ACCOUNTING_IO, tab1.LOGGING_IO,    tab1.REL_LOGGING_IO, 
tab1.IXX_USED_5, tab1.IXX_RATIO_5_TO_1, tab1.DXX_USED_5,          
tab1.DXX_RATIO_5_TO_1, tab1.DATA_USED_5, tab1.DATA_RATIO_5_TO_1, tab1.DATA2_USED_5,          tab1.DATA2_RATIO_5_TO_1, tab1.NO_IXX_BUFFER, 
tab1.NO_DXX_BUFFER, tab1.NO_DATA_BUFFER,          tab1.NO_EXPAND_BUFFER, 
tab1.NO_TXB_BUFFER, tab1.MEMORY_SIZE_V, tab1.MRDF_READS_V,          
tab1.REL_VIRTUAL_READS, tab1.VIRTUAL_WRITES, tab1.REL_VIRTUAL_WRITES,          
tab1.MEMORY_SIZE_C, tab1.MRDF_READS_C, tab1.REL_COVERED_READS, 
tab1.RECORD_LOCKS,          tab1.WAIT_LOCK, tab1.REL_WAIT_LOCK, 
tab1.SECONDARY_CONFLICT, tab1.REL_SEC_CONFLICT,          
tab1.INDIRECT_WAIT_IO, tab1.WAIT_TASK, tab1.WAIT_REQUEST, tab1.WAIT_SPILL,          
tab1.WAIT_ACCOUNTING, tab1.WAIT_SECURITY, tab1.DB_CODE_COUNT, 
tab1.SQL_CODE_COUNT,          tab1.INDEX_Q_OVERFLOW, tab1.IO_MEM_SHORT, 
tab1.LOG_PERCENT_FULL, tab1.LOGPEND_WRITES,          
tab1.LOG_WRITE_CONTROL, tab1.LOG_WRITE_FULL, tab1.LOG_WRITE_COMMAND, 
tab1.LOG_WRITE_OTHER,          tab1.LOG_WRITE_TXB, tab1.LOG_WRITE_2_PHASE, 
tab1.CBS_SPILLS, tab1.CBS_ENTRIES,          tab1.CBS_ENTRIES_USED, 
tab1.SETS_PROCESSED, tab1.SETS_WITH_T_INDEX, tab1.TEMP_INDEX_ENTRIES,          
tab1.BREAKS_DONE, tab1.RQ_PENDING_1_10, tab1.RQ_PENDING_11_20,
tab1.RQ_PENDING_21_30,          tab1.RQ_PENDING_31_40, 
tab1.RQ_PENDING_41_50, tab1.RQ_PENDING_GT_50, tab1.D_MUF_USERTAG           
from AUTOCOLLECT.D_BUSINESS_VALUE_DETAILS tab1