IBM Support

PH10338: IFCID369 HAS INCORRECT VALUE IN QWACESC

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

  • IFCID369 has incorrect value in QWACESC

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* All DB2 for z/OS users of IFCID 369                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Users of IFCID 369, values of QWACESC                        *
* appear too high.                                             *
****************************************************************
* RECOMMENDATION:                                              *
* Apply corrective PTF when available                          *
****************************************************************
Normally for IFCID 3 and 148, the field QWACESC is the ending
store clock value. For IFCID 369, the field signifies the total
elapsed time threads have been into DB2 for a particular
connection.
During aggregation of the threads, one during thread reuse may
not have updated it's statistics for elapsed time while the IFC
ID 369 was issued. This timing window resulted in a very high
value to occur in the field QWACESC.

    



Problem conclusion


    

  • DB2 has been modified to exclude incoherent during retrieval of
the IFCID 369 record.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH10338
    • 

  • Reported component name
    DB2 OS/390 & Z/
    • 

  • Reported component ID
    5740XYR00
    • 

  • Reported release
    B10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2019-03-28
    • 

  • Closed date
    2019-12-27
    • 

  • Last modified date
    2020-02-04
    • 





    

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

    • 

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

    
UI67195 UI67196
    

    • 



Modules/Macros


    

  • DSNWVZPS

    



Fix information


    

  • Fixed component name
    DB2 OS/390 & Z/
    • 

  • Fixed component ID
    5740XYR00
    • 



Applicable component levels


    

  • RB10  PSY  UI67195
       UP20/01/03  P  F001
    • 

  • RC10  PSY  UI67196
       UP20/01/03  P  F001
    • 



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":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            04 February 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback