PK32955: A SQLCODE -311 MAY OCCUR ON THE OPEN CURSOR CORRESPONDING TO A NON SUPPORTED SELECT. PB 8500.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A SQLCODE -311 may occur on the OPEN CURSOR corresponding to a
  non supported SELECT.  PB 8500
  ADDITIONAL SYMPTOM:
  1) Message INZU066E table not found is issued when more than 1
  select using 3 part names that point to a distant DB2 subsystem
  are coded in the same sysin. HPU tries incorrectly to process
  natively the second SELECT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: - A SQLCODE -311 may occur on the OPEN  *
  *                      CURSOR corresponding to a non supported *
  *                      SELECT.  PB 8500                        *
  *                      ADDITIONAL SYMPTOM:                     *
  *                      1. Message INZU066E table not found is  *
  *                      issued when more than 1 select using 3  *
  *                      part names that point to a distant DB2  *
  *                      subsystem are coded in the same sysin.  *
  *                      HPU tries incorrectly to process        *
  *                      natively the second SELECT.             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  - Modules Inzcrxsq and Inzcrxsm where changed to remove the
  USING DESCRIPTOR from the OPEN CURSOR statements used to process
  the non supported SELECT through DB2.
  1. Module Inzctrl was changed to control that the SELECT is not
  supported before searching on the local subsystem for the table
  space name. Select statements that use 3 part name with a
  LOCATOR not equal to the local DB2 are considered as non
  supported.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK19252 UK19253

Modules/Macros

•    INZCRXSM INZCRXSQ INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK19252

     UP06/11/07 P F611

• R220 PSY UK19253

     UP06/11/07 P F611

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.