DB2 SYSTEM SCHEMA

1.SYSCAT

TABLES;COLUMNS;INDEXES;FUNCTIONS;PROCEDURES;

2.SYSIBMADMIN--Retrieve information about locks held

LOCKS_HELD()

3.SYSIBM.

VIEWS('TEXT' COLUMN  MEANS THE DEFINATION OF THE VIEW.)