AnsweredAssumed Answered

PMSMFEX - select records by task code

Question asked by mike.olmstead on Aug 14, 2012
Latest reply on Aug 15, 2012 by mike.olmstead
I want to report on DMLO activity only and therefore don't need to process all the other record types.

Is there a way to select records by task code at the PMSMFEX program level? I know you can do that at the PMARPTnn report level, but in an effort to reduce runtime I'd like to eliminate the other records
right off the bat.

This gets me the dmlo entries, but also includes everyother transations and takes over an hour to run one days worth:

//SYSIN DD *
DATABASE DICTNAME=SYSDIRL
PARAM=LIST
=MACRO 'PMSMFEX' (231)
=MEND
007102 $ WE WANT THESE RECORD TYPES
007 DROP $ DON'T WANT THIS ONE.
007202 $ WE WANT THESE RECORD TYPES
007235 IF SMFHDCV# EQ X'0007' 240
007 IF SMFHDCV# EQ X'0008' 240
007239 DROP $ DON'T WANT THIS ONE.
/*

I tried selecting only the type 16 records, but in doing that the dmlo entries are not selected.

//SYSIN DD *
DATABASE DICTNAME=SYSDIRL
PARAM=LIST
=MACRO 'PMSMFEX' (231)
=MEND
007102 $ WE WANT THESE RECORD TYPES
007 DROP $ DON'T WANT THIS ONE.
007202 $ WE WANT THESE RECORD TYPES
007 IF PMHDR-003-003-PMHRTYPE EQ X'10' 235
007 DROP $ DON'T WANT THIS ONE.
007235 IF SMFHDCV# EQ X'0007' 240
007 IF SMFHDCV# EQ X'0008' 240
007239 DROP $ DON'T WANT THIS ONE.
/*


There is only one DMLO entry in my SMF data file, so thats the only record I want. Looking for suggestions on how to reduce the other 9M records I'm processing? - Thanks

08/14/12 RUN TIME MESSAGES

CA-IDMS PERFORMANCE MONITOR REL 17.0 CAGJH0
--------------------------------------------------------
SMF INPUT PROCESSING STATISTICS
--------------------------------------------------------
251,467 SMF RECORDS READ
242,000 SMF RECORDS PROCESSED
--------------------------------------------------------
--------------------------------------------------------
CA-IDMS/PM OUTPUT PROCESSING STATISTICS
--------------------------------------------------------
9,685,719 PERFORMANCE MONITOR RECORDS WRITTEN
9,685,719 APPLICATION MONITOR RECORDS
0 INTERVAL MONITOR RECORDS
--------------------------------------------------------
08/14/12 RUN TIME MESSAGES

CA-IDMS PERFORMANCE MONITOR REL 17.0 CAGJH0
*********** END OF FILE ***************************************************
251,467 INPUT RECORDS READ
SELECTION SPECIFICATION STATISTICS
BEGINNING TIMES TIMES TIMES NUMERIC SUBSCRIPT
REFERENCE TESTED TRUE FALSE ERRORS ERRORS
NUMBER
1 251,467 251,467 0 0 0
C750009 RECORDS WRITTEN FOR REPORT 00 -- 9,682,293

Outcomes