A fix is available
APAR status
Closed as new function.
Error description
New Function
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 SQL Performance Analyzer * * users of components * * IBM Db2 SQL Performance Analyzer * * users of components * * - ISPF and Batch Process packages from the * * DB2 system catalog * * - ISPF and Batch Process application DBRM * * - ISPF and Batch Process SQL from a * * sequential data set or PDS member * * - ISPF and Batch Process SQL from program * * source * * - ISPF and Batch Process a query number from * * the plan table * * - ISPF and Batch Process a QMF statement * * - Create Index * **************************************************************** * PROBLEM DESCRIPTION: New Functions * * 1. Support of temporal tables for * * basic functions of SQL PA * * 2. Set parameters for creation new * * index prqty/seqty/stogroup/bufferpool * * as optional * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** New Function. See Description.
Problem conclusion
Code was added to implement the enhancements.
Temporary fix
Comments
APAR Information
APAR number
PH41758
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2021-11-01
Closed date
2022-01-05
Last modified date
2022-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI78809
Modules/Macros
ANLBATCH ANLCAT ANLCBTCH ANLCHECK ANLCLOB ANLCMIGR ANLCRNE1 ANLCRNS1 ANLCRNT1 ANLCSV ANLDB2X ANLDPRM ANLEEE ANLGPRM ANLGPST ANLH11 ANLJB001 ANLJB002 ANLMAIN ANLNUXD ANLPDBRM ANLPFILE ANLPH117 ANLPH118 ANLPH200 ANLPH210 ANLPH211 ANLPH212 ANLPH300 ANLPH302 ANLPH400 ANLPH401 ANLPICP ANLPIDD ANLPIQLR ANLPITP ANLPLAN ANLPLIM1 ANLPLIM2 ANLPLIN ANLPNUXR ANLPOPTS ANLPPKGE ANLPRCR ANLPRER ANLPTBLF ANLPTCM ANLPTEX ANLPTLD ANLPTRP ANLPTSM ANLQMF ANLSERV ANLSQ2M ANLSQLPA ANLTABS ANLTSO ANLVER8 ANLWIF
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R510 PSY UI78809
UP22/01/06 P F201
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]
Document Information
Modified date:
02 February 2022