A fix is available
APAR status
Closed as new function.
Error description
FILE MANAGER DB2 ENHANCEMENT - FILE MANAGER DB2 DOES NOT ALLOW EDIT OF CLONE OR HISTORY TABLES
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: 1. File Manager DB2 component does not * * support edit of DB2 clone or history * * tables. * * 2. Differences between the output files * * produced by FM/DB2 export in DB2 unload * * format, and the DB2 unload utility. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** 1. The existing processing logic supports edit of synonymns, aliases, tables and views only. 2. a. The DB2 unload utility produces a VB file, the FM/DB2 export utility produces an FB file. b. The DB2 unload utility pads VARBINARY fields with binary zeroes, the FM/DB2 export utility pads VARBINARY fields with spaces. c. The DB2 unload utility sets the length for ROWID fields to 40. The FM/DB2 export utility sets the length for ROWID fields to the actual length of the data, typically less than 40 bytes.
Problem conclusion
Temporary fix
Comments
1. Enhancement APAR - File Manager DB2 component has been updated to support edit of DB2 clone and history tables. 2. The FM/DB2 export utility has been changed to produce a simliar output file to that produced by the DB2 unload utility.
APAR Information
APAR number
PI14209
Reported component name
FILE MANAGER Z/
Reported component ID
5655W6800
Reported release
C12
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-03-21
Closed date
2014-05-08
Last modified date
2014-06-03
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 UI17767
UP14/05/14 P F405
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:
03 June 2014