IBM Support

PI11459: VALUES SPECIFIED FOR SHOWSQL ON FM/DB2 OPTION 0.0.9 ARE NOT HONORED ONCE THE SQL COMMAND IS ENTERED ON TABLE VIEW PANEL.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The values specified for Space Units, Primary Quantity and
    Secondary Quantity for SHOWSQL in FM/DB2 option 0.0.9, are
    not honored once the SHOWSQL command is entered on the Table
    View panel.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: In File Manager DB2 component, the data *
    *                      set allocation values shown on the "Set *
    *                      Output Data Set Allocation Options"     *
    *                      panel are not honored.                  *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    Default allocation values of "cylinders", primary and secondary
    allocation quantities of 1 are used regardless of the values
    set on the "Set Output Data Set Allocation Options" panel.
    

Problem conclusion

  • File Manager DB2 component has been updated to correct the
    problem.
    
    Publication Closing Code: DEVCHNG
    For the documentation changes associated with this APAR,
    please refer to:
    ftp://public.dhe.ibm.com/software/websphere/awdtools/
        filemanager/fmv13apar.pdf
    
    The changes are to the following publication:
    
    PUB ID        PUB NAME
    ------------  ----------------------------------------
    
    SC19-4120-00  File Manager for z/OS V13R1 User's Guide
                  and Reference for DB2 Data
    
    The latest published manuals can be found at:
    http://www.ibm.com/software/awdtools/filemanager/library/
           index.html.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI11459

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655Q1200

  • Reported release

    D12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-02-11

  • Closed date

    2014-04-13

  • Last modified date

    2014-05-02

  • APAR is sysrouted FROM one or more of the following:

    PM99714

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • FMN2LVL
    

Publications Referenced
SC19412000    

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655Q1200

Applicable component levels

  • RD12 PSY UI17000

       UP14/04/19 P F404

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":"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":"D12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
02 May 2014