Re: Which Index in which Dbspace?

Hi All If you have already the name of database and the table name, is enough to you run 'dbschema -d database -t tablename -ss' and you'll see the dbspace of indexes (in dbspace.....). If 'in dbspace' doesn't appears, you can assume that the indexes is in the same dbspace as the table. If you don't know the name of table, you can use the sql statement: select tabname,dbinfo("dbspace",partnum) dbspace fromsystabnames where dbsname = "<databasename>" and tabname = "<indexname>" order by 2; Regards. R. Ferronato Bill Dare <dareb@jevic.com> wrote in message news:<c41q16$ds6$1@terabinaries.xmission.com>... > select t.tabname,d.name from sysdbspaces d, systabnames t ,sysptntab p where> t.tabname = "foshm_ev_01" and t.partnum = p.partnum and > trunc((hex(p.partnum)/1048576)) = d.dbsnum > > run against sysmaster > > Regards, > Bill > > > > -----Original Message----- > > From: Five Cats [SMTP:cats_spam@ace.iiug.org] > > Sent: Friday, March 26, 2004 10:13 AM > > To: informix-list@iiug.org > > Subject: Which Index in which Dbspace? > > > > > > Using IDS V7.3x. > > > > We need to find out which indexes are in which dbspace so we can provide > > the correct arguments for 'onload' (don't ask - using it was a bad idea > > but we can't take the live away from the users to do dbexport). > > > > However a quick look at the 'sysindexes' table isn't helpful. > > > > Does someone out there have an SQL that would help, please? I realise > > there might be stuff out there that uses various tools, but unless > > that's restricted to basic stuff (e.g. no Perl for one thing) we can't > > use it. It's not my machine to go trying to install Perl and so on, > > hence wanting an SQL solution. > > > > > > -- > > Five Cats > > Email to: cats_spam at uk2 dot net > sending to informix-list