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/