IBM Support

PI48165: PROVIDE ADDITIONAL SORT EXECUTION STATISTICS TO DB2

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Provide additional sort execution statistics to DB2.
These statistics can only be exploited by DB2 11 for z/OS
utilities when the PTF for DB2 11 APAR PI47606 has been
installed.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Sort for z/OS.                  *
****************************************************************
* PROBLEM DESCRIPTION: Provide additional sort execution       *
*                      statistics to DB2. These statistics     *
*                      can only be exploited by DB2 11 for     *
*                      z/OS utilities when the PTF for DB2 11  *
*                      APAR PI47606 has been installed.        *
****************************************************************
* RECOMMENDATION: APPLY the PTF.                               *
****************************************************************
Code has been changed to correct this condition.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • APPLY the PTF.

    



APAR Information




    

  • APAR number
    PI48165
    • 

  • Reported component name
    DB2 SORT FOR Z/
    • 

  • Reported component ID
    5655W4200
    • 

  • Reported release
    210
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2015-09-03
    • 

  • Closed date
    2015-11-02
    • 

  • Last modified date
    2015-12-02
    • 





    

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

    • 

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

    
UI32593
    

    • 



Modules/Macros


    

  •    CNKANLZM CNKCANLY CNKCBIN  CNKCE15G CNKCKXA
CNKCMAIN CNKCSISO CNKCSVC  CNKCTIMR CNKC1INI CNKDBSTR CNKDCOPT
CNKD1INI CNKD1MAI CNKD3CMS CNKD3DBS CNKD3INI CNKD3SIO CNKD3TER
CNKF1INI CNKIINIT CNKKQ010 CNKKQ059 CNKKQ068 CNKKQ167 CNKKQ168
CNKKQ178 CNKKQ179 CNKKQ182 CNKKQ183 CNKKQ184 CNKKQ186 CNKKQ188
CNKKQ206 CNKKQ218 CNKKQ230 CNKKQ377 CNKKQ405 CNKKQ406 CNKKQ409
CNKKQ439 CNKKQ461 CNKKQ524 CNKNC539 CNKNC540 CNKT012  CNKT015
CNKT018  CNKT019  CNKT020  CNKT029  CNKT034  CNKT035  CNKT044
CNKT046  CNKT049  CNKT055  CNKT056  CNKT060  CNKT074  CNKT129
CNKT152  CNKT212  CNKT242  CNKT296  CNKXCIBS CNK0SETU CNK1SWIO

    



Fix information


    

  • Fixed component name
    DB2 SORT FOR Z/
    • 

  • Fixed component ID
    5655W4200
    • 



Applicable component levels


    

  • R210  PSY  UI32593
       UP15/11/06  P  F511
    • 



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":"BU048","label":"IBM Software"},"Product":{"code":"SSC7VAA","label":"Db2 Sort"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 December 2015
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback