Fw: Which sys catalog table stores the DBspace?

["Vasyl Shulzhenko" <vasilis@softline.kiev.ua>]

----- Original Message -----
From: Art S. Kagel <kagel@bloomberg.net>
Newsgroups: comp.databases.informix
To: <sleesingchan@my-deja.com>
Sent: 30 ЛЮЪ 2000 Ц. 21:45
Subject: Re: Which sys catalog table stores the DBspace?


> The high order three HEX digits of the partnum column of systables (or if
> a fragmented tables partn of the sysfragments records) converted to hex
> contains the dbspace number in hex.  You can look that up on the onstat -d
> report or in the view: sysmaster:sysdbspaces.  For fragmented tables,
> though, the sysfragments records do record the dbspacename.
>
> So:
>
> SELECT tabname, 0, name
> FROM systables t, sysmaster:dbspaces d
> WHERE d.dbsnum = (t.partnum / 0x100000)
>   AND t.partnum > 0
>
> UNION
>
> SELECT tabname, evalpos, dbspace
> FROM systables t, sysfragments f
> WHERE t.tabid = f.tabid;
>
>
> Art S. Kagel
>
> sleesingchan@my-deja.com wrote:
> >
> > Hi,
> >
> > This will probably be a no brainer for some of you,
> > but where does Informix keep the DBSPACE name used to
> > store a particular table?
> >
> > I checked in all of the "sys" tables but came up with
> > nothing.
> >
> > We're using IDS 7.31 on Digital Unix 4.0D.
> >
> > Thanks,
> > Samuel.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.