Re: finding a databases dbspace
S
> 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
try this
select name,dbinfo('DBSPACE',partnum)
from sysdbspartn
order by 2;
If U want more info send me mail
BALA PEDDI
Informix consultent
boston
bala.peddi@fmr.com