A fix is available
APAR status
Closed as program error.
Error description
An "Excessive number of execute statements" message can occur when specifying more than 8 generic userids at customization
Local fix
Manually split the created job into smaller jobs
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 SQL Performance Analyzer * * users of components: * * - TCz customization panel and process * * - Create Db2 objects for SQLPA * **************************************************************** * PROBLEM DESCRIPTION: Not possible to create more than 8 * * secondary authids * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** Not possible to create more than 8 secondary authids due to too many generated steps in JCL
Problem conclusion
New enhancement for creating explain tables using the stored procedure ADMIN_EXPLAIN_MAINT has been implemented, which significantly reduced the number of steps in JCL
Temporary fix
Comments
APAR Information
APAR number
PH48729
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-08-16
Closed date
2022-10-11
Last modified date
2022-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ANLCHECK ANLCKTBL ANLDCRE8 ANLJCRE8 ANLSQLPA ANLTSO
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R510 PSY UI82792
UP22/10/14 P F210
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 November 2022