PH34851: INCORRECT LOAD COMMAND IN VARIABLE FORMAT FOR ROWID DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The LOAD control cards (LOADDN option) generated by Db2 HPU for
  a ROWID column is incorrect if the requested output format is
  VARIABLE. The field description for the ROWID column unduly
  describes a fixed length field instead of a variable length
  field that is relevant for this variable data written on its
  real length.
  
  For example, the LOAD control cards specifies
  - example 1) POSITION ( 1 : 19 ) ROWID
  or
  - example 2) POSITION ( * : * + 18 ) ROWID
  where the correct specification is
  - example 1) POSITION ( 1 ) ROWID
  or
  - example 2) POSITION ( * ) ROWID
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The LOAD control cards (LOADDN option)  *
  *                      generated by Db2 HPU for a ROWID column *
  *                      is incorrect if the requested output    *
  *                      format is VARIABLE. The field           *
  *                      description for the ROWID column unduly *
  *                      describes a fixed length field instead  *
  *                      of a variable length field that is      *
  *                      relevant for this variable data written *
  *                      on its real length.                     *
  *                                                              *
  *                      For example, the LOAD control cards     *
  *                      specifies                               *
  *                      - example 1) POSITION (1 : 19) ROWID    *
  *                      or                                      *
  *                      - example 2) POSITION (* : *+18) ROWID  *
  *                      where the correct specification is      *
  *                      - example 1) POSITION ( 1 ) ROWID       *
  *                      or                                      *
  *                      - example 2) POSITION ( * ) ROWID       *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Incorrect LOAD command in VARIABLE format for ROWID data.
  

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$$PRM INZBIND  INZTDSC  INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI75101

     UP21/05/07 P F105

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.