Table LOCKSIZE display
When a Table lock occurred, if the Tablespace is defined with LOCKSIZE ANY,
the request shows the Tablespace name as locked resource instead of the Table name.
When the Tablespace is defined with LOCKSIZE PAGE or ROW or TABLE the correct Table
name is showed as resource.
Why is this?
In DB2
If you set the LOCKSIZE to TABLE, DB2 takes a table level lock and therefore the locked resource is a table,
When you set it to ANY, DB2 sets the entire tablespace lock and therefore the locked resource is the
tablespace/pageset.