글

DBMS에서 latch, lock의 개념

서비스 운영 2008/11/26 12:53
요즘 우리 부서에서 새로운 DB 서버를 오픈하려고하는데, 성능이 생각보다 안나오고 OS와 DBMS 상호간 뭔가가 맞지를 않는지 전혀 예상하지 못한 동작을 하는 db2 덕분에 거의 매일 같이 야근을 하고 있다. 그러던 중에 이야기가 나온 녀석이 바로 latch라는 녀석이다.

???????:[/home/btinst1]db2pd -db sfmidb -latches
Option -latches is an instance scope option.  The database option has been ignored.
Database Partition 0 -- Active -- Up 2 days 01:52:45
Latches:
Address            Holder     Waiter     Filename             LOC        LatchType          
0xC0000001005413C0 20650      0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEC703FC0 20666      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70E0DC0 20670      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FED88A3C0 20676      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE934C098 20677      0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE934C100 20677      0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FEF8B47C0 20683      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE93434D8 20693      0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE933FE00 20693      0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FE9392118 20694      0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE938FC80 20694      0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FEFD9F9C0 20695      0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70B35C0 21354      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC00000010C69D6B0 21354      20650      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      20657      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      20670      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      20671      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      20683      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      21099      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      21108      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      21158      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      22055      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      27569      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      27599      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      27927      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      28150      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      2723       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      4240       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      4397       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      4401       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      4625       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      8242       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      8252       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      8592       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      8655       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 21354      17512      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 327        SQLO_LT_SQLP_LHSH__hshlatch
0xC000001FE9392118 27564      0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE938FC80 27564      0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FEC6F51C0 27599      0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE933FC98 27600      0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE933FD00 27600      0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FE934C098 27661      0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE934C100 27661      0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FEFDDCDC0 27871      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEFDC8BC0 27906      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70BC1C0 27941      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE9342118 27942      0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE933FD80 27942      0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FED86ABC0 28150      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEC7405C0 2722       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70D2DC0 2723       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC0000001005069C0 3038       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF71101C0 3099       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEF8B2BC0 3305       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEF8693C0 4169       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC00000010C69D6B0 4169       20650      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       20657      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       20670      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       20671      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       20683      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       21099      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       21108      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       21158      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       22055      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       27569      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       27599      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       27927      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       28150      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       2723       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       4240       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       4397       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       4401       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       4625       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       8242       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       8252       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       8592       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       8655       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 4169       17512      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC000001FF70C69C0 4208       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEFDA69C0 4223       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70D1FC0 4248       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70F41C0 4278       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEF85CFC0 4284       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70E6FC0 4327       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE938CC18 4401       0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE938CC80 4401       0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC00000117F4CC4D8 4403       0          sqlbrcont.C          2665       SQLO_LT_SQLB_POOL_CB__readLatch
0xC0000013717AF9E0 4403       0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FED89ADC0 4504       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF7102FC0 4589       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEF87ABC0 4622       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70DABC0 4626       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE938A498 4704       0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE937FEC0 4704       0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FE9392118 8224       0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE938FC80 8224       0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FED8AA9C0 8240       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF70E45C0 8242       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FED885DC0 8262       0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEFDD6BC0 8575       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEC0409D8 8575       0          sqldmopn.C           1545       SQLO_LT_SQLD_TCB__tcbIndexLatch
0xC000001FED8A9BC0 8592       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF7103DC0 8601       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC00000010C69D6B0 8601       20650      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       20657      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       20670      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       20671      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       20683      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       21099      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       21108      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       21158      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       22055      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       27569      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       27599      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       27927      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       28150      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       2723       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       4240       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       4397       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       4401       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       4625       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       8242       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       8252       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       8592       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       8655       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC00000010C69D6B0 8601       17512      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlpl.h 293        SQLO_LT_SQLP_LHSH__hshlatch
0xC000001FEFD997C0 8655       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE9392118 8680       0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE938FC80 8680       0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FF70D8FC0 8684       0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE9356358 9099       0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE93563C0 9099       0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC000001FEFDD87C0 16526      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEFDD95C0 16579      0          sqlplrq.C            2703       SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FF711A9C0 16715      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FEC71D5C0 16737      0          sqlplrl.C            143        SQLO_LT_SQLP_LTRN_CHAIN__entry_latch
0xC000001FE9392118 16914      0          sqlbpacc.C           1454       SQLO_LT_SQLB_POOL_CB__readLatch
0xC000001FE938FC80 16914      0          sqlbilatch.C         1387       SQLO_LT_SQLB_POOL_MAP_CB__range_latch
0xC0000000411BC030 16930      0          sqlmacb.C            355        SQLO_LT_sqlmon_conn__rds_latch
0xC000001FEC5AA2A8 16930      0          sqlra_dyn.C          3283       SQLO_LT_sqlra_cached_stmt__latch
0xC00000031607B280 16961      20649      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      20674      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      20677      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      21143      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      21160      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      27502      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      27833      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      27871      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      27906      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      27941      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      28245      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      2722       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      3305       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      4108       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      4187       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      4208       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      4219       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      4504       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      4623       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      4626       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      4869       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      8240       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      8584       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      8654       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      8684       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      8707       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      8805       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      16530      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      16703      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      16715      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      16875      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      16911      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      16930      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC00000031607B280 16961      16960      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
Latch Waiters With No Holders:
Address            Holder     Waiter     Filename             LOC        LatchType          
0xC000000315EE9300 0          8620       /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch
0xC000000317038980 0          16513      /wsdb/db2_v91fp4/hpipf64nocc/special_20185/engn/include/sqlbslat.h 711        SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch

도대체 이 녀석이 무엇을 하는 녀석이란 말인가? 위키피디아에는 latch를 찾으면 이와는 전혀 무관할 것 같은 항목만 보이고... 그러던 중에 던져진 글!!! ㅎㅎ

출처) http://kldp.org/node/68437

크리에이티브 커먼즈 라이선스
Creative Commons License
, ,

설정

TRACKBACK : 0 , COMMENT : 0

트랙백

댓글

1 ... 322 323 324 325 326 327 328 329 330 ... 1287
지역로그| 태그| 미디어로그| 방명록| 관리자| 쓰기
박영창's Blog is powered by Daum & Tattertools / Designed by Tistory