Hi Friends,

How can i list all synonyms and snapshotes which is in DB2 database.

Please tell me querry for that.

Thanks in Advance

I suppose you are asking for the DB2 equivalent of Oracle's SYNONYMS and SNAPSHOTS, right ?

In DB2, SYNONYMS are known as ALIAS an and SNAPSHOTS are kind of a TABLE.
Both of these can be found in the SYSCAT.TABLES catalog view.

Here's a sample query

SELECT TABSCHEMA,
TABNAME,
CASE TYPE
WHEN 'A' THEN 'ALIAS'
WHEN 'S' THEN 'MQT'
END CASE
FROM SYSCAT.TABLES
WHERE TYPE IN ('A', 'S')