A fix is available
APAR status
Closed as program error.
Error description
When using the GEN command for a tablespace listed on FM/DB2 panel FMN2POLS, and the tablespace is a Universal Table Space (UTS), the DDL generated is for a partitioned tablespace.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: The File Manager DB2 GEN command (SQL * * reverse engineering) generates * * incorrout when processing a UTS table * * space (SYSIBM.SYSTABLESPACE.SEGSIZE > * * 0). The SEGSIZE parameter is omitted. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** An out-of-date version of the SQL Reverse Engineering code is generating incorrect output.
Problem conclusion
File Manager DB2 has been updated to correct the problem.
Temporary fix
Comments
APAR Information
APAR number
PM52553
Reported component name
FILE MANAGER ZO
Reported component ID
5655V5200
Reported release
A12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-11-17
Closed date
2011-12-16
Last modified date
2012-01-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK74930 UK74931
Modules/Macros
FMN2ACA FMN2ACC FMN2ADB FMN2ADI FMN2AFM FMN2AGE FMN2ALC FMN2AMG FMN2AMK FMN2APA FMN2APN FMN2APR FMN2AP3 FMN2AP5 FMN2AP6 FMN2AP7 FMN2ARC FMN2ARE FMN2ARG FMN2ARH FMN2ARM FMN2ARP FMN2ARR FMN2ARS FMN2ART FMN2ARU FMN2ARY FMN2ASI FMN2ASL FMN2ASW FMN2AS1 FMN2AUO FMN2AXF FMN2AZP FMN2LVL FMN2LVLJ FMN2MSG FMN2MSGJ FMN2MSGT JADLA12J
Fix information
Fixed component name
FILE MANAGER ZO
Fixed component ID
5655V5200
Applicable component levels
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":"A12","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":"A12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 January 2012