IBM Support

PK48768: SQL > 4076 BYTES INCORROUT OMEGAMON II FOR DB2 OR OMEGAMON FOR DB2 (CLASSIC)

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

  • SQL longer than 4976 bytes displayed on CUA or Classic is
truncated or a DBCS error message is displayed.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
*                 users of component:                          *
*                 -   Classic Interface                        *
*                 -   CUA Interface                            *
****************************************************************
* PROBLEM DESCRIPTION: Incorrout from EDM Pool SQL cache       *
*                      snapshot                                *
****************************************************************
* RECOMMENDATION: Apply this PTF                               *
****************************************************************
PROBLEM SUMMARY:
Various problems related to EDMpool SQLcache snapshot
1.Slow performance getting EDMPool SQLcache snapshot
2.Incorrect text in the middle of a long SQL statement(EDMPool
  and realtime SQL)

    



Problem conclusion


    

  • 1.Retrieve full SQL text at EDD3 display. Use 60 bytes sql text
  from statistics to improve performance.rface for all
  DB2 releases.
2.Correct errors in SQL text parser routine. This is for sql
  text longer than 4097 only.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PK48768
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    410
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2007-07-11
    • 

  • Closed date
    2008-01-29
    • 

  • Last modified date
    2008-01-29
    • 





    

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

    
OA21594
    

    • 

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

    
PK60104
    

    • 



Modules/Macros


    

  • DUMM5KO2

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R410  PSY  UK30734
       UP07/11/08  P  F711
    • 



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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            29 January 2008
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback