IC62025: STORED PROCEDURE FAILS WITH "QPLAN SANITY FAILURE" ERROR WHEN EXECUTED FROM AN HDR SECONDARY

APAR status

• Closed as program error.

Error description

• On some platforms, running a stored procedure on an HDR
  secondary that inserts into or selects from the primary table
  may fail with a "QPlan Sanity failure" error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * users with HDR setup and spl having fully qualified table in *
  * primary server.                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In HDR setup , when the primary server has an spl with a     *
  * fully qualified table name , spl execution on the secondary  *
  * server gives 640 error.                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 10.00.xC11, IDS 11.50.xC6 and above.          *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 10.00.xC11 and IDS 11.50.xC6
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP