PK07945: 1. PADDING WITH BINARY ZEROES INSTEAD OF BLANKS 2. SIGN BYTE IN DEC EXTERNAL IS BLANK INSTEAD OF '+'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Padding with binary zeroes instead of blanks in OUTPUT-FORMAT
  DSNTIAUL when using an INTO to change the length of a
     character string.  PB7262
  2. The sign byte in DEC EXTERNAL is blank when it should be '+'
     for posiitive values.  PB7263
  3. INZI174E error when trying to determine ENFM status,
     after migrating DB2 V8 from CM to NFM.  PB7325
  4. INZRE42 issued on a TS that has been altered from COMPRESS
     YES to COMPRESS NO, and that still contains some compressed
     rows.
     PB 6884
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Padding with binary zeroes instead   *
  *                       of blanks in OUTPUT-FORMAT DSNTIAUL    *
  *                       when using an INTO to change the       *
  *                       length of a character string.  PB7262  *
  *                      2. The sign byte in DEC EXTERNAL is     *
  *                       blank when it should be '+' for        *
  *                       posiitive values.  PB7263              *
  *                      3. INZI174E error when trying to        *
  *                       determine ENFM status, after           *
  *                       migrating DB2 V8 from CM to NFM.       *
  *                       PB7325                                 *
  *                      4. INZRE42 issued on a TS that has been *
  *                       altered from COMPRESS YES to COMPRESS  *
  *                       NO, and that still contains some       *
  *                       compressed rows. PB6884                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module Inzctrlf, function inzcontrolFunIntoEcs() was changed
   to set correctly the padding character.
  2. Module Inzctrlf, function inzcontrolFunIntoEcs() was changed
   to set correctly the sign character.
  3. Module Inzmain was changed to switch to the user defined in
   variable VUM028/DISPLUSR before issuing the DISPLAY GROUP
   command. Module Odb2cmd was changed to display the result of
   the command returned by DB2 when an error occurs when a DB2
   command is issued by HPU.
  4. Module Inzbab was changed to describe all columns even when
   the last columns of the table don't appear in the SELECT
   (in the list of selected items, in the where clause or in the
   order by).
  

Problem conclusion

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:

  UK05904 UK05905

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK05904

     UP05/08/06 P F508

• R220 PSY UK05905

     UP05/08/06 P F508

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.