Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    24

    Unanswered: how to identify all the running database

    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

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •