PH39126: UNDUE INZI188E IF UNLOAD IN NATIVE MODE AGAINST NOT CLONED TABLESPACE BUT HAVING LDS INSTANCE WITH NUMBER DIFFERENT FROM 1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload unduly terminates in error after having issue
  the following error message :
  INZI188E UNABLE TO RETRIEVE VSAM INFORMATION FOR THE
  TABLESPACE/INDEXSPACE
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x30a002)
  This occurs when all the following conditions are fulfilled :
  - the logical unload is processed in native mode
  - the unload specifies an ORDER clause is specified
  - the VUX036/RTSESTIM parmlib parameter is set to NO
  - the tablespace involved in the unload is not marked as a clone
  tablespace but the underlying LDS is not the #1 instance of the
  LDS.
  The latter situation can occur if the tablespace was once a
  CLONE tablespace and the clone was dropped (i.e. an ALTER DROP
  CLONE has been performed) after the base and clone tables had
  been exchanged.
  

Local fix

• set the VUX036/RTSESTIM parmlib parameter to YES or run the
  unload in SQL mode by specifying the DB2 FORCE option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: (HPU5.1 only) A logical unload unduly   *
  *                      terminates in error after having issue  *
  *                      the following error message :           *
  *                      INZI188E UNABLE TO RETRIEVE VSAM        *
  *                      INFORMATION FOR THE                     *
  *                      TABLESPACE/INDEXSPACE                   *
  *                                                              *
  *                      This occurs when all the following      *
  *                      conditions are fulfilled:               *
  *                      - the logical unload is processed in    *
  *                        native mode                           *
  *                      - the unload specifies an ORDER clause  *
  *                        is specified                          *
  *                      - the VUX036/RTSESTIM parmlib parameter *
  *                        is set to NO                          *
  *                      - the tablespace involved in the unload *
  *                        is not marked as a clone tablespace   *
  *                        but the underlyinh LDS is not the #1  *
  *                        instance of the LDS.                  *
  *                      The latter situation can occur if the   *
  *                      tablespace was once a CLONE tablespace  *
  *                      and the clone was dropped (i.e. an      *
  *                      ALTER DROP CLONE has been performed)    *
  *                      after the base and clone tables had     *
  *                      been exchanged.                         *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Undue INZI188E if unload in native mode against not cloned
  tablespace but having LDS instance with number different from 1
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UI76902

Modules/Macros

• INZCHECK INZCRX10 INZCRXSM INZCRXSQ INZTPMEM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI76902

     UP21/09/03 P F109

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.