IZ84497: 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.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 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:                                              *
  * Users trying to run sysproc.db2load concurrently.            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The SYSPROC.DB2LOAD stored procedure may trap if it          *
  * isinvoked simultaneously by two or more applications.        *
  * Theprocedure was not thread-safe in the new v95 threaded     *
  * enginearchitecture.                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Avoid multiple invocations of sysproc.db2load at the         *
  * sametime.                                                    *
  ****************************************************************
  

Problem conclusion

• Fix in V95 FP7
  

Temporary fix

Comments

APAR Information

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

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

  IC71037 IC71398

Fix information

Applicable component levels

• R950 PSN

     UP

• R950 PSY

     UP