IBM Support

PK08883: BLANKS ADDED TO TABLE NAMES IN RESTORE DDL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When Object Restore generates recovery DDL, blanks are
    erroneously being added to the ends of object names.  The
    tables are rebuilt with these blanks which can cause problems
    when other applications try to access the newly created table.
    Table may be created with trailing blanks as part of the table
    name.
    

Local fix

  • Delete the spaces between the last character of the object name
    and the ending double quote so that table is rebuilt with no
    spaces in the name.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Object Restore.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: When Object Restore generates recovery  *
    *                      DDL, blanks are erroneously being added *
    *                      to the ends of object names.  The       *
    *                      tables are rebuilt with these blanks    *
    *                      which can cause problems when other     *
    *                      applications try to access the newly    *
    *                      created table. Table may be created     *
    *                      with trailing blanks as part of the     *
    *                      table name.                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Code has been changed to correct this conndition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK08883

  • Reported component name

    DB2 OBJECT REST

  • Reported component ID

    5655E7201

  • Reported release

    210

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2005-07-14

  • Closed date

    2005-08-15

  • Last modified date

    2005-09-02

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

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

Modules/Macros

  •    AUO$ALLC
    

Fix information

  • Fixed component name

    DB2 OBJECT REST

  • Fixed component ID

    5655E7201

Applicable component levels

  • R210 PSY UK06296

       UP05/08/25 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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0"}]

Document Information

Modified date:
30 March 2021