IBM Support

PM38027: MSG ' MISSING UNLDDN ' ON HPU MIG AT DB OR TS LEVEL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Administration Tool for z/OS MIG ( migrate ) works ok at
    table level, but fails on DB or TS level, but only for some
    objects.
    .
    Failure occurs only when DB2 catalog contains blanks which are
    probably present on DB2 objects created on a prior DB2 release.
    Reported case found trailing blanks in DBNAME from SYSTABLES .
    .
    Admin skeleton adb28hpu builds failing S1 job using FULLTSNM
    variable which fails when trailing blanks are encountered.
    Problem resolved by updating REXX routine ADB28SUB .
    .
    Additional symptoms: msgINZU107E UNLDDN NOT SPECIFIED
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS' Migrate ( MIG ) function who select    *
    *                 the High Performance Unload ( HPU ) option.  *
    ****************************************************************
    * PROBLEM DESCRIPTION: The Migrate (MIG)/HPU UNLOAD step from  *
    *                      the S1 job receives an error message:   *
    *                                                              *
    *                      INZU107E UNLDDN NOT SPECIFIED           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The internal ISPF table shows trailing spaces after the DBNAME.
    Further analysis indicates that the spaces are not a result of
    the DB2 Admin Tool.  They are coming from the DB2 Catalog,
    most likely due to a DB2 migration (not MIG).
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM38027

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-04-28

  • Closed date

    2011-06-14

  • Last modified date

    2011-07-05

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

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

    UK68761 UK68762

Modules/Macros

  •    ADBH1SAR ADB21SA  ADB21SAR ADB21SAV ADB21SA0
    ADB21TAV ADB21XAR ADB21XAS ADB26CX  ADB27CA  ADB27CR  ADB28SUB
    ADB71
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK68761

       UP11/06/17 P F106

  • R720 PSY UK68762

       UP11/06/17 P F106

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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 July 2011