SAP Knowledge Base Article - Preview

2701674 - Database hang during TSM backup with PD_TYPE_SQLO_NLCK lock

Symptom

Database hang after starting a backup with TSM.
The following error is found in the db2diag.log

PID     : <PID>              TID : <TID          PROC : db2sysc
INSTANCE: db2<sid>               NODE : 000           DB   : <SID>
HOSTNAME: <hostname>
EDUID   : <EDUID>                EDUNAME: db2agent (<SID>) 0
FUNCTION: DB2 UDB, oper system services, sqloNLCKGetInstanceWideNamedLock, probe:10
MESSAGE : Semaphore wait timed out and recovery semaphore not detected yet.
DATA #1 : Codepath, 8 bytes
...
DATA #2 : unsigned integer, 8 bytes
...
DATA #3 : unsigned integer, 8 bytes
...
DATA #4 : unsigned integer, 8 bytes
...
DATA #5 : OSS Named Lock, PD_TYPE_SQLO_NLCK, 40 bytes
   Lock Scope        : Instance-wide
   Semaphore Handle  : 780000000D6A8D8
   Resource Slot     : 780000000D6A880
   File Handle       : N/A
   Lock State        : 0x3, (Initialized)
   Used by Engine    : Yes
   Auto Create File  : No
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x090000000D91CD94 sqloNLCKGetInstanceWideNamedLock__FCP16SQLO_NLCK_HANDLECUlCi + 0x554
  [1] 0x090000000D91C640 sqloNLCKLock + 0x2C0
  [2] 0x090000000D915AB4 sqluhLock__FP12SQLUH_HANDLE + 0x1B4
  [3] 0x090000000D917A34 sqluhAllocateHandleVerifyHistoryFilesAndOptToRecover__FPP12SQLUH_HANDLEPCcCbCUlT3PUi + 0xB4
  [4] 0x090000000D91845C sqluhOpen__FPP12SQLUH_HANDLEPCcUlPUib + 0x7C
  [5] 0x090000000D92C450 adminListHist + 0x250
  [6] 0x090000000D92DD14 adminListHistTrusted + 0x414
  [7] 0x090000001885EE8C sqloInvokeFnArgs + 0x592C


Read more...

Environment

Db2 Linux Unix and Windows

Keywords

IBM, tape, history, prune , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.