PI84324: UNLOAD FAILS WITH SQLCODE = -4742 REASON 2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unload fails with completion code 8 after having issued the
  following messages
  DSNT408I SQLCODE = -4742, ERROR:  THE STATEMENT CANNOT BE
                                            EXECUTED BY DB2 OR IN
            THE ACCELERATOR (REASON 2)
  
  PB49786
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload fails with completion code    *
  *                      8 after having issued the following     *
  *                      messages                                *
  *                      DSNT408I SQLCODE = -4742, ERROR: THE    *
  *                       STATEMENT CANNOT BE EXECUTED BY DB2    *
  *                       OR IN THE ACCELERATOR (REASON 2)       *
  *                      DSNT418I SQLSTATE = 560D5 SQLSTATE      *
  *                       RETURN CODE                            *
  *                      DSNT415I SQLERRP = DSNXODML SQL         *
  *                       PROCEDURE DETECTING ERROR              *
  *                      DSNT416I SQLERRD = -434 0 0 -1 0 0      *
  *                       SQL DIAGNOSTIC INFORMATION             *
  *                      DSNT416I SQLERRD = X'FFFFFE4E'          *
  *                       X'00000000' X'00000000' X'FFFFFFFF'    *
  *                       X'00000000' X'00000000' SQL            *
  *                       DIAGNOSTIC INFORMATION                 *
  *                      INZU366I UTILITY RETURN CODE 8          *
  *                       (REASON CODE 0x18a003)                 *
  *                      This occurs when the table to be        *
  *                      unloaded is an Accelerator only table.  *
  *                      This situation is reported by DB2 HPU   *
  *                      by issuing the following message:       *
  *                      INZU460I OBJECT                         *
  *                       UNTAU034.PPH_ISO_BCEGS_ADDR_I_MST      *
  *                       CANNOT BE UNLOADED IN NATIVE MODE      *
  *                       BECAUSE ITS TYPE 'D' IN                *
  *                       SYSIBM.SYSTABLES IS NOT SUPPORTED.     *
  *                       - SELECT * FROM                        *
  *                        UNTAU034.PPH_ISO_BCEGS_ADDR_I_MST     *
  *                       -                                      *
  *                      INZU102I DB2 FORCE SPECIFIED, WILL      *
  *                       PROCESS THROUGH DB2.                   *
  *                      PB49786                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzcrx10, inzctrlh, odb2ctrl, oquery, mquery and inzmqry
  modules were 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:

  PI85939

Modules/Macros

•    INZCRX10
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI49959

     UP17/09/19 P F709

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.