Hi All,

I am facing lot of Locking problems in my database. And everybody started about the solw insert and updates or select on it. I took a snapshot for locks and it follows as

Application handle = 166
Application ID = 0A0B0A49.F084.020823202752
Sequence number = 0001
Application name = java
Authorization ID = WLSCAT
Application status = UOW Executing
Status change time = 08-23-2002 20:52:25.689876
Application code page = 819
Locks held = 9
Total wait time (ms) = 0

List Of Locks
Lock Object Name = 278800
Node number lock is held at = 0
Object Type = Row
Tablespace Name = HVE012TS
Table Schema = UDBADM
Table Name = TRANS
Mode = NS
Status = Granted
Lock Escalation = NO

Lock Object Name = 421894
Node number lock is held at = 0
Object Type = Row
Tablespace Name = HVE010TS
Table Schema = UDBADM
Table Name = RSLT_ADDR
Mode = NS
Status = Granted
Lock Escalation = NO

Lock Object Name = 5
Node number lock is held at = 0
Object Type = Table
Tablespace Name = HVE012TS
Table Schema = UDBADM
Table Name = TRANS
Mode = IS
Status = Granted
Lock Escalation = NO

Lock Object Name = 10
Node number lock is held at = 0
Object Type = Table
Tablespace Name = HVE010TS
Table Schema = UDBADM
Table Name = RSLT_ADDR
Mode = IS
Status = Granted
Lock Escalation = NO

Lock Object Name = 14
Node number lock is held at = 0
Object Type = Table
Tablespace Name = HVE010TS
Table Schema = UDBADM
Table Name = USER_PROF
Mode = IS
Status = Granted
Lock Escalation = NO

Lock Object Name = 0
Node number lock is held at = 0
Object Type = Internal V Lock
Tablespace Name =
Table Schema =
Table Name =
Mode = S
Status = Granted
Lock Escalation = NO

Lock Object Name = 0
Node number lock is held at = 0
Object Type = Internal P Lock
Tablespace Name =
Table Schema =
Table Name =
Mode = S
Status = Granted
Lock Escalation = NO


Can anybody tell me what is internal V lock and P lock ? And how to escalate the locks like NS and IS.

Suggestions will be appreciated.

Thanks

Hari Gosangi.