alering systables.fextsize manually
Paulo Rafael Padilla asked whether he could fix systables.fextsize, which a colleague had edited by hand, by directly correcting it. Jonathan Leffler said newer versions (11.50.xC4) let you set first extent size and advised not to alter the system catalog; Jack Parker said syntax supports it from 10.xC10. Paulo tested a direct change on a test instance, where oncheck -cDI was clean.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All
I partner in my company moves manually field from systables.fextsize,
so table has a wrong value and I know it can't be done.
I could get all pages from first extent in sysmaster a then correct it.
Could I do this?
I checked table with oncheck -cDI dbm:asuntos and everything is OK.
Any opinions or side effects?
Regards
On Tue, May 12, 2009 at 17:23, PAULO RAFAEL PADILLA
<rafaelpadilla@grupomayan.com> wrote:
> I partner in my company moves manually field from systables.fextsize,
> so table has a wrong value and I know it can't be done.
It depends on the version of IDS that you're using.
> I could get all pages from first extent in sysmaster a then correct it.
> Could I do this?
If you have the right version (11.50.xC4 - I'm not sure about any
earlier versions), then you can set first extent size as well as next
size.
> I checked table with oncheck -cDI dbm:asuntos and everything is OK.
>
> Any opinions or side effects?
Best not to futz with the system catalog.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Vince Lombardi - "We didn't lose the game; we just ran out of time."
- http://www.brainyquote.com/quotes/authors/v/vince_lombardi.html
Syntax now supports modifying fextsize as of 10.xC10. Not sure of the 11
version.
j.
Sane ego te vocavi. Forsitan capedictum tuum desit.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
Jonathan Leffler
Sent: Tuesday, May 12, 2009 8:43 PM
To: ids@iiug.org
Subject: Re: alering systables.fextsize manually [15726]
On Tue, May 12, 2009 at 17:23, PAULO RAFAEL PADILLA
<rafaelpadilla@grupomayan.com> wrote:
> I partner in my company moves manually field from systables.fextsize,
> so table has a wrong value and I know it can't be done.
It depends on the version of IDS that you're using.
> I could get all pages from first extent in sysmaster a then correct it.
> Could I do this?
If you have the right version (11.50.xC4 - I'm not sure about any
earlier versions), then you can set first extent size as well as next
size.
> I checked table with oncheck -cDI dbm:asuntos and everything is OK.
>
> Any opinions or side effects?
Best not to futz with the system catalog.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Vince Lombardi - "We didn't lose the game; we just ran out of time."
- http://www.brainyquote.com/quotes/authors/v/vince_lombardi.html
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
thanks for your answers I did a test in a testing instance and everything works fine changing fextsize directly, then I did an onheck -cDI again and it seems to be working without errors. Should I consider other things? thanks again