IBM Support

PM58289: DSNU272I ISSUED FOR INCORRECT FIELDPROC NAME DURING REORG TABLESPACE WITH UNLOAD/RELOAD PARALLELISM

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DSNU272I ISSUED FOR INCORRECT FIELDPROC NAME DURING REORG
    TABLESPACE WITH UNLOAD/RELOAD PARALLELISM.
    

Local fix

  • Disable Parallelism.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
    *                 users of REORG utility with UNLOAD RELOAD    *
    *                 partition parallelism on table/column that   *
    *                 had field procedure defined.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: A REORG utility on a table space which  *
    *                      has a fieldproc defined on the table    *
    *                      issued MSGDSNU272I with an empty        *
    *                      fieldproc name.                         *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available.         *
    ****************************************************************
    A REORG with UNLOAD RELOAD parallel ran on a partitioned table
    space, which had a table with a fieldproc defined on it.  The
    REORG issued message DSNU272I - FIELD PROCEDURE ........ COULD
    NOT BE LOADED, which had an empty fieldproc name by mistake.
    The problem occurred because some unreliable information of the
    fieldproc was picked up by the subtasks.
    This problem may also exist in LOAD utility with partition
    parallelism.
    
    Additional Keywords: SQLFIELDPROC
    

Problem conclusion

  • The code has been modified to fix this problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM58289

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-02-15

  • Closed date

    2012-05-01

  • Last modified date

    2012-06-03

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

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

    UK78424 UK78425

Modules/Macros

  • DSNURWIF
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK78424

       UP12/05/17 P F205

  • R910 PSY UK78425

       UP12/05/17 P F205

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 June 2012