can someone explain to me what is internal p lock, internal s lock,
internal v lock? when i have IS lock or IX lock , i always have these
internal locks together for the application handle
Application handle = 261
Application ID =
AC100482.GD3A.00F85FE51898
Sequence number = 0006
Application name = db2jccmain
Authorization ID = WCADMIN
Application status = UOW Waiting
Status change time = Not Collected
Application code page = 1208
Locks held = 1
Total wait time (ms) = Not Collected
List Of Locks
Lock Name = 0x5359534C564C303153304E4441
Lock Attributes = 0x00000000
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 0
Object Type = Internal P Lock
Mode = S