PI90051: CORRUPTED DATA WHEN LOB OR XML DATA IN SPANNED FILE OR IN PDS MEMBER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Corrupted data when LOB or XML data in spanned file or in PDS
  member
  
  PB50593
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Performance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Corrupted data when LOB or XML data in spanned file or in    *
  * PDS member                                                   *
  *                                                              *
  * Additional fixes included:                                   *
  * PI86599:  The unload fails with completion code of 8 after   *
  * having issued message                                        *
  *                  -- INZX133 tsname NO VALID INPUT DDNAME     *
  * ddname FOUND,  PARTITION p NOT UNLOADED                      *
  *                 This occurs if the following two conditions  *
  * apply:                                                       *
  *                     - the table space involved in the unload *
  * is partitioned                                               *
  *                     - the data to be unloaded is from image  *
  * copies that must be allocated dynamically                    *
  *                                                              *
  *                                 + either because COPYDDN     *
  * LAST_IC or COPYDDN -integer is requested                     *
  *                                 + or the COPYDDN ddname      *
  * option is used with a ddname described by a TEMPLATE         *
  * statement                                                    *
  *                                    the UNLOAD TABLESPACE     *
  * statement specifies more than 10 SELECT statements           *
  *                                                              *
  * PI87555:  When either the SELMSG or the PROCMSG feature      *
  * requests the allocation of a separate output data set for    *
  * the                                                          *
  *                 progress messages, i.e. the sub-option value *
  * is different from SYSPRINT or WTO, each output data set has  *
  * a separate JES2 output                                       *
  *                 group name (O-Grp-N). which makes the        *
  * handling of joblogs in JES2 complicated.                     *
  *                 For example, for an unload with 10 SELECT    *
  * statements that specifies "GLOBAL SELMSG NUMBERED ;" there   *
  * are 10 entries for                                           *
  *                 the same jobid as in the example below       *
  *                                                              *
  *                                                              *
  *                                                              *
  *                 JOBNAME JobID O-Grp-N                        *
  *                                                              *
  *                 HPUZ284 JOB05043 1                           *
  *                                                              *
  *                 HPUZ284 JOB05043 10                          *
  *                                                              *
  *                 HPUZ284 JOB05043 11                          *
  *                                                              *
  *                 HPUZ284 JOB05043 2                           *
  *                 HPUZ284 JOB05043 3                           *
  *                                                              *
  *                 HPUZ284 JOB05043 4                           *
  *                                                              *
  *                 HPUZ284 JOB05043 5                           *
  *                                                              *
  *                 HPUZ284 JOB05043 6                           *
  *                                                              *
  *                 HPUZ284 JOB05043 7                           *
  *                                                              *
  *                 HPUZ284 JOB05043 8                           *
  *                                                              *
  *                 HPUZ284 JOB05043 9                           *
  *                                                              *
  *                                                              *
  *                                                              *
  *                 instead of one as in the example below for a *
  * run with a previous version :                                *
  *                 JOBNAME JobID O-Grp-N                        *
  *                 HPUZ284 JOB05042 1                           *
  *                                                              *
  *                                                              *
  * PI87934:  DB2 HPU stops with RC=8 and INZU447E with 218 *    *
  * FIELD OVERLAPS END OF RECORD when the all the following      *
  *                                                              *
  *                 conditions are fulfilled.                    *
  *                                                              *
  *                 -  the unload from an image copy (COPYDDN)   *
  * is requested                                                 *
  *                 -  the input image copy was created for a    *
  * partitioned table space that had at least one compressed     *
  * partition                                                    *
  *                 -  the online table space involved in the    *
  * unload is not compressed at all                              *
  *                                                              *
  *                and either of the following sets of           *
  * conditions is also satisfied                                 *
  *                                                              *
  *                - subcase 1)                                  *
  *                                                              *
  *                            +  the input image copy is a      *
  * global image copy                                            *
  *                            +  the partition #1 from the      *
  * image copy is either not compressed or empty                 *
  *               -  subcase 2)                                  *
  *                                                              *
  *                            + the input image copy is an      *
  * inline image copy                                            *
  *                            + the first header page of the    *
  * image copy does not contains the address of the dictionary   *
  *                                                              *
  *                                                              *
  * PI88576:  A logical unload involving a SELECT statement FROM *
  * a synonym enter an infinite loop.                            *
  *                                                              *
  *                                                              *
  *                                                              *
  * PI90048:  The compressed LOBs can be unloaded by DB2 HPU.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

• PI86599:   Split the unload into several unload statements
  having no more than 10 SELECT statements.
  PI87555:   None but the multiple JES entry issue can be solved
  by specifying SELMSG/PROCMSG WTO or SELMSG/PROCMSG SYSPRINT.
  
  PI88576:   Replace the synonym name by the table name it refers
  to.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI52005

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI52005

     UP17/11/25 P F711

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.