A fix is available
APAR status
Closed as program error.
Error description
An UPDATE AFTER TRIGGER was defined on a table with many columns. This caused the internal length of an SQLDA to be larger than woud fit in a 2-byte length field, resulting in an overlay. SMCOVERLAY Abends were observed in the follow areas: ABEND0C4 RC00000038 DSNB1RTR OFFSET 03B4 OFFSET03B4 ABEND0C4 RC00000010 DSNSVBK OFFSET 0E2A OFFSET0E2A ABEND04E RC00C90101 DSNIWKFD VRACE5001 ERUAL5001 ABEND0C4 RC00000004 DSNIMOFT OFFSET 2DF0 OFFSET2DF0 ABEND0C4 RC00000038 DSNXGRDS DSNXEXAT OFFSET7D8E ABEND04E RC00E20006 DSNIBABR DSNSVBK OFFSET1CDC ABEND0C4 RC00000038 DSNIDM DSNICUBC OFFSET0ECA ABEND04E RC00E20027 DSNITCU DSNSVBK OFFSET0A02 Other symptoms are possible depending on the areas being overlaid. Most common is the CUB control blocks which are allocated near the SQLDA block.
Local fix
DROP THE TRIGGER
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 for z/OS users of AFTER TRIGGERS * * with a large number of transition * * variables. * **************************************************************** * PROBLEM DESCRIPTION: ABEND0C4 RC00000038 at DSNB1RTR+03B4 or * * other ABEND symptoms possible. * **************************************************************** * RECOMMENDATION: * **************************************************************** When an after trigger with a large number of transition variables (greater than 500) is executed, the SQLDA may not have allocated enough storage. During usage of the SQLDA, DB2 may write into storage that was not allocated for this structure resulting in an overlay.
Problem conclusion
DB2 has been modified to acquire the proper amount of storage for the SQLDA. Additional keywords: SQLTRIGGER SMCOVERLAY
Temporary fix
********* * HIPER * ********* AM33480
Comments
APAR Information
APAR number
PM33480
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2011-02-23
Closed date
2011-03-30
Last modified date
2011-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK66506 UK66507 UK66508
Modules/Macros
DSNXEXAT
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK66506
UP11/04/21 P F104
R810 PSY UK66507
UP11/04/21 P F104
R910 PSY UK66508
UP11/04/21 P F104
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":"9.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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 May 2011