LOCKSIZE ANY problem

Products

• RC Compare for DB2 for z/OS

Issue/Introduction

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?

Environment

z/od DB2

Resolution

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.