Hi

I have several databases within the one instance on AIX 5.2.
Is there a simple way of 'mapping' each database against its relevant path?

e.g. I have 7 databases in SQL00001-SQL00007. Only three of these are active... when I run the following command, only the active ones are listed, but I wish to get this sort of info for ALL databases.

$ db2 get snapshot for all databases | egrep "Database name|Database path"
Database name = ABCDEFG
Database path = /home/db2inst1/db2inst1/NODE0000/SQL00007/

Database name = QWERTY
Database path = /home/db2inst1/db2inst1/NODE0000/SQL00001/

Database name = ASDASDF
Database path = /home/db2inst1/db2inst1/NODE0000/SQL00005/


Any ideas? Maybe it's not possible

Thanks,
Brian.

db2 list db directory on /home/db2inst1

Perfect! Thanks Sathyaram - great website both here and db2click.com.
I'm new to DB2 - 10 years of Oracle - but myself and my colleagues find your sites and feedback to be excellent.

Regards,
Brian.