CA MICS Batch and Operations Analyzer (SMF) Queries › Specialty Engine zIIP/zAAP Focus › SMFDZA – SMF Daily zAAP CPU Use and Demand › Query Defaults
Query Defaults
- HARCPU DETAIL timespan file: Cycles 01
- BATPGM, BAT_OE, BAT_SA, BAT_ST, BAT_TS, and BAT_TP DETAIL timespan files: Cycles 01-02
- Filters: PGMZAPTM GT 0 OR PGMZACTM GT 0 (only zAAP actual or eligible CPU time)
- User code selects yesterday's data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
- Derivations:
- CPCID
-
TRIM(LPCMOD)||'-'||TRIM(CPCMODID)||'-Serial: '||SUBSTR(CPCSEQNB,12,5);
- DATE
-
DATEPART(ENDTS) ;
- ADDRTYP
-
IF PGMTYPE=1 THEN ADDRTYP='Batch' ;
ELSE IF PGMTYPE=2 THEN ADDRTYP='TSO' ;
ELSE IF PGMTYPE=3 THEN ADDRTYP='Started Task' ;
ELSE IF PGMTYPE=4 THEN ADDRTYP='APPC' ;
ELSE IF PGMTYPE=5 THEN ADDRTYP='Unix SysSrv' ;
ELSE IF PGMTYPE=6 THEN ADDRTYP='System Addr' ;
ELSE ADDRTYP= 'UNKNOWN' ;