CA RC/Query RCQSQL missing in Initialize the RC/Query Report Table job

book

Article ID: 196317

calendar_today

Updated On:

Products

CA Database Management for DB2 for z/OS - Utilities Suite CA RC/Query for DB2 for z/OS CA Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

Executing DB2 customization job Initialize the RC/Query Report Table fails because member RCQSQL is missing.

The member is not in the CDBASQL or CDBASRC library Where is the member?

Environment

Release : 20.0

Component :  CA RC/Query for DB2 for z/OS

Resolution

In 19.0 the RCQSQL member was in the CDBASRC library but in 20.0 it has been relocated to the CDBASAMP library.

Verify that the DSNAMExx member in use in the hlq.CDBAPARM has the correct reference to hlq.CDBASAMP on the SRCLIB entry.

For example in r19 DSNAMExx had:
SRCLIB   (hlq.CDBASRC)

but on r20 as members have been relocated it should have:
SRCLIB   (hlq.CDBASAMP)

Additional Information

See documentation sections Execute DB2 Catalog Customization Tasks and CA RC/Query DB2 Catalog Customization Tasks