PI74438: INZQRY11 BIND FAILS WITH SQLCODE=-4700 STATEMENT=709 IN A DB2 V11 CM MODE WITH THE PTF UI43511 INSTALLED 17/01/25 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the PTF UI43511 has been applied, an attempt to BIND DB2
  HPU in a DB2 V11 in CM mode subsystem fails with SQLCODE=-4700
  STATEMENT=709
  
  PB47686
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the PTF UI43511 has been applied, *
  *                      an attempt to BIND DB2 HPU in a DB2     *
  *                      V11 in CM mode subsystem fails with     *
  *                      SQLCODE=-4700 as reported in the        *
  *                      example below:                          *
  *                                                              *
  *                      DSN                                     *
  *                      DSN                                     *
  *                      BIND PACKAGE(HPU430) MEMBER(INZQRY11)   *
  *                       RELEASE(COMMIT)                        *
  *                      ISOLATION(CS) VALIDATE(RUN)             *
  *                       ACTION(REPLACE) DYNAMICRULES(RUN)      *
  *                      OWNER(IS6X) ENCODING(EBCDIC)            *
  *                      DSNX200I -KDB2 BIND SQL ERROR           *
  *                      USING IS6X AUTHORITY                    *
  *                      PLAN=(NOT APPLICABLE)                   *
  *                      DBRM=INZQRY11                           *
  *                      STATEMENT=709                           *
  *                      SQLCODE=-4700                           *
  *                      SQLSTATE=56038                          *
  *                      TOKENS=                                 *
  *                      CSECT NAME=DSNXORFN                     *
  *                      RDS CODE=-666                           *
  *                      DSNT233I -KDB2 UNSUCCESSFUL BIND FOR    *
  *                      PACKAGE = HAMBURG_KDB2.HPU430           *
  *                      .INZQRY11.(HZ4750)                      *
  *                      pb 47686                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzquery and inzqry11 modules have been changed.
  

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:

  UI44140

Modules/Macros

•    INZQRY11 INZQUERY INZTPMEM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI44140

     UP17/01/26 P F701 Ø

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.