Re: Could Cheetah have saved my Sunday?
Er, I didn't, that would have saved some fannying about with LVs at the OS level. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Data Cruncher" <dcruncher4@aim.com> wrote in message news:f7dps5$npj$1@registered.motzarella.org... > > "Neil Truby" <neil.truby@ardenta.com> wrote in message > news:5fv7r9F3duu6rU1@mid.individual.net... >> I've spent most of today fragmenting a table of 184 million rows which >> has burst the IDS 9/10 limit of 16.7m pages per tablespace. >> >> I was disappointed to see this limit still persists in v10, although it >> wouldn't have helped me anyway as this db is 9.40. Is it removed in v11 > > You do know that in 10 you can fragment a table in > the same dbspace, essentially solving the 16.7 million pages > limit without creating additional dbspaces just to beat that limitation. > So per me, 16.7 million pages limit is history. > > DB2 also had the same problem, but it got solved in ver 9.0 even > without using partition, or so I have been told. >
On 15/07/07, Neil Truby <neil.truby@ardenta.com> wrote: > Er, I didn't, that would have saved some fannying about with LVs at the OS > level. > > -- > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.truby@ardenta.com > > > "Data Cruncher" <dcruncher4@aim.com> wrote in message > news:f7dps5$npj$1@registered.motzarella.org... > > > > "Neil Truby" <neil.truby@ardenta.com> wrote in message > > news:5fv7r9F3duu6rU1@mid.individual.net... > >> I've spent most of today fragmenting a table of 184 million rows which > >> has burst the IDS 9/10 limit of 16.7m pages per tablespace. > >> > >> I was disappointed to see this limit still persists in v10, although it > >> wouldn't have helped me anyway as this db is 9.40. Is it removed in v11 > > > > You do know that in 10 you can fragment a table in > > the same dbspace, essentially solving the 16.7 million pages > > limit without creating additional dbspaces just to beat that limitation. > > So per me, 16.7 million pages limit is history. > > > > DB2 also had the same problem, but it got solved in ver 9.0 even > > without using partition, or so I have been told. > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Neil Not useful for you, but the variable page size per dbspace in v10 can also be a god-send, especially on those OSs (Sun, HPUX, Linux (I think)) that use a 2k page size. Needs a little set up and a bit more memory but sorts this out with an 'inset into new table select * from old, drop old, rename new to old'. Keith