Database Lock Snapshot
Database name = DVDBSE
Database path = F:\DB2\NODE0000\SQL00002\
Input database alias = DVDBSE
Locks held = 4
Applications currently connected = 12
Agents currently waiting on locks = 0
Snapshot timestamp = 10/19/2004
12:24:36.629286
Application handle = 382
Application ID = *LOCAL.DB2.041019172404
Sequence number = 0001
Application name = DB2HMON
Application status = Compiling
Status change time = 10/19/2004
12:23:34.032541
Application code page = 1252
Locks held = 4
Total wait time (ms) = 0
List Of Locks
Lock Name = 0x5359534C48323032B4B76E9441
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 = 0x01000000010000000100180056
Lock Attributes = 0x00000000
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 0
Object Type = Internal Variation Lock
Mode = S
Lock Name = 0x5359535348323030DDECEF2841
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 = 0x53514C4445464C5428DD630641
Lock Attributes = 0x00000000
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 0
Object Type = Internal Plan Lock
Mode = S
t again,
MM
Dany <dany...@videotron.ca> wrote in message news:<clg7u0$b1...@news1.stadia.fi>...