DBG02041E DBG02018E DBG01014E error messages within Sysview for Db2 data collector
search cancel

DBG02041E DBG02018E DBG01014E error messages within Sysview for Db2 data collector

book

Article ID: 186607

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Started the Sysview Performance Management Option for Db2 for z/OS (IDB2) data collector and note many error messages because there were
a discrepancy of maintenance between the hlq.CDBALOAD library and the request hlq.CDBATREQ library. 
  

The error messages were as follows: 
  
DBG02041E 14:40:12 INVALID PRINT FORMAT
... 
DBG02018E 14:40:12 INVALID FIELD SPECIFICATION 
...
DBG01014E 14:40:12 MISSPELLED RESERVED WORD OR LITERAL STATCLGSRT 
...
DBG01014E 14:40:12 MISSPELLED RESERVED WORD OR LITERAL DISCARDED-PAGES
...
  
Finally the the IDB2 data collector did not start and encountered an abend U0052.

Resolution

To fix this kind of discrepancies you have to double check hlq.CDBALOAD library and the request hlq.CDBATREQ library are in sync,
normally the fields that the request hlq.CDBATREQ library works are defined by the load modules in hlq.CDBALOAD library.
 
If you find fields in the request hlq.CDBATREQ library are the right ones then you have to check the hlq.CDBALOAD library
has exactly same maintenance applied to define those fields.