 |
IDS Forum
Re: Upgrade v11.50.fc5 to v11.50.fc7 issue
Posted By: Art Kagel
Date: Tuesday, 21 September 2010, at 3:38 p.m.
In Response To: Re: Upgrade v11.50.fc5 to v11.50.fc7 issue (Frank Langelage)
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/include/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
> >>> 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
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016361e8946983d4d0490ca2c94
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
