A fix is available
APAR status
Closed as program error.
Error description
ANL3031E OVERFLOW CONDITION DETECTED DURING INTERNAL CALCULATIONS. CHECK STATISTICS, CORRECT, THEN RE-RUN PROGRAM. -ADDITIONAL SYMPTOMS: 1. User not able to write output explain report in a partitioned Data Set. The following message is issued: THE EXPLAIN REPORT FILE CHOSEN IS NOT CURRENTLY AVAILABLE CHECK YOUR SPELLING AND REENTER ON "DEFINE OUTPUT" PANEL The SQL PA error code set by this message is: 9006
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 SQL Performance Analyzer. * **************************************************************** * PROBLEM DESCRIPTION: ANL3031E OVERFLOW CONDITION DETECTED * * DURING INTERNAL CALCULATIONS. CHECK * * STATISTICS, CORRECT, THEN RE-RUN * * PROGRAM. * * -ADDITIONAL SYMPTOMS: * * 1. User not able to write output * * explain report in a partitioned Data * * Set. The following message is issued: * * THE EXPLAIN REPORT FILE CHOSEN IS NOT * * CURRENTLY AVAILABLE CHECK YOUR * * SPELLING AND REENTER ON "DEFINE * * OUTPUT" PANEL. The SQL PA error code * * set by this message is: 9006 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK66762
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2008-05-28
Closed date
2008-09-30
Last modified date
2008-11-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK40348
Modules/Macros
ANLINIT ANLPGM31
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R310 PSY UK40348
UP08/10/03 P F810
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"310"}]
Document Information
Modified date:
04 January 2021