Question about extents on IFX 11.50

Hello Everybody, First of all we migrate from 9.40 to 11.50 on our core business server, without having any problem, but im carrying one old problem. We have systabauth table with 139 extents, so i was reading the SQL Syntax the alter table command to change the first and next extent size, but it says thatfirst extent size cannnot be changed on system catalog tables. We are using 11.50 FC8 on AIX 5.3 Do you have any clue ? Thanks in advance ! Leonardo

Hi. Could you post your onconfig vars here: TBLTBLFIRST TBLTBLNEXT TBLSPACE_STATS (The default values for above are: 0, 0 and 1) Maybe your ids engine isn´t configured to manage the extents automatically...? Best regards. Em 18/01/2011 09:15, LEONARDO SANTAGOSTINI escreveu: > Hello Everybody, > > First of all we migrate from 9.40 to 11.50 on our core business server, > without having any problem, but im carrying one old problem. > > We have systabauth table with 139 extents, so i was reading the SQL Syntax the > alter table command to change the first and next extent size, but it saysthat > first extent size cannnot be changed on system catalog tables. > > We are using 11.50 FC8 on AIX 5.3 > > Do you have any clue ? > > Thanks in advance ! > > Leonardo > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11

A couple of issues: 1. Changing the extent sizing for a table, user or catalog, doesn't get fix the extent problem. You still have to reorg the table in some way. 2. There is no way to reorg a catalog table except to export the database, recreate the database empty, change the extent sizing of the catalog table that's giving you trouble, then reload the database. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ 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 Tue, Jan 18, 2011 at 8:15 AM, LEONARDO SANTAGOSTINI < lsantagostini@gmail.com> wrote: > Hello Everybody, > > First of all we migrate from 9.40 to 11.50 on our core business server, > without having any problem, but im carrying one old problem. > > We have systabauth table with 139 extents, so i was reading the SQL Syntax > the > alter table command to change the first and next extent size, but it says> that > first extent size cannnot be changed on system catalog tables. > > We are using 11.50 FC8 on AIX 5.3 > > Do you have any clue ? > > Thanks in advance ! > > Leonardo > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5c2418a3a3c049a1f00e3