IC71037: SYSPROC.DB2LOAD MAY TRAP WHEN INVOKED SIMULTANEOUSLY BY TWO OR MORE APPLICATIONS.

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 is sysrouted FROM one or more of the following:

  IZ84497

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R970 PSY

     UP