I read in the DB2 book that there are row level locking and table level locking exists.
And a developer or admin can also change the level of locking using the
ALTER TABLE [Table-Name] LOCKSIZE [ ROW / TABLE ]
LOCK TABLE [TABLE-NAME] IN [ SHARE / EXCLUSIVE ] MODE
I would like to know the existing level of locking ( ROW / TABLE ] for tables in my application. Please let me know which system catalog table I need to query for ??