PI72114: INZU042E & INZU516E UNLOADING FROM A UTS BY GROWTH COPY MADE BEFORE ADDED THE LAST PARTITION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 HPU refuses to unload (and issues the message INZU042E NO
  GLOBAL FULL IMAGE COPY FOUND FOR TABLESPACE dbname.tsname) the
  whole data from a partition-by-growth table space from a set of
  image copies data set (taken at the partition level) by
  specifying the COPYDDN LAST_IC or COPYDDN -integer if at least a
  partition has been added to the table space after the time when
  the set of image copies were taken. DB2 HPU accepts to unload
  such a set of image copies only if a PART option compatible with
  the source image copies is specified.
  
  For example, assume that the MYDB.MYTS partition-by-growth table
  space had 15 partition at time t1 and all the partition were
  copied at that time. At time t2, MYDB.MYTS is automatically
  added a new partition. If the following unload is requested at
  time t3 (later than t2)
  
  UNLOAD TABLESPACE MYDB.MYTS
  COPYDDN -13
  SELECT * FROM ME.MYTABLE
  OUTDDN SYSREC
  
  the unload fails with NZU042E NO GLOBAL FULL IMAGE COPY FOUND
  FOR TABLESPACE MYDB.MYTS.
  
  The following unload allows to unload the data from the whole
  set of 15 image copies:
  
  UNLOAD TABLESPACE MYDB.MYTS PART (1-15)
  COPYDDN -13
  SELECT * FROM ME.MYTABLE
  OUTDDN SYSREC
  
  As partitions are added to the table space automatically, this
  prevents to run an unload such as the above ones on a regular
  base without any modification.
  
  DB2 HPU should accept to unload the data from a potentially
  complete set of image copies.
  A potentially complete set of image copies consists of a set
  with partition numbers ranging from 1 to n without any lack in
  the sequence.
  
  Other keywords: PB47171
  INZU042E INZU042 msgINZU042E msgINZU042
  INZU516E INZU516 msgINZU516E msgINZU516
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Enhancement: DB2 HPU refuses to unload  *
  *                      (and issues the message INZU042E NO     *
  *                      GLOBAL FULL IMAGE COPY FOUND FOR        *
  *                      TABLESPACE dbname.tsname) the whole     *
  *                      data from a partition-by-growth table   *
  *                      space from a set of image copies data   *
  *                      set (taken at the partition level) by   *
  *                      specifying the COPYDDN LAST_IC or       *
  *                      COPYDDN -integer if at least a          *
  *                      partition has been added to the table   *
  *                      space after the time when the set of    *
  *                      image copies were taken. DB2 HPU        *
  *                      accepts to unload such a set of image   *
  *                      copies only if a PART option            *
  *                      compatible with the source image        *
  *                      copies is specified.                    *
  *                      For example, assume that the MYDB.MYTS  *
  *                      partition-by-growth table space had 15  *
  *                      partition at time t1 and all the        *
  *                      partition were copied at that time. At  *
  *                      time t2, MYDB.MYTS is automatically     *
  *                      added a new partition. If the           *
  *                      following unload is requested at time   *
  *                      t3 (later than t2)                      *
  *                      UNLOAD TABLESPACE MYDB.MYTS             *
  *                      COPYDDN -13                             *
  *                      SELECT * FROM ME.MYTABLE                *
  *                      OUTDDN SYSREC                           *
  *                      the unload fails with NZU042E NO        *
  *                      GLOBAL FULL IMAGE COPY FOUND FOR        *
  *                      TABLESPACE MYDB.MYTS.                   *
  *                                                              *
  *                      The following unload allows to unload   *
  *                      the data from the whole set of 15       *
  *                      image copies:                           *
  *                      UNLOAD TABLESPACE MYDB.MYTS PART (1-15) *
  *                      COPYDDN -13                             *
  *                      SELECT * FROM ME.MYTABLE                *
  *                      OUTDDN SYSREC                           *
  *                                                              *
  *                      As partitions are added to the table    *
  *                      space automatically, this prevents to   *
  *                      run an unload such as the above ones    *
  *                      on a regular base without any           *
  *                      modification.                           *
  *                                                              *
  *                      DB2 HPU should accept to unload the     *
  *                      data from a potentially complete set    *
  *                      of image copies. A potentially          *
  *                      complete set of image copies consists   *
  *                      of a set with partition numbers         *
  *                      ranging from 1 to n without any lack    *
  *                      in the sequence.                        *
  *                      pb 47171                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  N/A (Enhancement)
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

Modules/Macros

•    INZ$$PRM
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI45327

     UP17/03/14 P F703

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.