Oninit cdi / Archive
Talk to an expert →

Re: Table in the wrong place

Posted in 1999

Topics: Storage & Space Management, Server Administration

Willem Roos — — source: Informix-list mailing list archive (1991-1998)

I'm replying to my own post - sorry to waste your bandwidth with such stupidity - those were indexes in the other dbspace. The 4 times = 4 indexes. Gmpf. Willem Roos wrote: > > Hi everyone, > > I have run out of raw space and as a short term fix i've added 2 > dbspaces on a cooked file system. Now when i round robin my table in > those two spaces it seems to create an extent in each of them and > another in the database's "root" dbspace. When i do > Table->Info->Fragments in dbaccess it shows the two dbspaces but also > the database's "root" - 4 times. Is this a feature on 7.22.UC2? > > TIA > > -- > /* ----------------------------------------------------- * > * Willem Roos wroos@shoprite.co.za * > * roosj@mweb.co.za * > * 0(+27)21 980 4941 * > * 0(+27)21 919 0198 * > * ----------------------------------------------------- */ -- /* ----------------------------------------------------- * * Willem Roos wroos@shoprite.co.za * * roosj@mweb.co.za * * 0(+27)21 980 4941 * * 0(+27)21 919 0198 * * ----------------------------------------------------- */

↪ replying to Willem Roos
Sean Kelsey — — source: Informix-list mailing list archive (1991-1998)

Doh !!! Sean :-) Willem Roos wrote in message <7b0qha$p43$1@news.xmission.com>... > >I'm replying to my own post - sorry to waste your bandwidth with such >stupidity - those were indexes in the other dbspace. The 4 times = 4 >indexes. Gmpf. > >Willem Roos wrote: >> >> Hi everyone, >> >> I have run out of raw space and as a short term fix i've added 2 >> dbspaces on a cooked file system. Now when i round robin my table in >> those two spaces it seems to create an extent in each of them and >> another in the database's "root" dbspace. When i do >> Table->Info->Fragments in dbaccess it shows the two dbspaces but also >> the database's "root" - 4 times. Is this a feature on 7.22.UC2? >> >> TIA >> >> -- >> /* ----------------------------------------------------- * >> * Willem Roos wroos@shoprite.co.za * >> * roosj@mweb.co.za * >> * 0(+27)21 980 4941 * >> * 0(+27)21 919 0198 * >> * ----------------------------------------------------- */ > >-- >/* ----------------------------------------------------- * > * Willem Roos wroos@shoprite.co.za * > * roosj@mweb.co.za * > * 0(+27)21 980 4941 * > * 0(+27)21 919 0198 * > * ----------------------------------------------------- */

↪ replying to Willem Roos
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Willem Roos wrote: > > I'm replying to my own post - sorry to waste your bandwidth with such > stupidity - those were indexes in the other dbspace. The 4 times = 4 > indexes. Gmpf. Willem, unless you specifically placed the indexes in root this result would tend to indicate that the database itself was created in the rootdbs which is not a good thing. FWIW. Art S. Kagel

Glossary