A fix is available
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 / Xsystem
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:
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C12","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
04 December 2012