PH03149: ROLLED UP MAINTENANCE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• rolled up maintenance
  PB53910
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unpredictable incorrect result,      *
  *                      including incorrect unloaded data,      *
  *                      completion code 8 and ABENDS0C4,        *
  *                      can occur when attempting to unload     *
  *                      in native mode, the data from a table   *
  *                      that fullfils the followings            *
  *                      conditions:                             *
  *                      - the table has one column defined      *
  *                       with a FIELDPROC which decoded data    *
  *                       type is variable and the encoded data  *
  *                       type is not variable.                  *
  *                      - the table has another column having   *
  *                       a variable type                        *
  *                         + either defined with a FIELDPROC    *
  *                         with encoded data having a           *
  *                         variable type (case 1)               *
  *                         + or with no FIELDPROC (case 2),     *
  *                      If case 1 applies, Db2 HPU  issues the  *
  *                      following message :                     *
  *                      * 231 * FIELDPROC ERROR *               *
  *                      and stops with completion code of 8.    *
  *                      If case 2 applies, Db2 HPU either:      *
  *                      - produces incorrect unpredictible      *
  *                       unloaded data                          *
  *                      - ends with ABENDS0C4.                  *
  *                      For example, if TYPECHNG is a program   *
  *                      that encodes data to a target datatype  *
  *                      passed as first operand, here are two   *
  *                      table definitions that illustrate       *
  *                      cases 1 and 2.                          *
  *                      case1:                                  *
  *                      CREATE TABLE me.mytable_case1 (         *
  *                       C1 VARCHAR(10) FIELDPROC FIELDPRC      *
  *                       ('VARCHAR(7)') ,                       *
  *                       C2 CHAR(36) ,                          *
  *                       C3 VARCHAR(10) FIELDPROC FIELDPRC      *
  *                       ('INTEGER'),                           *
  *                       C4 CHAR(11)                            *
  *                       FOR SBCS DATA NOT NULL                 *
  *                       )                                      *
  *                      IN mydb.myts                            *
  *                      case2:                                  *
  *                      CREATE TABLE me.mytable_case1 (         *
  *                       C1 VARCHAR(10)                         *
  *                       C2 CHAR(36) ,                          *
  *                       C3 VARCHAR(10) FIELDPROC FIELDPRC      *
  *                       ('INTEGER'),                           *
  *                       C4 CHAR(11)                            *
  *                      FOR SBCS DATA NOT NULL                  *
  *                      )                                       *
  *                      IN mydb.myts                            *
  *                      pb53950                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The udbspmfl module was changed.
  

Problem conclusion

• APPLY the PTF.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI58959

     UP18/11/02 P F811

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.