IBM Support

PH50653: EXTENDED SUPPORT FOR > 30 BYTE COLUMN NAMES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Extended support for > 30 byte column names.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 and Db2 Object Comparison Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR enhances Db2 Admin Tool to    *
    *                      further support column names greater    *
    *                      than 30 characters.                     *
    ****************************************************************
    The following components are enhanced to support additional
    column names greater than 30 characters:
    
    1.GEN and WSL validation:
    The DESCRIBE function is enhanced to save the full column
    names to resolve the restriction that column names returned in
    the SQLDA SQLNAME field in Db2 13 are truncated to
    30 characters.
    
    2.Panel support
    A COLUMNS command was added on the 'Alter Table' Check
    Constraint panel ADB21TAK to help users include column names
    in the check constraint.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH50653

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    D10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-11-03

  • Closed date

    2022-11-08

  • Last modified date

    2022-12-01

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

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

    UI83177

Modules/Macros

  • ADB21TAC ADB21TAK ADB2CLU0 ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME
    ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU
    ADB2PA   ADB2PA7  ADB2PRP  ADB2WVL  ADB3000
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RD10 PSY UI83177

       UP22/11/11 P F211

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 December 2022