Obtaining a list of databases within an instance using only the CLI commands

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Byrocat - 31 Jan 2005 15:34 GMT

These particular servers do not have the DAS enabled, so I have to
document the contents of the instances, initially "instance X contains
n databases (A, B, C< ....)")

I can get get list of isntances on a server by using the db2ilist
command.

What's the sequence of commands needed to pull up a list of the
dataqbases inside an isntance.

"Connect to" is obvious, but what's the command to list databases
within an instance?

Reply to this Message

Pierre Saint-Jacques - 31 Jan 2005 19:31 GMT

Easiest would be:
set db2instance=inst1name
db2 list db directory > inst1dbs.txt
set db2instance=inst2name
db2 list ... and so on
HTH, Pierre.

> These particular servers do not have the DAS enabled, so I have to
> document the contents of the instances, initially "instance X contains
[quoted text clipped - 8 lines]
> "Connect to" is obvious, but what's the command to list databases
> within an instance?

Signature

Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Reply to this Message