PH58058: 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 (TMS) users                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Enhancement:                                                 *
  * Add more filters to APIs of                                  *
  *     'GET/DELETE jobs'.                                       *
  * Add script repoDBCredReset.sh                                *
  *     to enable service admin to reset                         *
  *     repository database connection                           *
  *     logon credentials.                                       *
  * Add more properties in API of                                *
  *     'GET connection profile'.                                *
  * Remove dependency on                                         *
  *     db2jcc_license_cisuz.jar.                                *
  * Defects fixed:                                               *
  * WIA : foreign key violation,                                 *
  *     index consolidation.                                     *
  * Capture from dataset :                                       *
  *     handle PDS without members.                              *
  * Connection privileges :                                      *
  *     /userprofileprivileges does not                          *
  *     require empty user or owner array.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Enhancement:
  Add more filters to API of 'GET/DELETE jobs'.
  Add script repoDBCredReset.sh to enable service admin
      to reset repository database connection logon credentials.
  Add more properties in API of 'GET connection profile'.
  Remove dependency on db2jcc_license_cisuz.jar.
  Defects fixed:
  WIA : foreign key violation, index consolidation.
  Capture from dataset : handle PDS without members.
  Connection privileges : /userprofileprivileges does not require
      empty user or owner array.
  

Problem conclusion

Temporary fix

Comments

• Enhancement:
  Add more filters to API of 'GET/DELETE jobs'.
  Add script repoDBCredReset.sh to enable service admin to
      reset repository database connection logon credentials.
  Add more properties in API of 'GET connection profile'.
  Remove dependency on db2jcc_license_cisuz.jar.
  Defects fixed:
  WIA : foreign key violation, index consolidation.
  Capture from dataset : handle PDS without members.
  Connection privileges : /userprofileprivileges does not
      require empty user or owner array.
  

APAR Information

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

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

  UI94641

Modules/Macros

• DSN5DTMS DSN5INSH
  

Fix information

• Fixed component name

  SQL TUNING SERV

• Fixed component ID

  5655R1406

Applicable component levels

• R210 PSY UI94641

     UP23/12/08 P F312

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.