Re: Best way to fix extents of Baan db?
Jukka wrote:
>
> does this work with baan hash columns?
> Level-1
> -Jukka
> Martin, Wayne E. <WMartin@kmart.com> wrote in message
> news:90qs5h$mga$1@news.xmission.com...
> >
> > Dbexport the database
> > add alter table "syssometable" next size 256; in the database.sql file
> from
> > the export
> > dbimport the database
It works if your hash values do not contain the delimiter character.
However, the system tables are not in the schema file, so you cannot
alter them there. You would have to create the baan database first,
alter the system tables, then create and load the tables manually.
Why do I keep replying to people without an email address?
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. |/ ////////|
+----------------------+-----------------------------------+-----------+
Thanks Mark!
Conclusion is just to fix next extent size of these tables, if they really
are cached.
-Jukka
Mark D. Stock <mdstock@mydas.freeserve.co.uk> wrote in message
news:90u94v$q87$1@news.xmission.com...
>
> Jukka wrote:
> >
> > does this work with baan hash columns?
> > Level-1
> > -Jukka
> > Martin, Wayne E. <WMartin@kmart.com> wrote in message
> > news:90qs5h$mga$1@news.xmission.com...
> > >
> > > Dbexport the database
> > > add alter table "syssometable" next size 256; in the database.sql file
> > from
> > > the export
> > > dbimport the database
>
> It works if your hash values do not contain the delimiter character.
> However, the system tables are not in the schema file, so you cannot
> alter them there. You would have to create the baan database first,
> alter the system tables, then create and load the tables manually.
>
> Why do I keep replying to people without an email address?
>
> 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. |/ ////////|
> +----------------------+-----------------------------------+-----------+