Fixes are available
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as fixed if next.
Error description
The SYSPROC.DB2LOAD stored procedure may trap if it is invoked simultaneously by two or more applications. The procedure was not thread-safe in the new v95 threaded engine architecture. The stack of the trap files would usually show a clp routine at the top of the stack, like so: <StackTrace> sqloCrashOnCriticalMemoryValidationFailure sqlofmblkEx clpprs clp_parse clpParseLoad sqluParseAndExecuteLoad db2load sqloInvokeFnArgs or <Stack Trace> sqloCrashOnCriticalMemoryValidationFailure sqlofmblkEx clpPostLoadFreeDynMem sqluParseAndExecuteLoad db2load sqloInvokeFnArgs This APAR fixes the this thread-safety issue.
Local fix
Avoid multiple invocations of sysproc.db2load at the same time.
Problem summary
**************************************************************** * USERS AFFECTED: * * SYSPROC.DB2LOAD MAY TRAP WHEN INVOKED SIMULTANEOUSLY BY TWO * * OR * * MORE APPLICATIONS. * **************************************************************** * PROBLEM DESCRIPTION: * * The SYSPROC.DB2LOAD stored procedure may trap if it is * * invoked simultaneously by two or more applications. The * * procedure was not thread-safe in the new v95 threaded engine * * architecture * **************************************************************** * RECOMMENDATION: * * Upgrade to V97 FP4 * ****************************************************************
Problem conclusion
First Fixed in DB2 Version 9.7 Fix Pack 4
Temporary fix
Comments
APAR Information
APAR number
IC71037
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
970
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-09-08
Closed date
2010-11-01
Last modified date
2011-04-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R970 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]
Document Information
Modified date:
17 September 2021