Re: Tablespace size

Posted in 2009

Topics: Storage & Space Management, Cloud, Docker & Containers

Neil Truby — Tue, 24 Feb 2009 23:55:41 -0000 — 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... > > 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? Here are the largest tables in a Lawson customer's database: dbsname tabname num_of_extents total_size live txtaxtran 60 15453132 live coline 17 14882316 live apinvoice 31 12622244 live oeinvcline 28 12199439 live aroitems 56 10121879 As you can see, several of these are approaching the 16g page limit, and several even larger tables have already been fragmented.

↪ replying to Neil Truby

John Carlson — Thu, 26 Feb 2009 21:20:01 -0500 — source: Usenet: comp.databases.informix

Neil Truby wrote: > > "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... >> > >> 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? > > Here are the largest tables in a Lawson customer's database: Wow, that's a blast from the past. Didn't know that there were any other Lawson / Informix systems out there . . . > > dbsname tabname num_of_extents total_size > > live txtaxtran 60 15453132 > live coline 17 14882316 > live apinvoice 31 12622244 > live oeinvcline 28 12199439 > live aroitems 56 10121879 > > As you can see, several of these are approaching the 16g page limit, and > several even larger tables have already been fragmented. Can you detach indexes? I don't believe that detached indexes count toward total size, and I know that Lawson has some pretty wide indexes (especially in AP / GL). And Lawson (depending on version) has ways to stuff their dictionary for their "dbreorgs" also, from what I remember. John Carlson