ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DBG02041E, DBG02018E, DBG01014E, ... error messages

book

Article ID: 186607

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Detector for DB2 for z/OS Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

Started the CA SYSVIEW for DB2 Daga Collector and found a lot of 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 DB2P 14:40:12 INVALID PRINT FORMAT
... 
DBG02018E DB2P 14:40:12 INVALID FIELD SPECIFICATION 
...
DBG01014E DB2P 14:40:12 MISSPELLED RESERVED WORD OR LITERAL STATCLGSRT 
...
DBG01014E DB2P 14:40:12 MISSPELLED RESERVED WORD OR LITERAL DISCARDED-PAGES
...
  
Finally the the CA SYSVIEW for DB2 Data Collector did not start and got an Abend U0052.

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

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.