How to list all the database in DB2?

[Sina]

Hello everyone;

What is the command I can run to list all the database in DB2?

Thank you all

 

[Farab]

select *
from sysibm.sysdatabase
;

 

[thebioman]

Hey there,

Another way is you can do is type "? GET" or "? List" in the command center or the CLP and when you run it you'll be able to see the different options that are available to you.

 

[Shaixpeare]

Hiyas,
Here's the DB2 command: list db directory

Enjoy!