Upgrade v11.50.fc5 to v11.50.fc7 issue

After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting the following: 26060: Procedure was created with an older version of the engine and mustbe dropped and created again in order to work properly Error in line 1Near character position 1 I've never gotten anything like this before ... anyone know if this is some sort of defect? Also, dbload seems to have a problem in this version ... Anyone know of a quick and dirty way to drop and recreate the procedures ... Obviously this can be done by getting the info out of the system catalogs .. anyone got the sql? Thanks in advance ... Peter Logan Senior Database Administrator Phone: 616/878-8309

Hello. I had the same errors here, after an old upgrade. Please open a PMR and IBM will help you on this, ok? Best regards. Em 20/09/2010 08:19, Peter_Logan@spartanstores.com escreveu: > After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting the > following: > 26060: Procedure was created with an older version of the engine and must> be dropped and created again in order to work properly > Error in line 1> Near character position 1 > > I've never gotten anything like this before ... anyone know if this is > some sort of defect? Also, dbload seems to have a problem in this version > .... Anyone know of a quick and dirty way to drop and recreate the > procedures ... Obviously this can be done by getting the info out of the > system catalogs .. anyone got the sql? Thanks in advance ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > ******************************************************************************* > 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 Informix Dynamic Server Certified Professional V10 / V11

It should be sufficient to recompile them all by running UPDATE STATISTICS FOR PROCEDURE; Did you drop all of your distributions and rerun your update stats for tables after the upgrade? You REALLY should, then recompile the procs. Or let dostats do it all for you. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Mon, Sep 20, 2010 at 8:19 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting the > following: > 26060: Procedure was created with an older version of the engine and must> be dropped and created again in order to work properly > Error in line 1> Near character position 1 > > I've never gotten anything like this before ... anyone know if this is > some sort of defect? Also, dbload seems to have a problem in this version > .... Anyone know of a quick and dirty way to drop and recreate the > procedures ... Obviously this can be done by getting the info out of the > system catalogs .. anyone got the sql? Thanks in advance ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016361e89a47610a70490b03fd6

Thanks Art ... do you have a copy of dostats that works on Aix? Seems to me that I remember there being some issue ... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 09/20/2010 08:43 AM Subject: Re: Upgrade v11.50.fc5 to v11.50.fc7 issue [21358] Sent by: ids-bounces@iiug.org It should be sufficient to recompile them all by running UPDATE STATISTICS FOR PROCEDURE; Did you drop all of your distributions and rerun your update stats for tables after the upgrade? You REALLY should, then recompile the procs. Or let dostats do it all for you. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Mon, Sep 20, 2010 at 8:19 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting the > following: > 26060: Procedure was created with an older version of the engine andmust > be dropped and created again in order to work properly > Error in line 1> Near character position 1 > > I've never gotten anything like this before ... anyone know if this is > some sort of defect? Also, dbload seems to have a problem in this version > .... Anyone know of a quick and dirty way to drop and recreate the > procedures ... Obviously this can be done by getting the info out of the > system catalogs .. anyone got the sql? Thanks in advance ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016361e89a47610a70490b03fd6 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Ah, yes, there is an outstanding issue about the placement of the #include for the system's copy of getopt.h that is causing greif to dostats and probably to ul.ec and myschema as well. Can anyone with an AIX system to test on and a stubborn personality figure out how to modify dostats_ng.ec and dostats.ec so that they will compile correctly on the latest release of AIX? IBM has apparently included the prototype of getopt() or the hard-pathed inclusion of the system's getopt.h in stdlib.h which causes a prototype clash when my utilities try to include the modified GNU-ish getopt.h that's included with utils2_ak. Jonathan? Anyone? I no longer have access to an AIX system to work this out on. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Mon, Sep 20, 2010 at 8:46 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Thanks Art ... do you have a copy of dostats that works on Aix? Seems to > me that I remember there being some issue ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > From: > "Art Kagel" <art.kagel@gmail.com> > To: > ids@iiug.org > Date: > 09/20/2010 08:43 AM > Subject: > Re: Upgrade v11.50.fc5 to v11.50.fc7 issue [21358] > Sent by: > ids-bounces@iiug.org > > It should be sufficient to recompile them all by running UPDATE STATISTICS > > FOR PROCEDURE; > > Did you drop all of your distributions and rerun your update stats for > tables after the upgrade? You REALLY should, then recompile the procs. Or > let dostats do it all for you. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > 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 Mon, Sep 20, 2010 at 8:19 AM, Peter_Logan@spartanstores.com < > Peter_Logan@spartanstores.com> wrote: > > > After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting > the > > following: > > 26060: Procedure was created with an older version of the engine and> must > > be dropped and created again in order to work properly > > Error in line 1> > Near character position 1 > > > > I've never gotten anything like this before ... anyone know if this is > > some sort of defect? Also, dbload seems to have a problem in this > version > > .... Anyone know of a quick and dirty way to drop and recreate the > > procedures ... Obviously this can be done by getting the info out of the > > > system catalogs .. anyone got the sql? Thanks in advance ... > > > > Peter Logan > > Senior Database Administrator > > Phone: 616/878-8309 > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --0016361e89a47610a70490b03fd6 > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e64f47d6b634800490b51661

I just putted a dostats_ng binary to ftp://langfr.homeunix.net/pub/. It was compiled on AIX 5.3 using CSDK 3.50.UC6 with -static. So only OS libs are used on runtime. Feel free to use it. Frank On 20.09.10 20:29, Art Kagel wrote: > Ah, yes, there is an outstanding issue about the placement of the #include > for the system's copy of getopt.h that is causing greif to dostats and > probably to ul.ec and myschema as well. > > Can anyone with an AIX system to test on and a stubborn personality figure > out how to modify dostats_ng.ec and dostats.ec so that they will compile > correctly on the latest release of AIX? IBM has apparently included the > prototype of getopt() or the hard-pathed inclusion of the system's getopt.h > in stdlib.h which causes a prototype clash when my utilities try to include > the modified GNU-ish getopt.h that's included with utils2_ak. Jonathan? > Anyone? I no longer have access to an AIX system to work this out on. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > 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 Mon, Sep 20, 2010 at 8:46 AM, Peter_Logan@spartanstores.com< > Peter_Logan@spartanstores.com> wrote: > >> Thanks Art ... do you have a copy of dostats that works on Aix? Seems to >> me that I remember there being some issue ... >> >> Peter Logan >> Senior Database Administrator >> Phone: 616/878-8309 >> >> From: >> "Art Kagel"<art.kagel@gmail.com> >> To: >> ids@iiug.org >> Date: >> 09/20/2010 08:43 AM >> Subject: >> Re: Upgrade v11.50.fc5 to v11.50.fc7 issue [21358] >> Sent by: >> ids-bounces@iiug.org >> >> It should be sufficient to recompile them all by running UPDATE STATISTICS >> >> FOR PROCEDURE; >> >> Did you drop all of your distributions and rerun your update stats for >> tables after the upgrade? You REALLY should, then recompile the procs. Or >> let dostats do it all for you. >> >> Art >> >> Art S. Kagel >> Advanced DataTools (www.advancedatatools.com) >> IIUG Board of Directors (art@iiug.org) >> >> 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 Mon, Sep 20, 2010 at 8:19 AM, Peter_Logan@spartanstores.com< >> Peter_Logan@spartanstores.com> wrote: >> >>> After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting >> the >>> following: >>> 26060: Procedure was created with an older version of the engine and>> must >>> be dropped and created again in order to work properly >>> Error in line 1>>> Near character position 1 >>> >>> I've never gotten anything like this before ... anyone know if this is >>> some sort of defect? Also, dbload seems to have a problem in this >> version >>> .... Anyone know of a quick and dirty way to drop and recreate the >>> procedures ... Obviously this can be done by getting the info out of the >>> system catalogs .. anyone got the sql? Thanks in advance ... >>> >>> Peter Logan >>> Senior Database Administrator >>> Phone: 616/878-8309 >>> >>> >>> >>> >> >> > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> >> --0016361e89a47610a70490b03fd6 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --0016e64f47d6b634800490b51661 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Thanks .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Frank Langelage" <frank@lafr.de> To: ids@iiug.org Date: 09/20/2010 03:27 PM Subject: Re: Upgrade v11.50.fc5 to v11.50.fc7 issue [21368] Sent by: ids-bounces@iiug.org I just putted a dostats_ng binary to ftp://langfr.homeunix.net/pub/. It was compiled on AIX 5.3 using CSDK 3.50.UC6 with -static. So only OS libs are used on runtime. Feel free to use it. Frank On 20.09.10 20:29, Art Kagel wrote: > Ah, yes, there is an outstanding issue about the placement of the #include > for the system's copy of getopt.h that is causing greif to dostats and > probably to ul.ec and myschema as well. > > Can anyone with an AIX system to test on and a stubborn personality figure > out how to modify dostats_ng.ec and dostats.ec so that they will compile > correctly on the latest release of AIX? IBM has apparently included the > prototype of getopt() or the hard-pathed inclusion of the system's getopt.h > in stdlib.h which causes a prototype clash when my utilities try to include > the modified GNU-ish getopt.h that's included with utils2_ak. Jonathan? > Anyone? I no longer have access to an AIX system to work this out on. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > 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 Mon, Sep 20, 2010 at 8:46 AM, Peter_Logan@spartanstores.com< > Peter_Logan@spartanstores.com> wrote: > >> Thanks Art ... do you have a copy of dostats that works on Aix? Seems to >> me that I remember there being some issue ... >> >> Peter Logan >> Senior Database Administrator >> Phone: 616/878-8309 >> >> From: >> "Art Kagel"<art.kagel@gmail.com> >> To: >> ids@iiug.org >> Date: >> 09/20/2010 08:43 AM >> Subject: >> Re: Upgrade v11.50.fc5 to v11.50.fc7 issue [21358] >> Sent by: >> ids-bounces@iiug.org >> >> It should be sufficient to recompile them all by running UPDATE STATISTICS >> >> FOR PROCEDURE; >> >> Did you drop all of your distributions and rerun your update stats for >> tables after the upgrade? You REALLY should, then recompile the procs. Or >> let dostats do it all for you. >> >> Art >> >> Art S. Kagel >> Advanced DataTools (www.advancedatatools.com) >> IIUG Board of Directors (art@iiug.org) >> >> 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 Mon, Sep 20, 2010 at 8:19 AM, Peter_Logan@spartanstores.com< >> Peter_Logan@spartanstores.com> wrote: >> >>> After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting >> the >>> following: >>> 26060: Procedure was created with an older version of the engine and>> must >>> be dropped and created again in order to work properly >>> Error in line 1>>> Near character position 1 >>> >>> I've never gotten anything like this before ... anyone know if this is >>> some sort of defect? Also, dbload seems to have a problem in this >> version >>> .... Anyone know of a quick and dirty way to drop and recreate the >>> procedures ... Obviously this can be done by getting the info out of the >>> system catalogs .. anyone got the sql? Thanks in advance ... >>> >>> Peter Logan >>> Senior Database Administrator >>> Phone: 616/878-8309 >>> >>> >>> >>> >> >> > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> >> --0016361e89a47610a70490b03fd6 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --0016e64f47d6b634800490b51661 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

On Mon, Sep 20, 2010 at 1:19 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting the > following: > 26060: Procedure was created with an older version of the engine and must> be dropped and created again in order to work properly > Error in line 1> Near character position 1 > > I've never gotten anything like this before ... anyone know if this is > some sort of defect? Also, dbload seems to have a problem in this version > .... Anyone know of a quick and dirty way to drop and recreate the > procedures ... Obviously this can be done by getting the info out of the > system catalogs .. anyone got the sql? Thanks in advance ... > > Did you UPDATE STATISTICS FOR PROCEDURE as the documentation mentions? If you did, you should open a PMR, but I did several of these upgrades without having problems. Also, just as a side note, I really hope you have the code for your procedures OUTSIDE the database. It's not that you can't get it form the database (dbschema -d database -f all) but it seems to indicate that you don't have source code management, and that's very bad. Unless of course your application is from a third party, but in that case this party should have been involved. Please tell us if the UPDATE STATS solves the problem. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0015175ce134a741d00490b70ac7

Yes we have the code ... just lazy developers who didn't want to recompile ... Strange thing is that the procedures ran ok the first time they ran ... got this error the second time ... update stats were performed ... I can't run the offending procedures again until next week... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Fernando Nunes" <domusonline@gmail.com> To: ids@iiug.org Date: 09/20/2010 04:49 PM Subject: Re: Upgrade v11.50.fc5 to v11.50.fc7 issue [21371] Sent by: ids-bounces@iiug.org On Mon, Sep 20, 2010 at 1:19 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting the > following: > 26060: Procedure was created with an older version of the engine andmust > be dropped and created again in order to work properly > Error in line 1> Near character position 1 > > I've never gotten anything like this before ... anyone know if this is > some sort of defect? Also, dbload seems to have a problem in this version > .... Anyone know of a quick and dirty way to drop and recreate the > procedures ... Obviously this can be done by getting the info out of the > system catalogs .. anyone got the sql? Thanks in advance ... > > Did you UPDATE STATISTICS FOR PROCEDURE as the documentation mentions? If you did, you should open a PMR, but I did several of these upgrades without having problems. Also, just as a side note, I really hope you have the code for your procedures OUTSIDE the database. It's not that you can't get it form the database (dbschema -d database -f all) but it seems to indicate that you don't have source code management, and that's very bad. Unless of course your application is from a third party, but in that case this party should have been involved. Please tell us if the UPDATE STATS solves the problem. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0015175ce134a741d00490b70ac7 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Frank, Did you make any source or make file modifications to get this to work (besides the -static)? If so, what? I'd like to incorporate the mods into the mainline code for the next release. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Mon, Sep 20, 2010 at 3:26 PM, Frank Langelage <frank@lafr.de> wrote: > I just putted a dostats_ng binary to ftp://langfr.homeunix.net/pub/. > It was compiled on AIX 5.3 using CSDK 3.50.UC6 with -static. > So only OS libs are used on runtime. > > Feel free to use it. > > Frank > > On 20.09.10 20:29, Art Kagel wrote: > > Ah, yes, there is an outstanding issue about the placement of the > #include > > for the system's copy of getopt.h that is causing greif to dostats and > > probably to ul.ec and myschema as well. > > > > Can anyone with an AIX system to test on and a stubborn personality > figure > > out how to modify dostats_ng.ec and dostats.ec so that they will compile > > correctly on the latest release of AIX? IBM has apparently included the > > prototype of getopt() or the hard-pathed inclusion of the system's > getopt.h > > in stdlib.h which causes a prototype clash when my utilities try to > include > > the modified GNU-ish getopt.h that's included with utils2_ak. Jonathan? > > Anyone? I no longer have access to an AIX system to work this out on. > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.com) > > IIUG Board of Directors (art@iiug.org) > > > > 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 Mon, Sep 20, 2010 at 8:46 AM, Peter_Logan@spartanstores.com< > > Peter_Logan@spartanstores.com> wrote: > > > >> Thanks Art ... do you have a copy of dostats that works on Aix? Seems to > >> me that I remember there being some issue ... > >> > >> Peter Logan > >> Senior Database Administrator > >> Phone: 616/878-8309 > >> > >> From: > >> "Art Kagel"<art.kagel@gmail.com> > >> To: > >> ids@iiug.org > >> Date: > >> 09/20/2010 08:43 AM > >> Subject: > >> Re: Upgrade v11.50.fc5 to v11.50.fc7 issue [21358] > >> Sent by: > >> ids-bounces@iiug.org > >> > >> It should be sufficient to recompile them all by running UPDATE > STATISTICS > >> > >> FOR PROCEDURE; > >> > >> Did you drop all of your distributions and rerun your update stats for > >> tables after the upgrade? You REALLY should, then recompile the procs. > Or > >> let dostats do it all for you. > >> > >> Art > >> > >> Art S. Kagel > >> Advanced DataTools (www.advancedatatools.com) > >> IIUG Board of Directors (art@iiug.org) > >> > >> 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 Mon, Sep 20, 2010 at 8:19 AM, Peter_Logan@spartanstores.com< > >> Peter_Logan@spartanstores.com> wrote: > >> > >>> After upgrading from v11.50.fc5 to v11.50.fc7 on Aix 6.1 I am getting > >> the > >>> following: > >>> 26060: Procedure was created with an older version of the engine and> >> must > >>> be dropped and created again in order to work properly > >>> Error in line 1> >>> Near character position 1 > >>> > >>> I've never gotten anything like this before ... anyone know if this is > >>> some sort of defect? Also, dbload seems to have a problem in this > >> version > >>> .... Anyone know of a quick and dirty way to drop and recreate the > >>> procedures ... Obviously this can be done by getting the info out of > the > >>> system catalogs .. anyone got the sql? Thanks in advance ... > >>> > >>> Peter Logan > >>> Senior Database Administrator > >>> Phone: 616/878-8309 > >>> > >>> > >>> > >>> > >> > >> > > > > ******************************************************************************* > >>> Forum Note: Use "Reply" to post a response in the discussion forum. > >>> > >>> > >> --0016361e89a47610a70490b03fd6 > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > --0016e64f47d6b634800490b51661 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016361e877c2244ac0490c29dc0

Art, there was no need to change sources, only the Makefile change to enable the -static flag. This may be due to the fact that we're using a self compiled GNU gcc 3.2 on this platform. I do not have access to an AIX system with the system compiler xlc. The verbose output is Reading specs from /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/specs Configured with: ../../configure --disable-shared --enable-threads --enable-languages=c++ --prefix=/usr/gnu/gcc32 --with-as=/usr/bin/as --with-ld=/usr/bin/ld --disable-multilib --disable-aix64 Thread model: aix gcc version 3.2 /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/cc1 -lang-c -v -I/home/mbi/tools/infsdk350/incl/esql -D__GNUC__=3 -D__GNUC_MINOR__=2 -D__GNUC_PATCHLEVEL__=0 -D__GXX_ABI_VERSION=102 -D_IBMR2 -D_POWER -D_LONG_LONG -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -D_IBMR2 -D_POWER -D_LONG_LONG -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -Asystem=unix -Asystem=aix -D__OPTIMIZE__ -D__STDC_HOSTED__=1 -D__WCHAR_TYPE__=short unsigned int -D_ARCH_COM -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1 dostats_ng.c -quiet -dumpbase dostats_ng.c -O -version -o /tmp/ccv98zVa.s GNU CPP version 3.2 (cpplib) GNU C version 3.2 (powerpc-ibm-aix5.3.0.0) compiled by GNU C version 3.2. #include "..." search starts here: #include<...> search starts here: /home/mbi/tools/infsdk350/incl/esql /usr/gnu/gcc32/include /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include /usr/include End of search list. /usr/bin/as -u -mcom -o /tmp/ccOuSpzn.o /tmp/ccv98zVa.s /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/cc1 -lang-c -v -I/home/mbi/tools/infsdk350/incl/esql -D__GNUC__=3 -D__GNUC_MINOR__=2 -D__GNUC_PATCHLEVEL__=0 -D__GXX_ABI_VERSION=102 -D_IBMR2 -D_POWER -D_LONG_LONG -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -D_IBMR2 -D_POWER -D_LONG_LONG -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -Asystem=unix -Asystem=aix -D__OPTIMIZE__ -D__STDC_HOSTED__=1 -D__WCHAR_TYPE__=short unsigned int -D_ARCH_COM -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1 getopt.c -quiet -dumpbase getopt.c -O -version -o /tmp/ccv98zVa.s GNU CPP version 3.2 (cpplib) GNU C version 3.2 (powerpc-ibm-aix5.3.0.0) compiled by GNU C version 3.2. #include "..." search starts here: #include<...> search starts here: /home/mbi/tools/infsdk350/incl/esql /usr/gnu/gcc32/include /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include /usr/include End of search list. /usr/bin/as -u -mcom -o /tmp/ccRpSuoR.o /tmp/ccv98zVa.s /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/collect2 -bpT:0x10000000 -bpD:0x20000000 -btextro -bnodelcsect -o dostats /lib/crt0.o -L/usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2 -L/usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/../../.. /tmp/ccOuSpzn.o /tmp/ccRpSuoR.o /home/mbi/tools/infsdk350/lib/esql/libifos.a /home/mbi/tools/infsdk350/lib/esql/libifgen.a /home/mbi/tools/infsdk350/lib/esql/libifsql.a /home/mbi/tools/infsdk350/lib/libifasf.a /home/mbi/tools/infsdk350/lib/esql/libifos.a /home/mbi/tools/infsdk350/lib/esql/libifgen.a /home/mbi/tools/infsdk350/lib/esql/libifsql.a /home/mbi/tools/infsdk350/lib/esql/libifgls.a -lc_r -ldl -ltli_r -lm_r /home/mbi/tools/infsdk350/lib/esql/libifglx.a /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/libgcc.a -lc /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/libgcc.a The GNU specific headers in the two directories mentioned are /usr/gnu/gcc32/include/ansidecl.h /usr/gnu/gcc32/include/bfd.h /usr/gnu/gcc32/include/bfdlink.h /usr/gnu/gcc32/include/dis-asm.h /usr/gnu/gcc32/include/symcat.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/assert.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/ctype.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/curses.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/inttypes.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/iso646.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/limits.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/locale.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/math.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/net/bpf.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/netinet/if_802_5.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/root/usr/lpp/X11/i nclude/X11/Xlib.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/rpc/auth.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/rpc/clnt.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/rpc/svc.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/rpc/xdr.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/setjmp.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stdarg.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stdbool.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stddef.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stdio.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stdlib.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/string.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/sys/inttypes.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/sys/signal.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/sys/types.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/sys/wait.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/syslimits.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/term.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/unistd.h /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/varargs.h Regards, Frank On 21.09.10 12:37, Art Kagel wrote: > Frank, > > Did you make any source or make file modifications to get this to work > (besides the -static)? If so, what? I'd like to incorporate the mods into > the mainline code for the next release. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > 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 Mon, Sep 20, 2010 at 3:26 PM, Frank Langelage<frank@lafr.de> wrote: > >> I just putted a dostats_ng binary to ftp://langfr.homeunix.net/pub/. >> It was compiled on AIX 5.3 using CSDK 3.50.UC6 with -static. >> So only OS libs are used on runtime. >> >> Feel free to use it. >> >> Frank >> >> On 20.09.10 20:29, Art Kagel wrote: >>> Ah, yes, there is an outstanding issue about the placement of the >> #include >>> for the system's copy of getopt.h that is causing greif to dostats and >>> probably to ul.ec and myschema as well. >>> >>> Can anyone with an AIX system to test on and a stubborn personality >> figure

Yes, GCC 3.x is OK, xlc is not and I'm not sure about GCC 4.x on AIX. Thanks. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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, Sep 21, 2010 at 3:26 PM, Frank Langelage <frank@lafr.de> wrote: > Art, > > there was no need to change sources, only the Makefile change to enable > the -static flag. > This may be due to the fact that we're using a self compiled GNU gcc 3.2 > on this platform. > I do not have access to an AIX system with the system compiler xlc. > > The verbose output is > > Reading specs from > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/specs > Configured with: ../../configure --disable-shared --enable-threads > --enable-languages=c++ --prefix=/usr/gnu/gcc32 --with-as=/usr/bin/as > --with-ld=/usr/bin/ld --disable-multilib --disable-aix64 > Thread model: aix > gcc version 3.2 > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/cc1 -lang-c -v > -I/home/mbi/tools/infsdk350/incl/esql -D__GNUC__=3 -D__GNUC_MINOR__=2 > -D__GNUC_PATCHLEVEL__=0 -D__GXX_ABI_VERSION=102 -D_IBMR2 -D_POWER > -D_LONG_LONG > -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -D_IBMR2 -D_POWER -D_LONG_LONG > -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -Asystem=unix -Asystem=aix > -D__OPTIMIZE__ -D__STDC_HOSTED__=1 -D__WCHAR_TYPE__=short unsigned int > -D_ARCH_COM -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1 dostats_ng.c -quiet > -dumpbase dostats_ng.c -O -version -o /tmp/ccv98zVa.s > GNU CPP version 3.2 (cpplib) > GNU C version 3.2 (powerpc-ibm-aix5.3.0.0) > > compiled by GNU C version 3.2. > #include "..." search starts here: > #include<...> search starts here: > /home/mbi/tools/infsdk350/incl/esql > /usr/gnu/gcc32/include > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include > /usr/include > End of search list. > /usr/bin/as -u -mcom -o /tmp/ccOuSpzn.o /tmp/ccv98zVa.s > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/cc1 -lang-c -v > -I/home/mbi/tools/infsdk350/incl/esql -D__GNUC__=3 -D__GNUC_MINOR__=2 > -D__GNUC_PATCHLEVEL__=0 -D__GXX_ABI_VERSION=102 -D_IBMR2 -D_POWER > -D_LONG_LONG > -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -D_IBMR2 -D_POWER -D_LONG_LONG > -D_AIX -D_AIX32 -D_AIX41 -D_AIX43 -D_AIX51 -Asystem=unix -Asystem=aix > -D__OPTIMIZE__ -D__STDC_HOSTED__=1 -D__WCHAR_TYPE__=short unsigned int > -D_ARCH_COM -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1 getopt.c -quiet -dumpbase > getopt.c -O -version -o /tmp/ccv98zVa.s > GNU CPP version 3.2 (cpplib) > GNU C version 3.2 (powerpc-ibm-aix5.3.0.0) > > compiled by GNU C version 3.2. > #include "..." search starts here: > #include<...> search starts here: > /home/mbi/tools/infsdk350/incl/esql > /usr/gnu/gcc32/include > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include > /usr/include > End of search list. > /usr/bin/as -u -mcom -o /tmp/ccRpSuoR.o /tmp/ccv98zVa.s > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/collect2 > -bpT:0x10000000 > -bpD:0x20000000 -btextro -bnodelcsect -o dostats /lib/crt0.o > -L/usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2 > -L/usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/../../.. > /tmp/ccOuSpzn.o /tmp/ccRpSuoR.o > /home/mbi/tools/infsdk350/lib/esql/libifos.a > /home/mbi/tools/infsdk350/lib/esql/libifgen.a > /home/mbi/tools/infsdk350/lib/esql/libifsql.a > /home/mbi/tools/infsdk350/lib/libifasf.a > /home/mbi/tools/infsdk350/lib/esql/libifos.a > /home/mbi/tools/infsdk350/lib/esql/libifgen.a > /home/mbi/tools/infsdk350/lib/esql/libifsql.a > /home/mbi/tools/infsdk350/lib/esql/libifgls.a -lc_r -ldl -ltli_r -lm_r > /home/mbi/tools/infsdk350/lib/esql/libifglx.a > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/libgcc.a -lc > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/libgcc.a > > The GNU specific headers in the two directories mentioned are > > /usr/gnu/gcc32/include/ansidecl.h > /usr/gnu/gcc32/include/bfd.h > /usr/gnu/gcc32/include/bfdlink.h > /usr/gnu/gcc32/include/dis-asm.h > /usr/gnu/gcc32/include/symcat.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/assert.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/ctype.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/curses.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/inttypes.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/iso646.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/limits.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/locale.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/math.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/net/bpf.h > > > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/netinet/if_802_5.h > > > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/root/usr/lpp/X11/i nclude/X11/Xlib.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/rpc/auth.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/rpc/clnt.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/rpc/svc.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/rpc/xdr.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/setjmp.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stdarg.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stdbool.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stddef.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stdio.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/stdlib.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/string.h > > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/sys/inttypes.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/sys/signal.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/sys/types.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/sys/wait.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/syslimits.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/term.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/unistd.h > /usr/gnu/gcc32/lib/gcc-lib/powerpc-ibm-aix5.3.0.0/3.2/include/varargs.h > > Regards, Frank > > On 21.09.10 12:37, Art Kagel wrote: > > Frank, > > > > Did you make any source or make file modifications to get this to work > > (besides the -static)? If so, what? I'd like to incorporate the mods into > > the mainline code for the next release. > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and@@N

I ran into this problem on 11.50.fc5 running on aix 5.3. I ran update statistics on the procedure with no change in the behavior. I opened a PMR and all I got was drop and recreate the procedure. It didn't seem to me that support was very interested in fixing this issue but it could have been the individual.