所有应用都是UOW waiting，怎么还有锁啊？？ - DB2 & Informix - LoveUnix -- 最强AIX小机技术论坛,UNIX,Linux,存储,数据库,中间件,开发,管理 -- 蓝色的IBM技术天堂 --bbs.LoveUnix.net

hlsz

LU幼天使

UID 32691
精华 1
积分 42
帖子 76
活跃指数 24
LU金币 2172 个
LU金条 0 个
阅读权限 20
注册 2005-6-15

#1

大中小

使用道具

发表于 2007-2-6 11:14 资料个人空间短消息加为好友

所有应用都是UOW waiting，怎么还有锁啊？？

如题所示，用db2 list applications show detail 看，明明所有应用都是UOW waiting ,但用
db2 get snapshot for lock for db on DBNAME还是看到有X行锁和一个IX表锁。想不通啊

beginner-bj

版主

UID 9471
精华 16
积分 1479
帖子 2528
活跃指数 209
LU金币 4824 个
LU金条 0 个
阅读权限 210
注册 2004-1-16

#2

大中小

使用道具

发表于 2007-2-6 11:41 资料个人空间短消息加为好友

贴出来看看

我的博客：http://blog.chinaunix.net/index.php?blogId=739欢迎访问，并请多多批评指正。

hlsz

LU幼天使

UID 32691
精华 1
积分 42
帖子 76
活跃指数 24
LU金币 2172 个
LU金条 0 个
阅读权限 20
注册 2005-6-15

#3

大中小

使用道具

发表于 2007-2-6 14:10 资料个人空间短消息加为好友

Database Lock Snapshot

Database name                            = BEPS
Database path                            = /home/bepsdbdir/db2inst1/NODE0000/SQL00001/
Input database alias                      = BEPS
Locks held                               = 11
Applications currently connected          = 4
Agents currently waiting on locks       = 0
Snapshot timestamp                      = 02/06/2007 10:45:26.598315

Application handle                      = 438
Application ID                            = *LOCAL.db2inst1.070206022212
Sequence number                         = 0019
Application name                         = db2bp
CONNECT Authorization ID                = BEPS
Application status                      = UOW Waiting
Status change time                      = Not Collected
Application code page                   = 1386
Locks held                               = 0
Total wait time (ms)                      = 0

Application handle                      = 126
Application ID                            = *LOCAL.db2inst1.070205085337
Sequence number                         = 0006
Application name                         = hw_svc
CONNECT Authorization ID                = BEPS
Application status                      = UOW Waiting
Status change time                      = Not Collected
Application code page                   = 1386
Locks held                               = 5
Total wait time (ms)                      = 0

List Of Locks
Lock Name                = 0x444246524D424B41A44BF0E641
Lock Attributes          = 0x00000000
Release Flags             = 0x40000000
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 0
Object Type                = Internal Plan Lock
Mode                      = S

Lock Name                = 0x44425350425354410F7459A441
Lock Attributes          = 0x00000000
Release Flags             = 0x40000000
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 0
Object Type                = Internal Plan Lock
Mode                      = S

Lock Name                = 0x00020104009EDE060000000052
Lock Attributes          = 0x00000000
Release Flags             = 0x40000002
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 10411526
Object Type                = Row
Tablespace Name          = USERSPACE1
Table Schema             = BEPS
Table Name                = FRMBKA
Mode                      = X

Lock Name                = 0x46524D424B415F45D4425AF841
Lock Attributes          = 0x00000000
Release Flags             = 0x40000000
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 0
Object Type                = Internal Plan Lock
Mode                      = S

Lock Name                = 0x00020104000000000000000054
Lock Attributes          = 0x00000000
Release Flags             = 0x40000002
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 260
Object Type                = Table
Tablespace Name          = USERSPACE1
Table Schema             = BEPS
Table Name                = FRMBKA
Mode                      = IX

Application handle                      = 1369
Application ID                            = *LOCAL.db2inst1.070205084131
Sequence number                         = 0006
Application name                         = hw_svc
CONNECT Authorization ID                = BEPS
Application status                      = UOW Waiting
Status change time                      = Not Collected
Application code page                   = 1386
Locks held                               = 5
Total wait time (ms)                      = 0

List Of Locks
Lock Name                = 0x444246524D424B41A44BF0E641
Lock Attributes          = 0x00000000
Release Flags             = 0x40000000
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 0
Object Type                = Internal Plan Lock
Mode                      = S

Lock Name                = 0x44425350425354410F7459A441
Lock Attributes          = 0x00000000
Release Flags             = 0x40000000
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 0
Object Type                = Internal Plan Lock
Mode                      = S

Lock Name                = 0x00020104009F8E060000000052
Lock Attributes          = 0x00000000
Release Flags             = 0x40000002
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 10456582
Object Type                = Row
Tablespace Name          = USERSPACE1
Table Schema             = BEPS
Table Name                = FRMBKA
Mode                      = X

Lock Name                = 0x46524D424B415F45D4425AF841
Lock Attributes          = 0x00000000
Release Flags             = 0x40000000
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 0
Object Type                = Internal Plan Lock
Mode                      = S

Lock Name                = 0x00020104000000000000000054
Lock Attributes          = 0x00000000
Release Flags             = 0x40000002
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 260
Object Type                = Table
Tablespace Name          = USERSPACE1
Table Schema             = BEPS
Table Name                = FRMBKA
Mode                      = IX

Application handle                      = 7
Application ID                            = *LOCAL.db2inst1.070205034938
Sequence number                         = 7235
Application name                         = hw_evt
CONNECT Authorization ID                = BEPS
Application status                      = UOW Waiting
Status change time                      = Not Collected
Application code page                   = 1386
Locks held                               = 1
Total wait time (ms)                      = 0

List Of Locks
Lock Name                = 0x4556545F44423220D3ED65B841
Lock Attributes          = 0x00000000
Release Flags             = 0x40000000
Lock Count                = 1
Hold Count                = 0
Lock Object Name          = 0
Object Type                = Internal Plan Lock
Mode                      = S

beps:/home/beps>db2 list applications

Auth Id  Application Appl.    Application Id                DB    # of
      Name          Handle                                  Name Agents
-------- -------------- ---------- ------------------------------ -------- -----
BEPS    db2bp       438       *LOCAL.db2inst1.070206022212 BEPS    1
BEPS    hw_svc       126       *LOCAL.db2inst1.070205085337 BEPS    1
BEPS    hw_svc       1369    *LOCAL.db2inst1.070205084131 BEPS    1
BEPS    hw_evt       7       *LOCAL.db2inst1.070205034938 BEPS    1

beps:/home/beps>db2 list applications show detail

CONNECT Auth Id             Application Name    Appl.    Application Id                Seq# Number of  Coordinating DB  Coordinator    Status                      Status Change Time       DB Name  DB Path
                                                Handle                                        Agents    partition number pid/thread
------------------------------ -------------------- ---------- ------------------------------ ---- ---------- ---------------- --------------- ------------------------------ -------------------------- -------- --------------------
BEPS                         db2bp             438       *LOCAL.db2inst1.070206022212 0019 1       0             827558       UOW Waiting                   Not Collected             BEPS    /home/bepsdbdir/db2inst1/NODE0000/SQL00001/
BEPS                         hw_svc             126       *LOCAL.db2inst1.070205085337 0006 1       0             2093184       UOW Waiting                   Not Collected             BEPS    /home/bepsdbdir/db2inst1/NODE0000/SQL00001/
BEPS                         hw_svc             1369    *LOCAL.db2inst1.070205084131 0006 1       0             2113600       UOW Waiting                   Not Collected             BEPS    /home/bepsdbdir/db2inst1/NODE0000/SQL00001/
BEPS                         hw_evt             7       *LOCAL.db2inst1.070205034938 7238 1       0             2195708       UOW Waiting                   Not Collected             BEPS    /home/bepsdbdir/db2inst1/NODE0000/SQL00001/

hlsz

LU幼天使

UID 32691
精华 1
积分 42
帖子 76
活跃指数 24
LU金币 2172 个
LU金条 0 个
阅读权限 20
注册 2005-6-15

#4

大中小

使用道具

发表于 2007-2-6 14:54 资料个人空间短消息加为好友

是我错了，一直UOW是整个事务呢，看来是得好好学学了

beginner-bj

版主

UID 9471
精华 16
积分 1479
帖子 2528
活跃指数 209
LU金币 4824 个
LU金条 0 个
阅读权限 210
注册 2004-1-16

#5

大中小

使用道具

发表于 2007-2-6 16:55 资料个人空间短消息加为好友

估计126和1369一直没有做commit

我的博客：http://blog.chinaunix.net/index.php?blogId=739欢迎访问，并请多多批评指正。