For example I have created one query to get Primary Key Constraints , like this I need quries for mentioned above containts.
SELECT SUBSTR(A.TBNAME,1,20) AS "TABLE NAME",
SUBSTR(A.COLNAME,1,20) AS "COLUMN NAME",
SUBSTR(A.RELNAME,1,20) AS "RELATION NAME"
FROM SYSIBM.SYSFOREIGNKEYS A, SYSIBM.SYSRELS B
WHERE A.TBNAME= B.REFTBNAME;