PH70065: UNDUE ERROR WHEN SPECIFYING INSERT ALGORITHM FOR UNLOADS FROM ANIMAGE COPY USING A DDL WITH THE DDLDDN KEYWORD

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• HPU unduly terminates when unloading an image copy using a DDL
  with the DDLDDN keyword if INSERT ALGORITHM is specified in the
  following scenarios:
  
  Scenario 1
  
  - The DDL contains a TABLESPACE DDL with the following
    characteristics:
      - DSSIZE NUMPARTS and INSERT ALGORITHM are specified
      - DSSIZE is specified before INSERT ALGORITHM
      - NUMPARTS is specified after INSERT ALGORITHM
    In this case, HPU terminates with the following message:
    INZI527E DDL ANALYSING: DSSIZE OPTION REQUIRES MISSING
    NUMPART, MAXPART OR LOB OPTION.
  
  Scenario 2
  
  - The DDL contains a TABLESPACE DDL with the following
    characteristics:
      - NUMPARTS and INSERT ALGORITHM are specified
      - DSSIZE is not specified
      - NUMPARTS is specified after INSERT ALGORITHM
    In this case, HPU terminates with the following message:
    INZU395E THE IMAGE COPY CANNOT BE USED FOR THE TABLE SPACE
    dbname.tsname FOR THE FOLLOWING REASON:
    THE IMAGE COPY CONTAINS DATA FROM A PARTITIONED TABLESPACE
    THE SPECIFIED TABLESPACE IS A NON-PARTITIONED TABLESPACE.
  

Local fix

• Remove INSERT ALGORITHM from the DDL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU unduly terminates when unloading an *
  *                      image copy using a DDL with the DDLDDN  *
  *                      keyword if INSERT ALGORITHM is          *
  *                      specified in the following scenarios:   *
  *                                                              *
  *                      Scenario 1                              *
  *                                                              *
  *                      - The DDL contains a TABLESPACE DDL     *
  *                        with the following characteristics:   *
  *                          - DSSIZE NUMPARTS and INSERT        *
  *                            ALGORITHM are specified           *
  *                          - DSSIZE is specified before INSERT *
  *                            ALGORITHM                         *
  *                          - NUMPARTS is specified after       *
  *                            INSERT ALGORITHM                  *
  *                        In this case, HPU terminates with the *
  *                        following message:                    *
  *                        INZI527E DDL ANALYSING: DSSIZE OPTION *
  *                        REQUIRES MISSING NUMPART, MAXPART OR  *
  *                        LOB OPTION.                           *
  *                                                              *
  *                      Scenario 2                              *
  *                                                              *
  *                      - The DDL contains a TABLESPACE DDL     *
  *                        with the following characteristics:   *
  *                          - NUMPARTS and INSERT ALGORITHM are *
  *                            specified                         *
  *                          - DSSIZE is not specified           *
  *                          - NUMPARTS is specified after       *
  *                            INSERT ALGORITHM                  *
  *                        In this case, HPU terminates with the *
  *                        following message:                    *
  *                        INZU395E THE IMAGE COPY CANNOT BE     *
  *                        USED FOR THE TABLE SPACE              *
  *                        dbname.tsname FOR THE FOLLOWING       *
  *                        REASON:                               *
  *                        THE IMAGE COPY CONTAINS DATA FROM A   *
  *                        PARTITIONED TABLESPACE THE SPECIFIED  *
  *                        TABLESPACE IS A NON-PARTITIONED       *
  *                        TABLESPACE.                           *
  *                                                              *
  *                      Local fix: Remove INSERT ALGORITHM from *
  *                      the DDL                                 *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Undue error when specifying INSERT ALGORITHM for unloads from an
  IMAGE COPY using a DDL with the DDLDDN keyword
  

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:

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO07025

     UP26/03/06 P F603

• R610 PSY UO07026

     UP26/03/06 P F603

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.