Hi friends
just help in this case that how to identify all the running databases for single informix server.

what i did was :
i connected to sysmaster, then queried this table to get info, but
i am getting only this info.

$dbaccess - -
>connect to 'db_name';
Connected
>select * from sysdatabases;
it dispalaces

sysmaster
system
sysutilities

my question is:
how to identify all the databases running here.

Appreciate your help.

Thanks
Sundar

Hi Sundar,

Querying the table sysdatabases in the sysmaster database will give back all databases in this instance. So probably in this instance only the default empty databses were created.

So it looks like everyrthing is OK, but out of your post it looks like you expected more databases. It looks like there aren't!

Greetz,

Rob