r15 GSS proc not delivered in r19

Document ID : KB000006596
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Explain of the following query:

SELECT  QUERYACCELERATION                                     

    FROM SYSACCEL.SYSACCELERATEDPACKAGES  

received @0006 instead of SQLCODE = -204 on an explain the error is complaining about this. the query looks like this:

They do not have an accelerator. What's wrong

 

Resolution:

It's a very legitimate possibility. If statements are not found in the PLAN_TABLE for a current explaun, then PPADB2 mark them as @0006 because PPADB2 doesn't have knowledge as to why the statements do not exist in the Plan_Table.