Re: Which Index in which Dbspace?

If they are not detached then they'll be with the tables. Check out systabnames/sysdbspaces in the sysmaster database. There are a number of sites that have the SQL for this, including www.oninit.com/sysmaster Cheers Paul Five Cats wrote: > > 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 -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #