How to Change sysdistrib tables extent size?

Posted in 2010

SCHIL ACHE — Wed, 10 Feb 2010 06:20:50 — source: IIUG Forums & Mailing Lists

Hi, How to Change sysdistrib tables extent size during creation of a database or instance itself? FYI.Checked already sysmaster.sql.

↪ replying to SCHIL ACHE

Art Kagel — Wed, 10 Feb 2010 13:25:27 — source: IIUG Forums & Mailing Lists

VERSION INFORMATION!!!! In the latest versions of IDS 11.50 you can set the default extents for the engine in the ONCONFIG file then when you create the database the catalog tables will have larger extents. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Feb 10, 2010 at 1:20 AM, SCHIL ACHE <penfriend5@yahoo.co.uk> wrote: > Hi, > > How to Change sysdistrib tables extent size during creation of a database > or > instance itself? > > FYI.Checked already sysmaster.sql. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174befc4830796047f3ef764

↪ replying to SCHIL ACHE

Clifton Bean — Wed, 10 Feb 2010 13:44:53 — source: IIUG Forums & Mailing Lists

You can change the next exent size anytime, either immediately after the database is created or anytime thereafter. Take care. Clifton > To: ids@iiug.org > From: penfriend5@yahoo.co.uk > Subject: How to Change sysdistrib tables extent size? [18972] > Date: Wed, 10 Feb 2010 01:20:51 -0500 > > Hi, > > How to Change sysdistrib tables extent size during creation of a database or > instance itself? > > FYI.Checked already sysmaster.sql. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/201469227/direct/01/

↪ replying to Clifton Bean

Alexandre — Wed, 10 Feb 2010 15:08:37 — source: IIUG Forums & Mailing Lists

Yeap, but it will only obey the new sizes after table re-creation, like the manuals says, right? There´s not a "on-the-fly" way to do it, unless rebuilding the entire table, I read. Regards. Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf <http://www.iiug.org>; Clifton Bean escreveu: > You can change the next exent size anytime, either immediately after the > database is created or anytime thereafter. > > Take care. > > Clifton > > >> To: ids@iiug.org >> From: penfriend5@yahoo.co.uk >> Subject: How to Change sysdistrib tables extent size? [18972] >> Date: Wed, 10 Feb 2010 01:20:51 -0500 >> >> Hi, >> >> How to Change sysdistrib tables extent size during creation of a database or >> instance itself? >> >> FYI.Checked already sysmaster.sql. >> >> >> >> > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > _________________________________________________________________ > Hotmail: Trusted email with powerful SPAM protection. > http://clk.atdmt.com/GBL/go/201469227/direct/01/ > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > >

↪ replying to Alexandre

Art Kagel — Wed, 10 Feb 2010 16:10:01 — source: IIUG Forums & Mailing Lists

NEXT SIZE takes effect immediately but only affects new extents, so, if you already have stats in the database for 10000 columns and you drop the distributions and recreate them, if the table is fragmented it will stay that way, yes, but if you create a new database with no distributions yet (or are about to add distributions for many new tables so that new extents are likely) then setting NEXT SIZE larger will help prevent new fragmentation of the table. I don't remember if you are permitted to use the new 11.50 reorg features on catalog tables, and you didn't post your version info 8-(, but it may be worth a try if you have a later release of 11.50 to reorg sysdistrib to get it down to one or two extents. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Feb 10, 2010 at 10:08 AM, Alexandre Marini < amarini@fazenda.ms.gov.br> wrote: > Yeap, but it will only obey the new sizes after table re-creation, like > the manuals says, right? > There´s not a "on-the-fly" way to do it, unless rebuilding the entire > table, I read. > > Regards. > > Alexandre Marini > > Tecnologia da Informação - DBA > > SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KS > www.iiug.org/conf > > <http://www.iiug.org>; > > Clifton Bean escreveu: > > You can change the next exent size anytime, either immediately after the > > database is created or anytime thereafter. > > > > Take care. > > > > Clifton > > > > > >> To: ids@iiug.org > >> From: penfriend5@yahoo.co.uk > >> Subject: How to Change sysdistrib tables extent size? [18972] > >> Date: Wed, 10 Feb 2010 01:20:51 -0500 > >> > >> Hi, > >> > >> How to Change sysdistrib tables extent size during creation of a > database > or > >> instance itself? > >> > >> FYI.Checked already sysmaster.sql. > >> > >> > >> > >> > > > > ******************************************************************************* > > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > _________________________________________________________________ > > Hotmail: Trusted email with powerful SPAM protection. > > http://clk.atdmt.com/GBL/go/201469227/direct/01/ > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517475f4cea4f18047f414335