PH57230: UNDUE INZU495E WHEN UNLOADING LOB/XML INTO LOBFILES WITH DB2 FORCE AND SQLPART.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU terminates with return code 8 and issues the following
  message :
  INZU495E ERROR: INCORRECT LOBFILE TEMPLATE SYSREC01 FOR COLUMN
  DESCRIPTION :
           MANDATORY VARIABLE MISSING. THE TEMPLATE MUST CONTAIN
  AT LEAST ONE OF THE
           USER DEFINED VARIABLE BASED ON :SELNUM
  
  This occurs when all the following conditions are fulfilled :
  - the DB2 FORCE option is specified
  - the SQLPART option is specified to unload data by partition
  - the unload involves a table in a partitioned tablespace
  - the unload is a logical unload that involves LOB or XML data
  - each LOB or XML column is unloaded into a  LOBFILE dataset
  - the template used to allocate the LOBFILEs specify a dsname
  with &PART and &UNIQ
  - the VUU088/ULLOCKMO parmlib parameter is set to ALL
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU terminates with return code 8 and   *
  *                      issues the following message :          *
  *                      INZU495E ERROR: INCORRECT LOBFILE       *
  *                      TEMPLATE SYSREC01 FOR COLUMN            *
  *                      DESCRIPTION :                           *
  *                               MANDATORY VARIABLE MISSING.    *
  *                               THE TEMPLATE MUST CONTAIN AT   *
  *                               LEAST ONE OF THE               *
  *                               USER DEFINED VARIABLES BASED   *
  *                               ON :SELNUM                     *
  *                                                              *
  *                      This occurs when all the following      *
  *                      conditions are fulfilled :              *
  *                      - the DB2 FORCE option is specified     *
  *                      - the SQLPART option  is specified      *
  *                        to unload data by partition           *
  *                      - the unload involves a table in a      *
  *                        partitioned tablespace                *
  *                      - the unload is a logical unload that   *
  *                        involves LOB or XML data              *
  *                      - each LOB or XML column is unloaded    *
  *                        into a  LOBFILE dataset               *
  *                      - the template used to allocate the     *
  *                        LOBFILEs specify a dsname with &PART  *
  *                        and &UNIQ                             *
  *                      - the VUU088/ULLOCKMO parmlib           *
  *                        parameter is set to ALL               *
  *                                                              *
  *                      Local fix: none.                        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  undue INZU495E when unloading LOB/XML into LOBFILEs with DB2
  FORCE and SQLPART
  

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

• INZ$$CCQ INZ$$PRM INZMQRY  INZPARM  INZTDSC  INZTOOLS INZTVAR
  INZUTIB1 INZUTIB2 INZUTILC INZUTILD INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI94047

     UP23/11/07 P F311

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.