PH56970: SQL TUNING SERVICE INTERNAL ENHANCEMENT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SQL tuning service internal enhancement
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2z SQL Tuning service users                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Workload Environment Capture                                 *
  * Workload Analytics Acceleration                              *
  * Advisor                                                      *
  * Workload Candidate Acceleration                              *
  * Analyzer                                                     *
  * SQL capture API, support new value                           *
  * of S in the VALID column of                                  *
  * SYSPACKAGE and                                               *
  * SYSPACKCOPY catalog table[V13 Support]                       *
  * Allow user to customize the versions                         *
  * of bound packages for SQL Capture API                        *
  * and                                                          *
  * Index Impact Advisor API [Enhancement]                       *
  * TLS 1.3 Support                                              *
  * Add job_description to specify the                           *
  * source job information for IIA API                           *
  * Defects:                                                     *
  * 1.create workload API, handle empty                          *
  * sql array                                                    *
  * 2.capture from stmtcache API, support                        *
  * lowercase                                                    *
  * 3.Index impact analysis, tell user                           *
  * which workload is one statement from                         *
  * 4.workload whatif get nullpoint error                        *
  * when create index array is null                              *
  * 5.Release resource after user cancel                         *
  * long running advisors                                        *
  * 6.workload whatif repo connecitonleak                        *
  * 7.WIA foreign key violation                                  *
  * 8.WCQE for one workload concurrency,                         *
  * git issue 1921                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Workload Environment Capture
  Workload Analytics Acceleration Advisor
  Workload Candidate Acceleration Analyzer
  SQL capture API, support new value of
  S in the VALID column of SYSPACKAGE and
  SYSPACKCOPY catalog table[V13 Support]
  Allow user to customize the versions of
  bound packages for SQL Capture API and
  Index Impact Advisor API [Enhancement]
  TLS 1.3 Support
  Add job_description to specify the source
  job information for IIA API
  Defects:
  1. create workload API, handle empty sql
  array
  2. capture from stmtcache API, support
  lowercase
  3. Index impact analysis, tell user which
  workload is one statement from
  4. workload whatif get nullpoint error when
  create index array is null
  5. Release resource after user cancel long
  running advisors
  6. workload whatif repo conneciton leak
  7. WIA foreign key violation
  8. WCQE for one workload concurrency,
  git issue 1921
  

Problem conclusion

Temporary fix

Comments

• Workload Environment Capture
  Workload Analytics Acceleration Advisor
  Workload Candidate Acceleration Analyzer
  SQL capture API, support new value of
  S in the VALID column of SYSPACKAGE and
  SYSPACKCOPY catalog table[V13 Support]
  Allow user to customize the versions of
  bound packages for SQL Capture API and
  Index Impact Advisor API [Enhancement]
  TLS 1.3 Support
  Add job_description to specify the source
  job information for IIA API
  Defects:
  1. create workload API, handle empty sql
  array
  2. capture from stmtcache API, support
  lowercase
  3. Index impact analysis, tell user which
  workload is one statement from
  4. workload whatif get nullpoint error when
  create index array is null
  5. Release resource after user cancel long
  running advisors
  6. workload whatif repo conneciton leak
  7. WIA foreign key violation
  8. WCQE for one workload concurrency,
  git issue 1921
  

APAR Information

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

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

  UI93741

Modules/Macros

• DSN5UPR2 DSN5NDTG DSN5UPR1 DSN5UPR3 DSN5OAAA DSN5DTMS DSN5REPO
  DSN5RTTG DSN5INSH DSN5RGRT DSN5NBND DSN5OIA9
  

Fix information

• Fixed component name

  SQL TUNING SERV

• Fixed component ID

  5655R1406

Applicable component levels

• R210 PSY UI93741

     UP23/09/29 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.