DB2 FOR LUW / DB2FORLUW / 970 - DB2

From Application Snapshot: 
Application handle                         = 131133 
Client login ID                            = db2inst1 
Configuration NNAME of client              = prddw3 
Process ID of client application           = 13320 
Coordinator agent process or thread ID     = 25 
Most recent operation                      = Execute Immediate 
Dynamic SQL statement text: 
ALTER TABLESPACE TEMPSPACE2 SWITCH ONLINE 
 
  Subsection status                                  = Executing 
  Execution elapsed time (seconds)                   = 43909 
Agent process/thread ID                    = 233 
 
From Stack: 
 ====================== 
? 
0x00002AAAAC553BC7 
_Z30sqlbTrackMultipleModificationsP20SQLB_DIRECT_WRITE_CB + 
0x00ab 
  0x00002AAAAB8A7020 
_Z35sqlbCheckTrackMultipleModificationsP20SQLB_DIRECT_WRITE_CB + 
0x0058 
  0x00002AAAAC579D6E 
_Z18sqlbDMSDirectWriteP20SQLB_DIRECT_WRITE_CB + 0x01d8 
  0x00002AAAAB8BE28C 
_Z18sqlbInitPoolHeaderP12SQLB_GLOBALSP12SQLB_POOL_CB + 0x0160 
  0x00002AAAAC58C232 
_Z15sqlbDMSInitPoolP12SQLB_GLOBALSP12SQLB_POOL_CB + 0x01fc 
  0x00002AAAAB8BDBCA 
_Z16sqlbDMSStartPoolP12SQLB_GLOBALSP12SQLB_POOL_CB + 0x05ea 
  0x00002AAAAC574580 
_Z26sqlbSwitchTablespaceOnlinetP12SQLB_GLOBALS + 0x00aa 
  ? 
 Summary: 
 Found in 6 stacks of a total of 743 stacks in 251 files 
 Found in: 
  ./13999.233.002.stack.txt -- db2agntp(TIS_STGP) -- 
2015-03-04-10.55.17.599303(Signal #10) 
  ./13999.233.002.stack.txt -- db2agntp(TIS_STGP) -- 
2015-03-04-10.57.18.680600(Signal #10) 
  ./13999.233.002.stack.txt -- db2agntp(TIS_STGP) -- 
2015-03-04-11.01.43.761363(Signal #12) 
 
Latch: 
<LatchInformation> 
Waiting on latch type: (SQLO_LT_SQLB_POOL_CB__readLatch) - 
Address: (0x2aab833ccc90), Line: 4032, File: sqlbpacc.C 
 
Holding Latch type: (SQLO_LT_SQLB_POOL_CB__readLatch) - Address: 
(0x2aab833ccc90), Line: 2139, File: 
/view/db2_v97fp9_linuxamd64_s131204/vbs/engn/include/sqlbistorag 
e_inlines.h HoldCount: 1 
Holding Latch type: (SQLO_LT_SQLB_POOL_CB__writeLatch) - 
Address: (0x2aab833ccca0), Line: 2158, File: 
/view/db2_v97fp9_linuxamd64_s131204/vbs/engn/include/sqlbistorag 
e_inlines.h HoldCount: 1 
</LatchInformation> 
 
These shows that the edu with thread id 233 handling the ALTER 
TABLESPACE SWITCH ONLINE statement is having self dead latch. It 
seems it has no knowledge that the latch was already obtained 
previously, and continues waiting for it.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL USERS                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to latest fix pack.                                  * 
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.03.2015
08.10.2015
08.10.2015