how can we get all the existing identity and sequences in a database in DB2. we can use 2 different queries to find each one. Please help.

have you tried UNION?

SELECT TABNAME, COLNAME FROM SYSCAT.COLUMNS WHERE IDENTITY = 'Y'

The above query gives all the table name and column name which has column as identity..
Any way thanks for ur consideration..

yes it does. Your other query gets the sequences I take it from your original mail. You want to run one query that gets them both at once and as I said try UNION

select cols from table1 where ....
UNION
select cols from table2 where...

Just ensure the columns match up with data type between the two queries.
Dave