A fix is available
APAR status
Closed as new function.
Error description
November 2023 FIXES AND PRODUCT UPDATES for IBM Db2 Administration Foundation. As part of this update following enhancement will be rolled out. * Extraction of all queries running on IDAA * IDAA services logging improvement * Show BackendStatisticsCollectionTimestamp in SYSPROC.ACCEL_GET_TABLES_INFO * Enhancement to indicate the last time a table was used with a query in IDAA to allow for smarter table management * New column to be added in query monitoring called as Application Stall Time
Local fix
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 support with * * IBM Db2 Query Workload Tuner for z/OS * * as described in the Problem Summary. * **************************************************************** * RECOMMENDATION: Apply the PTF that is provided by this APAR. * **************************************************************** 1. Capture SQL from a z/OS data set enables you to identify and display SQL statements that exist in a sequential data set or partitioned data set member and work with those statements by using other Db2 Administration Foundation features. 2. Workload-level support for Capture Query Environment enables you to capture information about the environments in which all the queries in a workload run. Before this update, the Capture Query Environment supported only single queries
Problem conclusion
Apply the PTF that is provided by this APAR.
Temporary fix
Comments
APAR Information
APAR number
PH58303
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-11-21
Closed date
2023-12-19
Last modified date
2024-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI94996
Modules/Macros
AFXDDLPX AFXOPPAX AFXVRPAX
Fix information
Fixed component name
DB2 ADMIN FND Z
Fixed component ID
5698ADF00
Applicable component levels
R120 PSY UI94996
UP23/12/22 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.
[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"120"}]
Document Information
Modified date:
02 January 2024