Executing the Sysview for Db2 (IDB2) DISTRIB IQL Report in Batch Fails with DBG01014E DBG02018E Errors

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Attempts to execute the IDB2 DISTRIB IQL report in batch via the NSIGHTRW program fails with:  
'DBG01014E  MISSPELLED RESERVED WORD OR LITERAL' and 'DBG02018E INVALID FIELD SPECIFICATION' error messages.                                   
 

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Cause

Missing Global Declare Statements

Resolution

When converting data collector requests to batch you must always concatenate the global DECLARE statements ahead of the request you intend to run. 

//DBGIN    DD DISP=SHR,DSN=Highlevel.CDBATREQ(DCL$A$D)
//         DD DISP=SHR,DSN=Highlevel.CDBATREQ(DCL$E$P)
//         DD DISP=SHR,DSN=Highlevel.CDBATREQ(DCL$Q$Z)
//         DD DISP=SHR,DSN=Highlevel.CDBATREQ(DISTRIB)