Re: finding a databases dbspace
s_cawley@litle.net wrote:
>
> Hi,
>
> If I know a database name, how can I find the name of the dbspace it
> lives in? I have been looking through the sysmaster tables looking for an
> answer and cannot find one.
>
> I can find this information using onmonitor, but would like an SQL
> based solution to this problem.
>
> Thanks,
>
> Steve
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Steve,
You can use the dbinfo() function (described on p. 1-690 of the Guide to
SQL:Syntax) to get the dbspace where one of the system catalog tables of
the database in question resides.
Strictly speaking, an entire database doesn't have to (and rarely does,
if you have a non - trivial disk layout) reside in one dbspace. The
dbinfo() command can give you that information on a tblspace by tblspacebasis.
Wes
--
---
Wes Gamble
Senior Consultant - ECS Strategic Applications
Informix Software Inc., Houston, Texas, USA
Phone: 713 626 7282 Fax: 713 626 1252
E-mail: wgamble@informix.com