IBM Support

PH56864: THIS APAR WILL PROVIDE ENHANCEMENTS AND INTERNAL BUG FIXES.

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

  • Command Execution API support to be added in order to execute
and return the requested DSN Command.







Command Execution API support to be added in order to execute
and return the requested DSN Command.

Local fix

  • N/A

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of the IBM Unified Management Server   *
*                 for z/OS and Db2 Administration foundation   *
*                 Experience for z/OS                          *
****************************************************************
* PROBLEM DESCRIPTION: This APAR provides IBM Db2 Query        *
*                      Workload Tuner for z/OS Support for DSN *
*                      commands also IDAA Collects System      *
*                      Performance Data as described in the    *
*                      Problem Summary.                        *
****************************************************************
* RECOMMENDATION: Apply the PTF that is provided by this APAR. *
****************************************************************
The following new features are available to licensed Db2
Query Workload Tuner users:

1.Index Impact Analysis
Generates a report that shows the impact of applying the
index changes that are recommended by Index Advisor
and Workload Index Advisor.
2.Workload Virtual Index Analyzer
Enables you to test indexes to determine if the
performance of the SQL statements that comprise a
workload can be improved by creating indexes, dropping
indexes, or both.
3.Enables you to modify an existing workload.
4.Explains why SQL statements failed during a Workload
Explain operation.

Problem conclusion

  • Apply the PTF

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH56864
    • 

  • Reported component name
    DB2 ADMIN FND Z
    • 

  • Reported component ID
    5698ADF00
    • 

  • Reported release
    120
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2023-09-11
    • 

  • Closed date
    2023-09-26
    • 

  • Last modified date
    2023-10-02
    • 





    

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

    • 

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

    
UI93734
    

    • 



Modules/Macros


    

  • AFXDDLPX AFXOPPAX AFXVRPAX

    



Fix information


    

  • Fixed component name
    DB2 ADMIN FND Z
    • 

  • Fixed component ID
    5698ADF00
    • 



Applicable component levels


    

  • R120  PSY  UI93734
       UP23/09/30  P  F309
    • 



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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"120"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            03 October 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback