SQL-204 SYSACCEL.SYSACCELERATEDPACKAGES UNDEFINED noted in Detector SQL errors
search cancel

SQL-204 SYSACCEL.SYSACCELERATEDPACKAGES UNDEFINED noted in Detector SQL errors

book

Article ID: 200057

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

A REBIND on certain packages via RC/Query for Db2 for z/OS (RCQ) executes successfully but receive SQL-204 seen in Detector on SYSACCEL.SYSACCELERATEDPACKAGES.

Resolution

It has 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 does not find them, it is 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.