Hi Colleagues,

Somebody can say me how to look the lock level in a table db2.


Thank you for advanced.

What DB2 version and OS are you using?

Andy

Hi,
I am using DB2 Version 9.5 and OS AIX 6

Thank you for advanced.

Look here: IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Andy

Hi,

I need to look if the lock level in the table is row or table, if you can give me an example is welcome.
Than yuo for advanced.

Maybe you want what is in syscat.tables.locksize

Andy

you can get the lock level info from the lock snapshot "db2 get snapshot for locks on DB_NAME".

From the snapshot look out for something like the following ( based on whether you are in V8 or V9).

Lock object type = Row
Lock mode = Exclusive Lock (X)
Lock mode requested = Next Key Share (NS)
Name of tablespace holding lock = USERSPACE1
Schema of table holding lock = DB2(R)
Name of table holding lock = STAFF
------
Lock Name = 0x00020026000000000000000054
Lock Attributes = 0x00000000
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = XXXX1
Table Name = SIXXXX1
Mode = S