PM68841: FM/DB2 INCORRECTLY CREATING 3 COLUMN DEFINITIONS.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The create PLAN_TABLE option enables us to create plan tables
    for DB2 V9.
    
    However FM incorrectly created 3 column definitions which are
    not in V9.1 format.
    
    1. APPLNAME     - char(8)     should be varchar(24)
    2. GROUP_MEMBER - char(8)     should be varchar(24)
    3. VERSION      - varchar(64) should be varchar(122)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: The File Manager DB2 component Explain  *
    *                      utilities generates a PLAN_TABLE with   *
    *                      incorrect definitions for DB2 versions  *
    *                      9 and 10.  Similar problems exist for   *
    *                      the DSN_FUNCTION_TABLE and              *
    *                      DSN_STATEMNT_TABLE definitions          *
    *                      generated for DB2 versions 9 and 10.    *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    The data type for the "APPLNAME", "VERSION" and "GROUP_MEMBER"
    columns were changed at DB2 version 9 - these changes are not
    included when the EXPLAIN utility creates a PLAN_TABLE,
    DSN_FUNCTION_TABLE and DSN_STATEMNT_TABLE.
    

Problem conclusion

  • File Manager DB2 component has been changed to generate the
    correct PLAN_TABLE, DSN_FUNCTION_TABLE and DSN_STATEMNT_TABLE,
    depending on the version of DB2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM68841

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655W6800

  • Reported release

    C12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-13

  • Closed date

    2012-11-19

  • Last modified date

    2012-12-04

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

    PM65339

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

Modules/Macros

  •    FMN2LVL
    

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655W6800

Applicable component levels

  • RC12 PSY UK83656

       UP12/11/24 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

z/OS family

Software version:

C12

Reference #:

PM68841

Modified date:

2012-12-04

Translate my page

Machine Translation

Content navigation