Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Posts
    51

    Unanswered: Map databases to dbspaces ---> please help!

    Hi,
    Anyone tell me how to easily make a list of all of the dbspaces used by a database? ANd just in case anyone knows this one, I already tried:

    select b.dbsname, a.name from sysdbspaces a, systabnames b where a.dbsnum= partdbsnum(b.partnum) and b.tabname="systables"

    But it only lists one dbspace for a database that I know has many.

    -thanks
    dnix
    When in doubt just ask your self,
    -WWSBD?-
    (what would Sponge Bob do?)

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Try the following:

    select dbinfo("DBSPACE",partnum) dbspace,
    name database
    from sysdatabases
    order by name, dbspace;

  3. #3
    Join Date
    Sep 2002
    Posts
    51
    I get the same results I got the other way I tried it. I have a database I thought was spread across like 22 dbspaces, but when I run queries like this I only get one dbspace listed...is it possible that the database is in one dbspace and the this database's tables are in seperate dbspaces? I guess I should have prefaced this with the fact that I do not have an informix background and the guy that built or database system is no longer with the company, so if that last dbspace question is a dumb one - please forgive me.
    -d

    Originally posted by rnealejr
    Try the following:

    select dbinfo("DBSPACE",partnum) dbspace,
    name database
    from sysdatabases
    order by name, dbspace;
    When in doubt just ask your self,
    -WWSBD?-
    (what would Sponge Bob do?)

  4. #4
    Join Date
    May 2002
    Location
    Osnabrueck Germany
    Posts
    59
    Hi,

    log in as informix, then try oncheck -pe and onstat -d. That tells you a lot of all your databases.
    Juergen Ladwig

  5. #5
    Join Date
    Oct 2002
    Posts
    6
    If you are wanting to know the default dbspace that a certain database was created in use onmonitor.

Posting Permissions

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