IT34378: SERVER CRASH IN DB2 SQLEHDIR FUNCTION

8.1.12.000-IBM-SPSRV-WindowsX64
8.1.12.000-IBM-SPSRV-Linuxx86_64
8.1.12.000-IBM-SPSRV-Linuxs390x
8.1.12.000-IBM-SPSRV-Linuxppc64le
8.1.12.000-IBM-SPSRV-AIX
8.1.10.200-IBM-SPSRV-WindowsX64
8.1.10.200-IBM-SPSRV-Linuxx86_64
8.1.10.200-IBM-SPSRV-Linuxs390x
8.1.10.200-IBM-SPSRV-Linuxppc64le
8.1.10.200-IBM-SPSRV-AIX
8.1.10.200-IBM-SPOC-WindowsX64
8.1.10.200-IBM-SPOC-Linuxx86_64
8.1.10.200-IBM-SPOC-Linuxs390x
8.1.10.200-IBM-SPOC-LinuxPPC64le
8.1.10.200-IBM-SPOC-AIX
IBM Spectrum Protect Server V8.1.10.X interim fix downloads
IBM Spectrum Protect Server V8.1.11.X interim fix downloads
IBM Spectrum Protect Server V8.1 Fix Pack 12 (V8.1.12) Downloads

APAR status

• Closed as program error.

Error description

• The Spectrum Protect server crashes in the DB2 function
  sqlehdir.  This is DB2 APAR:
  IT33294: CRASH SIGNAL#11 SQLEHDIR__FP8SQLE_BWA IN DB2 V11.1.4.5
  
  Customer/L2 Diagnostics (if applicable)
  
  /var/log/messages shows dsmserv has a signal 11 abort:
  
  Aug 18 22:20:41 dc1nlptsm001 kernel: dsmserv[27829]: unhandled
  signal 11 at 0000000000000788 nip 00003fffb5d20794 lr
  00003fffb5d216bc code 30001
  Aug 18 22:20:41 dc1nlptsm001 abrt-hook-ccpp: Process 23033
  (dsmserv) of user 2222 killed by SIGSEGV - dumping core
  
  The Spectrum Protect Activity Log has no error messages prior
  to the crash.
  
  getcoreinfo.txt shows the signal 11 segmenation fault in the
  sqlehdir function
  
  Core was generated by `/opt/tivoli/tsm/server/bin/dsmserv -i
  /home/dc1tsm02 -q '.
  Program terminated with signal 11, Segmentation fault.
  #0  0x00003fffb5d20794 in sqlehdir(SQLE_BWA*) () from
  /home/dc1tsm02/sqllib/lib64/libdb2.so.1
  ================================================================
  =========
  #0  0x00003fffb5d20794 in sqlehdir(SQLE_BWA*) () from
  /home/dc1tsm02/sqllib/lib64/libdb2.so.1
  #1  0x00003fffb5dc1260 in sqleuGetCatalogInfo () from
  /home/dc1tsm02/sqllib/lib64/libdb2.so.1
  #2  0x00003fffb52e2c58 in SQLDriverConnect2(CLI_CONNECTINFO*,
  void*, unsigned char*, short, unsigned char*, short, short*,
  unsigned short, unsigned char, unsigned char,
  CLI_ERRORHEADERINFO*) () from
  /home/dc1tsm02/sqllib/lib64/libdb2.so.1
  #3  0x00003fffb52dde64 in SQLConnect1(CLI_CONNECTINFO*,
  unsignedchar*, short, unsigned char*, short, unsigned char*, s
  hort) () from /home/dc1tsm02/sqllib/lib64/libdb2.so.1
  #4  0x00003fffb52dd024 in SQLConnect () from
  /home/dc1tsm02/sqllib/lib64/libdb2.so.1
  #5  0x00000000109c4b90 in RdbCreateConnection
  (inPoolP=0x11c2aed0, inNewConnP=0x3fff6f99dad0,
  CreateConnectionWhileHalting=False, userName=0x0) at
  dbiconn.c:1927
  #6  0x00000000109c651c in DbiGetConnectionTracked
  (file=<optimized out>, line=<optimized out>, type=<optimized
  out>, connPP=0x3fff6f99dad0,
  GetConnectionWhileHalting=<optimized out>, userName=<optimized
  out>) at dbiconn.c:591
  #7&#160;&#160;0x00000000109cbe18 in AllocTxnDesc (txnId=0x3ffbc406b250)
  atdbitxn.c:16
  99
  #8&#160;&#160;DbiParticipate (txnId=0x3ffbc406b250) at dbitxn.c:1563
  #9&#160;&#160;0x00000000109e4eec in tbOpenX (txnId=<optimized out>,
  tblName=<optimized out>, tempName=<optimized out>,
  isTempReopen=<optimized out>, handle=<optimized out>) at
  tbtbl.c:5479
  #10 0x0000000010b4b1c0 in SdGetReuseDelayEx
  (txnP=0x3ffe5c0c7020, poolId=<optimized out>, reuseDelayP=0x0)
  at sddedup.c:1950
  #11 0x0000000010b4b9c0 in sdFindChunkInPool
  (txnId=0x3ffbc406b250, poolId=<optimized out>, digest=...,
  chunkSize=<optimized out>, foundChunkIdP=0x3fff6f99e300,
  foundChunkFlagsP=0x3fff6f99e334, sdWriteCntrlP=0x3ffe5c178000)
  at sddedup.c:1641
  #12 0x0000000010b8d364 in CheckInFlightChunks
  (workP=0x3ffe5c0e45f0) at sdio.c:4870
  #13 SdAsyncWrite (containerWorkP=0x3ffe5c0e45f0) at sdio.c:3371
  #14 0x0000000010ba4ae0 in AsyncWriteThread (arg1P=<optimized
  out>, arg2P=<optimized out>) at sdprodcon.c:5121
  #15 0x0000000010ff6010 in PcConsumerThread
  (argP=0x3fff70001388)a
  t prodcons.c:693
  #16 0x0000000010ba1ef4 in AsyncWriteStackEntry (argP=<optimized
  out>) at sdprodcon.c:6038
  #17 0x00000000110ad010 in StartThread (startInfoP=<optimized
  out>) at pkthread.c:4106
  #18 0x00003fffb7e08cd4 in start_thread () from
  /lib64/libpthread.so.0
  #19 0x00003fffb4c27e94 in clone () from /lib64/libc.so.6
  
  Platforms affected:
  Unix Linux Windows - All 8.1.0.0 to 8.1.10.x
  
  
  Initial Impact: Medium
  
  Additional Keywords: crash core TSM Tivoli Storage Manager
  TS004080459  abend
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in levels 8.1.10.200, 8.1.11.100 and   *
  * 8.1.12. Note that this is subject to change at the           *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, Linux, and
  Windows.
  Platforms fixed:  AIX, Linux, and Windows.
  

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:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R81A PSY

     UP

• R81L PSY

     UP

• R81W PSY

     UP