Which sys catalog table stores the DBspace?

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.

sysmaster:sysdbspaces 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.

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.