IBM Support

PM05014: WHEN GENERATING SQL FROM A DB2 TABLE, DATA SET NOT FOUND WHEN DSN FOR 'OUTPUT FILE AND EXECUTION MODE:' IS LEFT BLANK.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When generating SQL from a DB2 table using FM/DB2 under ISPF,
    output file (DDname SQL) is not found.  This occurs when the
    data set name field for the 'Output file and execution mode:'
    is left blank.
    ------------------------------------------------
    This APAR also contains a sysroute for
    APAR PK92028.
    

Local fix

  • Preallocate data set and specify the data set name in the
    dsn field for 'Output file and execution mode:'
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All File Manager users of the DB2 component. *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. PK92028                              *
    *                        Message 'Dataset not found' produced  *
    *                      when using the GEN command and the      *
    *                      execution Mode is TSO.                  *
    *                      Panel is Generate SQL From DB2 Catalog. *
    *                      2. PK99862                              *
    *                      When using the FM DB2 GEN command,      *
    *                      a number of problems exist with the     *
    *                      output data set specification in        *
    *                      TSO mode.                               *
    *                      Messages Input Not Accepted and         *
    *                      Data Set Not found may be produced.     *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    1. Problem occurs when FM allocates a system generated temporary
    dataset as input to to the GEN command. Because it is not
    catalogued the allocate fails.
    2.
    In TSO mode the default output dataset (ie when the Output Data
    Set Name is left blank) should be a temporary dataset used to
    display the output of the GEN command. It is not being allocated
    correctly and misleading messages are produced.
    Also the field help panel should be updated to ensure that the
    behaviour with TSO and Batch modes is clear.
    

Problem conclusion

  • File Manager DB2 has been updated to correct the problems.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM05014

  • 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

    2010-01-13

  • Closed date

    2010-06-16

  • Last modified date

    2010-07-02

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

    PK99862

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

Modules/Macros

  • FMN2LVL  FMN2LVLJ FMN2LVLK
    

Fix information

  • Fixed component name

    FILE MANAGER ZO

  • Fixed component ID

    5655V5200

Applicable component levels

  • RA1B PSY UK57983

       UP10/06/29 P F006

  • RA12 PSY UK57994

       UP10/06/29 P F006

  • RA13 PSY UK57998

       UP10/06/29 P F006

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:
02 July 2010