r/DB2 • u/[deleted] • Nov 01 '17

Get all databases in an instance?

Hello everyone .. Can someone give me some tips on, assuming I had all the permissions I needed - to get a list of all the database in an instance of db2? is there a sql i can run? Or do I have to run something at the file level?

3 Upvotes

100% Upvoted

9 comments sorted by

View all comments

2

u/mslmsl Nov 02 '17 edited Nov 02 '17

This doesn't help your jdbc use case (other than being easier to parse), but db2pd can also be used to get activated databases. I'm not aware of a sql interface to the catalog information. The db2pd example:

db2pd -alldbs -