RE: Which Index in which Dbspace?

select t.tabname,d.name from sysdbspaces d, systabnames t ,sysptntab p wheret.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