Re: Which Index in which Dbspace?

[cutting] > I notice from running the SQL in the other post on another customers > machine that the detached indexes appear as entities in their own right, > and so long as the customer can spot their indexes by name we will be OK > with those. That's why you use a naming structure:-) >This SQL has ended up as follows: > > select t.tabname,d.name > from sysdbspaces d, systabnames t ,sysptntab p > where t.partnum = p.partnum > and trunc((hex(p.partnum)/1048576)) = d.dbsnum > and d.name != 'database_dbs' > and d.name != 'rootdbs' > and t.tabname != "TBLSpace" > and t.tabname != "system-rowid" > order by name, tabname> > (database_dbs & rootdbs should be obvious!) > > > > >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 > > > > -- > 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 #