IBM Support

PM41019: ENHANCEMENTS TO FM/DB2 TO PROVIDE ADDITIONAL TOLERATION/SUPPORT FOR DB2 VERSION 10.

A fix is available

Subscribe

You can track all active APARs for this component.

 

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