A fix is available
APAR status
Closed as new function.
Error description
Various changes to FM/DB2 related to DB2 version 10, including: 1. The SQL Reverse Engineering code (GEN command) will work against a DB2 version 10 system. 2. Changes to the Object List utility (Option 3.4) to show new columns added in DB2 version 10. 3. The SQL Advanced Prototyper will use DB2 version 10-specific syntax when connected to a DB2 version 10 system.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: 1. File Manager DB2 object list utility * * does not show all columns for some DB2 * * version 10 catalog tables. * * 2. File Manager DB2 Advanced SQL * * Prototyper (option 4.1) uses DB2 V9 * * syntax when connected to a DB2 V10 * * system. * * 3. File Manager DB2 GEN command (SQL * * Reverse Engineering) does not work * * when connected to a DB2 version 10 * * system. * * 4. In the FM/DB2 "DB2 Utilities" option * * specifying an '*' in the Table/Index * * space field for an UNLOAD of table * * spaces results in message * * "function terminated." * * 5. In the FM/DB2 object list utility, * * SQLCODE -010 or -104 after entering a * * line command against an object with an * * owner name containing 127 consecutive * * apostrophes. * * 6. In the FM/DB2 object list utility, * * when connected to DB2 version 9 or * * later systems, selecting extended * * object types including 1N, 1T, 1W * * result in a no operation. * * 7. In the FM/DB2 editor, the on-line * * help states that the REFS command is * * valid when entered in TABL mode, * * however entering this primary editor * * command results in MSG "REF not * * active". * * 8. In the FM/DB2 object list utility, * * entering a comment (COM line command) * * against a column results in an ISPF * * dialog error and/or abend if the * * comment is longer than 241 characters. * * 9. In the FM/DB2 object list utility, * * issuing the drop line command against * * a materialized query table results in * * a no operation. * * 10. In the FM/DB2 object list utility, * * attempting to browse a DBRM results in * * ABENDS0C4. * * 11. In the FM/DB2 object create * * utility, "Create storage group", the * * Storage group name field is 8 * * characters instead of 128 - the maximum * * size allowed for DB2 versions 8 and up. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** This APAR provides a number of enhancements to FM/DB2 to better tolerate/support DB2 version 10 systems.
Problem conclusion
Temporary fix
Comments
Enhancement Apar. File Manager DB2 has been enhanced to better support/tolerate DB2 version 10 systems. Note that the SQL line command, issued in the FM/DB2 object list utility (option 3.4) against a list of plans, packages, collections, DBRMs or triggers does not work when connected to a DB2 version 10 system. This APAR removes the SQL line command for the stated object types, when connected to DB2 version 10 systems only. The line command will be re-instated in a future PTF. This APAR also resolves the following internally reported problems: PFM numbers 5370, 5412, 5455, 5465, 5466, 5482, 5483, 5492, 5499.
APAR Information
APAR number
PM41019
Reported component name
FILE MANAGER Z/
Reported component ID
5655W4700
Reported release
B12
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-06-08
Closed date
2011-07-07
Last modified date
2011-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK69557 UK69558 UK69559 UK69560 UK69561 UK69562
Modules/Macros
FMNABXIT FMNDBCB2 FMNDB27 FMNDYNTP FMNEDIT1 FMNED0DY FMNPDSN FMNPECPY FMNPPMN FMNRD2IN FMNRMR2 FMNTPD ***This field was truncated. To obtain the full apar record, please contact your local support center.***
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655W4700
Applicable component levels
RB1A PSY UK69558
UP11/07/12 P F107
RB1B PSY UK69559
UP11/07/12 P F107
RB10 PSY UK69557
UP11/07/12 P F107
RB11 PSY UK69560
UP11/07/12 P F107
RB12 PSY UK69561
UP11/07/12 P F107
RB13 PSY UK69562
UP11/07/13 P F107
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":"B12","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":"B12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 August 2011