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
PM65339
Reported component name
FILE MANAGER Z/
Reported component ID
5655W4700
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-05-23
Closed date
2012-08-23
Last modified date
2012-09-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL FMN2LVLJ FMN2LVLK
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655W4700
Applicable component levels
RB1B PSY UK81289
UP12/08/28 P F208
RB12 PSY UK81290
UP12/08/28 P F208
RB13 PSY UK81291
UP12/08/28 P F208
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":"B10","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":"B10","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
05 September 2012