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

Products

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

Issue/Introduction

Executing Database Management for Db2 for z/OS customization job Initialize the RC/Query Report Table fails because member RCQSQL is missing.
The member is not in the hlq.CDBASQL or hlq.CDBASRC library.

Resolution

In Database Management release r19 the RCQSQL member was in the hlq.CDBASRC library but in release r20 it has been relocated
to hlq.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)