PM68841: FM/DB2 INCORRECTLY CREATING 3 COLUMN DEFINITIONS.

Obtain the fix for this APAR.

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 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.