IBM Support

PM36763: WHEN THE GEN COMMAND IS ENTERED TO GENERATE SQL, ONLY THE SQL ISDISPLAYED, NEED TO ENTER PF3 AND REEXECUTE TO DISPLAY JCL & SQL.

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When the FM GEN command is entered to generate SQL, initially
only the SQL is displayed.  When PF3 is entered, and the GEN
command is reexecuted, the JCL is then displayed along with the
SQL. This occurs when using a MOD2 screen.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: All users of File Manager DB2 component.     *
****************************************************************
* PROBLEM DESCRIPTION: When performing a GEN prefix command    *
*                      the generated SQL does not include the  *
*                      JCL when an Execution Mode of BATCH     *
*                      has been selected or defaulted and the  *
*                      panel is being displayed on a MOD2      *
*                      (24x80) terminal.                       *
****************************************************************
* RECOMMENDATION: Apply the provided PTF.                      *
****************************************************************

    



Problem conclusion


    

  • The FM/DB2 panel has been modified to correct the problem.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PM36763
    • 

  • Reported component name
    FILE MANAGER Z/
    • 

  • Reported component ID
    5655W4700
    • 

  • Reported release
    B12
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2011-04-12
    • 

  • Closed date
    2011-07-29
    • 

  • Last modified date
    2011-09-01
    • 





    

  • 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
    5655W4700
    • 



Applicable component levels


    

  • RB12  PSY  UK70412
       UP11/08/04  P  F108
    • 



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 September 2011
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback