A fix is available
APAR status
Closed as program error.
Error description
Incorrect cursor placement in plan_table report
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 SQL Performance Analyzer users * * of components: * * - ISPF and packages from the Db2 system * * catalog * * - ISPF Process application DBRM * * - ISPF Process SQL from a sequential data * * set or PDS member * * - ISPF Process SQL from program source * * - ISPF Process a query number from the * * plan table * * - ISPF Process QMF statement * * - ISPF Process a stabilized dynamic query * **************************************************************** * PROBLEM DESCRIPTION: Incorrect cursor placement in * * plan_table report * **************************************************************** * RECOMMENDATION: Apply the PTF fix * **************************************************************** Incorrect cursor placement in plan_table report
Problem conclusion
Code logic was corrected to fix the issue described.
Temporary fix
Comments
APAR Information
APAR number
PH47056
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-06-07
Closed date
2022-08-09
Last modified date
2022-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ANLBATCH ANLCDISC ANLCFINE ANLCMACR ANLICRE8 ANLMAIN ANLPH020 ANLPHV03 ANLSQLPA ANLTSO
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R510 PSY UI81872
UP22/08/12 P F208
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 September 2022