IBM Support

PK11393: QUERY MONITOR DISPLAYS EXCESSIVE CPU VALUES FOR SOME STATEMENTS THE CQM OFFLOAD FAILS WITH A -433 SQL CODE. ( SQLCODE433 )

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

  • Query Monitor displays excessive CPU values for some SQL
statements.  In these instances, the CPU values displayed
exceed elapsed time displayed.  Code has been modified to
report the correct CPU time.
******
ADDITIONALLY FIXED
When a user attempts to offload CQM data into DB2, the offload
fails with a -433 SQL code.  Additionally, the following return
code (RC04) and reason code (RS07) are generated from conversion
services.  The CQM offload process will be updated to report the
appropriate error and the text retrieval process will be
adjusted
to use the correct CCSID.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Query Monitor.                  *
****************************************************************
* PROBLEM DESCRIPTION: Query Monitor displays excessive CPU    *
*                      values for some SQL statements.  In     *
*                      these instances, the CPU values         *
*                      displayed exceed elapsed time           *
*                      displayed.  Code has been modified to   *
*                      report the correct CPU time.            *
****************************************************************
* RECOMMENDATION: APPLY the PTF.                               *
****************************************************************
Code has been changed to correct this condition.

    



Problem conclusion


    

  • APPLY the PTF.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PK11393
    • 

  • Reported component name
    DB2 QUERY MONIT
    • 

  • Reported component ID
    5655E6701
    • 

  • Reported release
    210
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2005-09-02
    • 

  • Closed date
    2005-10-05
    • 

  • Last modified date
    2005-11-03
    • 





    

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

    • 

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

    
UK07865
    

    • 



Modules/Macros


    

  •    CQMMESQL CQMMSSQL

    



Fix information


    

  • Fixed component name
    DB2 QUERY MONIT
    • 

  • Fixed component ID
    5655E6701
    • 



Applicable component levels


    

  • R210  PSY  UK07865
       UP05/10/25  P  F510
    • 



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.
    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"210"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            12 April 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback