Report - MUF Available and Operational

AUTOINFO (Collect Environmental MUF Information) › Overview › Sample Reports › Report - MUF Available and Operational

Report - MUF Available and Operational

When the MUF is available and operational, you receive a report similar to the following:

CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 AUTOINFO DDNAME=TABLES FUNCTION=AUTOINFO DDNAME=TABLES

This page of the report shows the following:

The command exactly as entered.
An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.
Any messages related to syntax processing.

MUF IS AVAILABLE, INFORMATION IS PROVIDED BY THE MUF. MUFNAME: MUF4 VERSION: 14.0 JOB/STC NAME: QA12MUF4 CXXNAME: QAMUF4 JOBID: JOB11528 SYSTEM: CA31 ENABLED TIME: 2008/11/11 13:12:17 CURRENT MUF TIME: 2008/11/11 13:14:59 MUF IS SHADOW: N MUF HAS SHADOW: N DB SUBSYS PRESENT: Y SQL: Y EXTERNAL SECURITY: N ACCOUNTING ON: N DBIDS: DST: 1000 HISTORY: 1007 CBS TEMP: 0006 CBS HEUR: 1006 TASKS: TOTAL: 00250 XCF: 00250 CCI: 00050 SIZE: 46080

TABLE MUF_OPTIONS: MFO ACCTPRM_PRM_DBID 0 ACCTPRM_ANN_DBID 0 ACCTPRM_CPU_TIME Y ...etc.

TABLE MUF_COVEREDVIRTUAL: MFC DBID AREA V/C F/A DS MEM_SIZE BLKS_MAX BLKS_CURR TOTAL_READS MRDF_READS VIRT_WRITES ACTV_READS NONF_READS 6 IXX V N X 262144000 64000 64000 2 2 0 NULL NULL 17 IXX V N N 32768 NULL NULL NULL NULL NULL NULL NULL 17 TTM V N N 33554432 NULL NULL NULL NULL NULL NULL NULL TOT V N N 295731200 64000 64000 2 2 0 0 0 TOT C N N 0 0 0 0 0 0 0 0

TABLE MUF_ACCOUNTING: MFY DBID TABLE BUF_SIZE S THRESHOLD SPILLING TOTAL_REQU PHYSIC_IOS LOCATES TOTAL_ADDS TOTAL_UPDT UNAVAILABL CONFLICTS SKIPPED ENTRIES RECLAIMED LOCATES_ST SPIL_THRES SPIL_INTER TOT 0 T 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

TABLE MUF_INTERNAL_STATS: MFV TIMES_RD_1 TIM_RD_2_8 TIM_RD_9_32 TIM_RD_33_99 TIM_WRITE_1 TIM_WRT_2_12 TIM_WRT_13_24 TIM_WRT_25_48 BRKS_DONE IO_MEM_ST 0 0 0 0 0 0 0 0 0 0

TABLE MUF_SMP_STATS: MFW POSTED_0 10

TABLE MUF_RETURN_CODES: MFU EXTERNAL_CODE INTERNAL_CODE COUNT_CODES TOT 0

TABLE MUF_SQLCODES: SQQ SQL_CODE CODE_COUNT TOTAL 0

TABLE MUF_MISC_STATS: SQM PROC_CACHE_REUSE PROC_FROM_CALL PROC_FROM_TRIGGER PROC_QUEUED PROC_SQL_STMTS PROC_FAILURES PROC_NESTS 0 0 0 0 0 0 0

TABLE MUF_SYSTEM_STATS: MFS BEGIN_TIME 20081111 13.12.17.000000 CURRENT_DATETIME 20081111 13.14.59.633053 CURRENT_CPU 1 RQ_PENDING_1_10 8 RQ_PENDING_11_20 0 RQ_PENDING_21_30 0 ... etc. DATA2_USED_4 0 DATA2_USED_5 0

TABLE MUF_AREA_STATS: MFA DBID AREA_NAME PHYSICAL_READS PHYSICAL_WRITES LOGICAL_READS LOGICAL_WRITES 0 CXX 83 6 502 8 0 FXX 15 14 15 0 0 LXX 4 6 4 1 6 IXX 0 0 4 0 1000 IXX 0 0 0 0 1000 SYS 0 0 0 0 ... etc.. 1006 CBS 2 0 2 0 1006 IXX 2 0 2 0 TOT 106 26 529 9

TABLE MUF_TABLE_STATS: MFT DBID TABLE_NAME AREA_NAME TOTAL_REQUEST TOTAL_READS TOTAL_ADDS TOTAL_DELETES TOTAL_UPDATES 1000 DRA SYS 0 0 0 0 0 1000 DRB SYS 0 0 0 0 0 1000 DRC SYS 0 0 0 0 0 1000 DRD SYS 0 0 0 0 0 1000 DRE SYS 0 0 0 0 0 1000 DRF SYS 0 0 0 0 0 1000 DRI SYS 0 0 0 0 0 ... etc. 1006 CBS CBS 0 0 0 0 0 TOT TOT 72 56 0 0 0

TABLE MUF_CBS: MCB BUF_CUR_PERC_FULL 0 BUF_MAX_PERC_FULL 0 CUR_USED_SET_MEM 311 MAX_USED_SET_MEM 0 SETS_DEL_MAX_AGE 16 SETS_FETCHED 0 SETS_PROCESSED 0 SETS_SPILLED 0 SETS_TEMP_INDEX 0 TEMP_INDEX_ENTRIES 0 SPILLED_JOB_NAME NULL SPILLED_UIB NULL DURATION_AT_SPILL NULL

TABLE MUF_CONFIG: MCF CONFIG_COMMAND CONFIG_PARAMETERS DIAGOPTION 000800000000000000000000000000000000000000000000 HISTORY 1007....

TABLE MUF_SRB_ZIIP: MZI SEQ.NO ENCLAVE_SEC ZIIP_ON_CP_SEC ZIIP_QUAL_SEC ZIIP_SECONDS ZIIP_PERCENT TOTAL 0 0 0 0

TABLE MUF_TCB_OR_SRB: MTC TASK PROGRAM SEQ.NO CPU_SECONDS TIMES_USED TIMES_POSTED PHYSICAL_IO MAIN DBMUFPR 1 0 249 248 132 SMP DBSMPPR 1 0 0 0 0 SMP DBSMPPR 2 0 0 0 0 SMP DBSMPPR 3 0 0 0 0 SUB DBCONPR 1 0 0 0 0 SUB DBDUSPR 1 0 0 0 0 SUB DBENQPR 1 0 13 13 0 SUB DBMSBPR 1 0 3 0 0 SUB DBOCSPR 1 0 5 10 0 SUB DBOCSPR 2 0 0 0 0 SUB DBOC2PR 1 0 5 5 0 TOT 9999 0 275 276 132

TABLE BUSINESS_VALUE_METRICS: BVM Elapsed Seconds 162 CPU Seconds Used 1 Physical I/O 132 Database Requests 27 Data Area Requests 538 Table Requests 56 Table Reads 56 Table Adds 0 Table Deletes 0 Table Updates 0 Calculated Business Value Metrics Requests per elapsed second 0.16 Requests per CPU second 27.00 Requests per Physical IO 0.20

TABLE BUSINESS_VALUE_METRICS: BVD Elapsed Seconds 162 CPU Seconds Used 1 Request Processing % Database Requests 27 ** Data Manager Requests 30 111.1 SQL Requests 0 0.0 Physical I/O Processing % Total Physical I/O 132 ** Physical I/O - Read 106 80.3 Physical I/O - Write 26 19.6 Sequential Read Ahead I/Os 0 0.0 Accounting I/O 0 0.0 Logging I/O 6 4.5 Buffer Processing 5 to 1 Ratios IXX Buffer Use 5+ 0 0.0 DXX Buffer Use 5+ 0 0.0 DATA Buffer Use 5+ 0 0.0 DATA2 Buffer Use 5+ 0 0.0 No IXX Buffer Available 0 No DXX Buffer Available 0 No DATA Buffer Available 0 No EXPAND Buffer Available 0 No TXB Buffer Available 0 MRDF Processing % Saved I/O MRDF Memory (bytes) 295731200 ** MRDF Virtual Reads 2 1.5 MRDF Virtual Writes 0 0.0 MRDF Covered Memory (bytes) 0 ** ... etc. Request Pending 31-40 0 Request Pending 41-50 0 Request Pending 50+ 0

DB30073I - TOTAL RECORDS SELECTED: 101