Map databases to dbspaces ---> please help!

dnix · #1 (**permalink**) 10-21-02, 19:23

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

rnealejr · #2 (**permalink**) 10-22-02, 00:51

Try the following:

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

dnix · #3 (**permalink**) 10-22-02, 08:36

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

Quote:

Originally posted by rnealejr
Try the following:

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