IBM Support

PM48450: DISTRIBUTED DB ACCESS THREAD SUMMARY ( ZDBACT) SQL RECV & SENT ROWS ARE ZERO. PF11 TO DIST. THREAD DETAIL, RECV & SENT ROWS OK

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

  • Distributed DB Access Thread Summary ( ZDBACT) SQL RECV & SENT
rows are zero.  If you use PF11 to zoom to Distributed Thread
Detail, RECV & SENT Rows are non-zero.

Local fix

  • Use PF11 to find the values of RECV and SENT rows for
Distributed Threads.

Problem summary

  • ****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
*                 users of component:                          *
*                 -   Classic Interface                        *
****************************************************************
* PROBLEM DESCRIPTION: Values of SQL RECEIVE and SENT ROWS for *
*                      distributed  dbaccess threads are zero  *
*                      on ZDBACT screen.                       *
*                                                              *
****************************************************************
* RECOMMENDATION: Apply this PTF                               *
*                                                              *
****************************************************************
PROBLEM SUMMARY:
Workarea fields used in 64-bit calculations are not defined
correctly.

PROBLEM CONCLUSION:
Correct workarea field definitions used in 64-bit calculations.

Problem conclusion

  • Correct workarea field definitions used in 64-bit calculations.

KEYWORDS :  64-BIT SQL RECEIVE SENT ROWS ZDBACT
            DISTRIBUTED  DBACCESS

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PM48450
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    510
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2011-09-22
    • 

  • Closed date
    2011-12-05
    • 

  • Last modified date
    2012-01-01
    • 





    

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

    • 

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

    
UK74488
    

    • 



Modules/Macros


    

  • KO2APCCA KO2APCCK KO2APCC2 KO2APC1A KO2APC1K
KO2APC12 KO2APC2A KO2APC2K KO2APC22 KO2APC3A KO2APC3K KO2APC32
KO2APC4A KO2APC4K KO2APC42 KO2CDFCA KO2CDFCK KO2CDFC2 KO2CT2SA
KO2CT2SK KO2CT2S2 KO2ODSTB KO2OTHJB KO2OTHKB KO2OTHMB KO2OTHNB
KO2OTHOB KO2OTHPB KO2OTHQB KO2OTHRB KO2OTHSB KO2OTHTB KO2OTHUB
KO2OTHVB KO2OTHWB KO2OTHXB KO2OTHYB

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R510  PSY  UK74488
       UP11/12/07  P  F112
    • 



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":"5.1.0","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":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            01 January 2012
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback