A fix is available
APAR status
Closed as program error.
Error description
Because DB2 doesn't allocate enough storage, ABEND04E RC00E2000F at DSNXIATB.DSNSVSFB + 0858 occurs when adding multiple columns to a table. The storage overlay may result in DB2 crash after a while. e.g. ALTER TABLE TB1 ADD C1 TIME ADD C2 DATE ADD C3 CHAR(2) ..... ADD C34 CHAR(6);
Local fix
Reduce the number of ADD clause
Problem summary
**************************************************************** * USERS AFFECTED: DB2 10 for z/OS users of ALTER TABLE with * * multiple ADD COLUMN clauses specified * * in one statement. * **************************************************************** * PROBLEM DESCRIPTION: ALTER TABLE may result in ABEND04E * * RC00E2000F AT DSNXIATB.DSNSVSFB * * OFFSET0858 when the statement * * contains more than one ADD COLUMN * * clause. * **************************************************************** * RECOMMENDATION: * **************************************************************** ALTER TABLE may result in ABEND04E RC00E2000F AT DSNXIATB.DSNSVSFB OFFSET0858 when the statement contains more than one ADD COLUMN clause. Other unpredictable results, such as storage overlays, may occur. The error is due to insufficient storage allocated for an internal control block.
Problem conclusion
Sufficient storage has been allocated for the internal control block to prevent the reported problem when adding multiple columns in one ALTER TABLE statement. ADDITIONAL KEYWORD: SQLALTER DB2OVRLAY/K SMCOVERLAY
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM75154
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2012-10-16
Closed date
2013-01-03
Last modified date
2013-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK90722
Modules/Macros
DSNXIATB
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK90722
UP13/01/19 P F301
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 February 2013