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.

RC/QUERY -204 SYSACCEL.SYSACCELERATEDPACKAGES UNDEFINED Seen in Detector.

book

Article ID: 200057

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Endevor SCM Interface for DB2 for z/OS Endevor SCM Interface for Remote DB2 for z/OS RC/Extract for DB2 for z/OS RC/Migrator for DB2 for z/OS RC/Merger for DB2 for z/OS RC/Query for DB2 for z/OS RC/Secure for DB2 for z/OS RC/Update for DB2 for z/OS

Issue/Introduction

Running a REBIND on certain Packages, runs fine but receive SQL -204 seen in Detector on SYSACCEL.SYSACCELERATEDPACKAGES Undefined, why

Environment

Release : 20.0

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

Resolution

This is by design:  

According to Product Labs;

Its been confirmed not be concerned for these type  SQL errors -205  -514 seen in Detector. By design the product is checking for the existence of these various tables like Accelerator or Virtual Index Tables. If the product doesn't find them, its coded to skip over that functionality.  

For example, the summary and access path reports includes additional reporting capability when virtual indexes are in use by the Db2 optimizer during a future explain. So, based on the above you should not be concerned unless you see errors reported in the explain report or the rest of the sysout indicating some inability to complete the work it is doing.