Re: Best way to fix extents of Baan db?
Jukka wrote: > > What is the best way to fix this situation? IDS 7.31.FC6. > > dbsname tabname num_of_extents total_size > baan sysconstraints 147 77696 > baan sysobjstate 146 73608 > baan syscolumns 125 29576 > baan syscoldepend 121 25472 > baan sysfragments 114 18304 > baan sysindexes 98 9088 > baan systables 85 5248 > baan systabauth 69 2560 > sysmaster syscolumns 8 72 1) Remove Baan from your system. It is a terrible virus that uses all your resources and brings your company to it's knees!.... What's that? Your company already ploughed millions into it? Oh well, on to number 2) then... 2) Don't worry about it, unless you plan to add a lot more tables. For tables, I guess you can read companies, each creating about 2200 tables! These are all system tables, so they all get cached anyway. It's worth deleting any test companies that are no longer used. 3) Initialise your entire database server and start again, this time remembering to set the extent sizes before you install Baan. You can't set the initial extent size, but you can set the next extent size. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+
So, you mean that there is no sensible way to reorg these baan systemtables?. Do you mean that baan systemtables are cached or just informix sysmaster tables? 400 MB of data in cache ! Is it really so? Mark D. Stock <mdstock@mydas.freeserve.co.uk> wrote in message news:90p7e0$6tr$1@news.xmission.com... > > Jukka wrote: > > > > What is the best way to fix this situation? IDS 7.31.FC6. > > > > dbsname tabname num_of_extents total_size > > baan sysconstraints 147 77696 > > baan sysobjstate 146 73608 > > baan syscolumns 125 29576 > > baan syscoldepend 121 25472 > > baan sysfragments 114 18304 > > baan sysindexes 98 9088 > > baan systables 85 5248 > > baan systabauth 69 2560 > > sysmaster syscolumns 8 72 > > 1) Remove Baan from your system. It is a terrible virus that uses all > your resources and brings your company to it's knees!.... What's that? > Your company already ploughed millions into it? Oh well, on to number 2) > then... > > 2) Don't worry about it, unless you plan to add a lot more tables. For > tables, I guess you can read companies, each creating about 2200 tables! > These are all system tables, so they all get cached anyway. It's worth > deleting any test companies that are no longer used. > > 3) Initialise your entire database server and start again, this time > remembering to set the extent sizes before you install Baan. You can't > set the initial extent size, but you can set the next extent size. > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| > | http://www.informix.com http://www.informixhandbook.com |///// / file://| > | http://www.iiug.org +-----------------------------------+//// / ///| > | |This email will self-destruct in |/// / ////| > | |10 sec. If you received this email |// / /////| > | |in error, sorry about the mess. |/ ////////| > +----------------------+-----------------------------------+-----------+