alering systables.fextsize manually

Posted in 2009

PAULO RAFAEL PADILLA — Wed, 13 May 2009 00:23:22 — source: IIUG Forums & Mailing Lists

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

↪ replying to PAULO RAFAEL PADILLA

Jonathan Leffler — Wed, 13 May 2009 00:43:08 — source: IIUG Forums & Mailing Lists

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

↪ replying to Jonathan Leffler

Jack Parker — Wed, 13 May 2009 11:38:55 — source: IIUG Forums & Mailing Lists

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.

↪ replying to Jack Parker

PAULO RAFAEL — Fri, 15 May 2009 00:30:41 — source: IIUG Forums & Mailing Lists

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