Oninit cdi / Archive
Talk to an expert →

Re: Tablespace size

Posted in 2009

Topics: Server Administration

Vagner — — source: Usenet: comp.databases.informix

On Feb 20, 7:24 am, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Obnoxio The Clown" <obno...@serendipita.com> wrote in messagenews:mailman.290.1235123545.1831.informix-list@iiug.org... > > > Neil Truby wrote: > >> Does the 16g page tabelspace maxiumum still apply in IDS 11 please? > > > Yes. > > Thanks for the reply. > > That's quite a disappointment. > > I imagine that this is quite a fundamental thing to address, or it would > have been already, but I think Informix Development is going to have to > Grasp the Nettle on this.  I find it becoming an increasingly important > factor in physical database design and administration.  Sure, you can > fragment around it, but this doesn't chime well with IBM's messaging about > Informix ("Set it and Forget it", etc) ... The limit is 16,775,134 pages per fragment, for tablespace with 2K page the limit is 32GB, for tablespace witk 8K page the limit is 128GB, is it enought?

↪ replying to Vagner
Captain Pedantic — — source: Usenet: comp.databases.informix

"Vagner" <vagnerpontes@ig.com.br> wrote in message news:1dc4ad00-98d1-4521-a5a5-7c96297323e7@m40g2000yqh.googlegroups.com... On Feb 20, 7:24 am, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Obnoxio The Clown" <obno...@serendipita.com> wrote in > messagenews:mailman.290.1235123545.1831.informix-list@iiug.org... > > > Neil Truby wrote: > >> Does the 16g page tabelspace maxiumum still apply in IDS 11 please? > > > Yes. > > Thanks for the reply. > > That's quite a disappointment. > > I imagine that this is quite a fundamental thing to address, or it would > have been already, but I think Informix Development is going to have to > Grasp the Nettle on this. I find it becoming an increasingly important > factor in physical database design and administration. Sure, you can > fragment around it, but this doesn't chime well with IBM's messaging about > Informix ("Set it and Forget it", etc) ... >> The limit is 16,775,134 pages per fragment, for tablespace with 2K page the limit is 32GB, for tablespace witk 8K page the limit is 128GB, is it enought? Well no, obviously it isn't, or he wouldn't have started the thread!

Glossary