Hi all,

I wish to see the list of database names that exists in a connection..
is there any inbuilt function or system tables defining this..

cheers
Sn

You can list all the database names in an instance:

db2 list db directory

This will include all local databases, plus any remote databases that are catalogued.

Shefu,

which platform are you on or connecting to ??

in z/OS you are actually connecting to a subsystem, so the information you are looking for could be selected using

select name from sysibm.sysdatabase

Thanks for the info juliane and marcus,

but mine is loaded in to a Windows 2000.

regards
Sn

db2 "list active databases"

thx,
Jayanta Datta
Delhi NCR