A fix is available
APAR status
Closed as new function.
Error description
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL Db2 for z/OS SQL Tuning Services users * **************************************************************** * PROBLEM DESCRIPTION: * * ENHANCEMENT & IMPROVEMENT FOR * * SQL TUNING SERVICES 2.1 * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** 1. Provide a new restful API as "Capture SQL from z/OS dataset" 2. Update value of Explain_Status for each statement in a Workload 3. Enhancements on script to simplify configuration 4. Reduce idle CPU consumption 5. Enhancement on sample JCL to remove dependency of SYSPROC.DSNAHVPM and eliminate SYSADM authority 6. Fix the issue of Workload Access Path Comparison API to remove the unnecessary internal jobs 7. Fix the issue of VE with RGLIST access type for Db2 13 for z/OS
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH53536
Reported component name
SQL TUNING SERV
Reported component ID
5655R1406
Reported release
210
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-03-28
Closed date
2023-04-14
Last modified date
2023-05-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI91459
Modules/Macros
DSN5NDTG DSN5NDRP DSN5DTMS DSN5RTRP DSN5STRT DSN5RTTG DSN5RUDF DSN5INSH DSN5RGRT
Fix information
Fixed component name
SQL TUNING SERV
Fixed component ID
5655R1406
Applicable component levels
R210 PSY UI91459
UP23/04/18 P F304
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":"210"}]
Document Information
Modified date:
03 May 2023