Sysview for Db2 SMFSORT job fails with WER268A MODS STATEMENT : SYNTAX ERROR

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Using the IDB2 supplied SMFSORT job found in the .SOURCE library fails with the following SYNCSORT message: 

WER813I  INSTALLATION OPTIONS IN MFXPRM00 WILL BE USED                 
WER268A  MODS STATEMENT    : SYNTAX ERROR                              
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000         
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE         

Environment

Sysview for Db2 (IDB2) Release : 20.0

Cause

The SYNCSORT package uses different syntax than the SMFSORT job's DFSORT syntax ( as supplied in the IDB2 .SOURCE library ).

Resolution

The problem was circumvented by removing the MODS statement to use the following SYSIN statements:

//SYSIN    DD  *                                                     
 INCLUDE   COND=((6,1,BI,EQ,X'64'),    <--DB2 100 STATISTICS RECORDS 
              OR,(6,1,BI,EQ,X'65'),    <--DB2 101 ACCOUNTING RECORDS 
              OR,(6,1,BI,EQ,X'66'))    <--DB2 102 PERFORMANCE RECORDS
*                                                                    
 SORT FIELDS=(15,4,A,19,4,A,11,4,A,7,4,A,6,1,A,23,1,A),FORMAT=BI    

Additional Information

An example of SYNCSORT's MODS statement syntax:

MODS PHn=(name,loading information,Enn1,...,Ennn)

Please refer to SYNCSORT documentation for more information concerning the MODS statement.