Fwd: Migrating from IDS 9.40.UC6 to 11.50.UC3

Alexander, Sent you some ideas and an updated copy of dostats.ec that has the latest 64bit fixes. If you don't get that, email me directly. Art Art S. Kagel Oninit (www.oninit.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, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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, Apr 6, 2009 at 8:48 PM, Alexander <homo.programmerus@gmail.com>wrote: > Hi Art, > > Thanks for your advice and your great dostats that we have been using > for about an year. It seems there is problem with IDS 11.50. The > subject of this thread supposed to be " Migrating from IDS 9.40.FC6 to > 11.50.FC3" because it is 64 bit IDS in both cases. Well, previously we > had IDS 9.40.FC6 along with 32bit CSDK and all 4GL and other ESQL- > dependent utilities were built as 32bit executables. > > Now the CSDK comes with IDE (at least it is included in IDS > installation bundle and I can't find separate 32bit CDSK for Solaris/ > SPARC) so i can't build 32bit executables using these 64bit libraries. > I tried to edit dostats Makefile to add "-m64" to CFLAGS but it still > fails at the linking time with the following errors: > > /usr/local/lib/gcc/sparc-sun-solaris2.9/3.4.6/../../../../sparc-sun- > solaris2.9/bin/ld: skipping incompatible /opt/informix/lib/esql/ > libifsql.so when searching for -lifsql > /usr/local/lib/gcc/sparc-sun-solaris2.9/3.4.6/../../../../sparc-sun- > solaris2.9/bin/ld: skipping incompatible /opt/informix/lib/esql/ > libifsql.a when searching for -lifsql > /usr/local/lib/gcc/sparc-sun-solaris2.9/3.4.6/../../../../sparc-sun- > solaris2.9/bin/ld: cannot find -lifsql > GNU ld (GNU Binutils) 2.19 > Supported emulations: > elf32_sparc > elf64_sparc > collect2: ld returned 1 exit status > make: *** [dostats] Error 1 > > This is what I have in my Makefile for dostats: > > CFLAGS=-O -m64 -EDHAVE_GETOPT_H=1 > CC=gcc > > This is what file utility things about that library: > > > $ file /opt/informix/lib/esql/libifsql.so > /opt/informix/lib/esql/libifsql.so: ELF 64-bit MSB dynamic lib> SPARCV9 Version 1, dynamically linked, not stripped > > Please geive me some clue on what is going on. I spent almost a day > trying to solve that with not much luck. > > Thanks > Alexander > > On Apr 6, 7:35 pm, Art Kagel <art.ka...@gmail.com> wrote: > > Before you do any testing, you must do the following: > > > > - In every database, for every table: > > - UPDATE STATISTICS LOW DROP DISTRIBUTIONS; > > - UPDATE STATISTICS according the the recommendations in the > > Performance Guide to create new data distributions. > > - For every stored procedure and function: > > - UPDATE STATISTICS FOR PROCEDURE <procedurename>; > > > > This is neccessary because the format of the data distribution records > > stored on disk changes from IDS version to IDS version. If you do not > drop > > the distributions first, the new update stats do not always work. > > My dostats utility will do all of this for you. Run: > > dostats -d <database> -L # Drops distributions > > dostats -d <database> # Rebuilds distributions and recompiles > > procedures > > > > Dostats is included in the package utils2_ak which you can download from > the > > Oninit web site (www.oninit.com/utils) or the IIUG Software Repository ( > www.iiug.org/software) > > > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (a...@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > > with which I am associated either explicitly or implicitly. 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, Apr 6, 2009 at 1:07 PM, Alexander <homo.programme...@gmail.com > >wrote: > > > > > On Apr 5, 3:18 pm, bluexn...@googlemail.com wrote: > > > > onstat -g ath ?> > > > > > onstat -g stk all ?> > > > > > What IS going (on)? > > > > > Thank you for replying. I was able to successfully convert database by > > > re-running whole proccess once again. I'm not sure what went wrong > > > diring first attempt. This time Informix switched to multi-user mode > > > in couple minutes. I still haven't seen "Conversion Completed > > > Successfully" but may be migration documentation is out of sync with > > > reality. Anyway, after it went to multi-user mode I was able to run > > > any queries and now we are starting to test our software for > > > compatibility with new IDS version. > > > > > Thank you > > > Alexander > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >