dostats on AIX with gcc

dostats on AIX with gcc

Post by Neil Trub » Wed, 15 Nov 2006 04:12:30


AIX 5.3, gcc compiler, IDS 10.0 FC5.

Anyone come across this before in compiling dostats?:

$ export INFORMIXC=gcc
$ esql dostats.ec > dostats.o
gcc: '-b' must come at the start of the command line

I mean, of all the uninformative drivel!

thx

--
Neil
 
 
 

dostats on AIX with gcc

Post by Neil Trub » Wed, 15 Nov 2006 07:14:40

IDS 10.0FC5 on AIX 5.3L, using gcc

has anyone succesfully got dostats to work on this combination? I seem to
be missing a mysetrious library, libmsaa, which is nowhere to be found on my
system.

Thanks
Neil

$ make dostats
INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o dostats dostats.ec
getopt.c
gcc: unrecognized option '-qchars=signed'
gcc: unrecognized option '-q64'
gcc: unrecognized option '-qlanglvl=ansi'
gcc: unrecognized option '-qalign=natural'
gcc: unrecognized option '-qcheck=nullptr'
gcc: unrecognized option '-qmaxmem=-1'
gcc: unrecognized option '-qspill=2000'
collect2: library libmsaa not found
make: 1254-004 The error code from the last command is 1.

Stop.

 
 
 

dostats on AIX with gcc

Post by Art S. Kag » Wed, 15 Nov 2006 08:56:04


These are all of the 64bit xlc options I mentioned in the prior post. Also
Neil seems to be missing some mathematics package that ESQL/C wants to use.

All in all it's easier to just use xlc. I find that if you include the -O2
and -qmaxmem=16384 options on the commandline performance is acceptable and
the executable is not overly large. (FYI: I don't trust xlc optimizer
levels beyond 2 - I've had the code fail in testing occassionally.)

Art S. Kagel
 
 
 

dostats on AIX with gcc

Post by Neil Trub » Wed, 15 Nov 2006 09:14:54


You have to pay ?00 per server for XL C though!
 
 
 

dostats on AIX with gcc

Post by Paul Watso » Wed, 15 Nov 2006 09:26:44

> >> IDS 10.0FC5 on AIX 5.3L, using gcc

Don be so tight - spend the money. You'll waste more that sorting out
the problem

I take it you have 'fixed' the esqlc script to work correctly with gcc ?


Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com

GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend IDUG 2007 San Jose, North America
May 6-10, 2007
Visit http://www.yqcomputer.com/
 
 
 

dostats on AIX with gcc

Post by Neil Trub » Wed, 15 Nov 2006 18:21:29


It's not my money, it's my customers! You and I know that ?00 is a
pittance with which to pay homage to dostats! But customers generally
neither know nor care about update stats and won't understand the need.
Especially as I should have thought of it months ago when the kit was first
bought!
 
 
 

dostats on AIX with gcc

Post by Obnoxio Th » Wed, 15 Nov 2006 18:30:35


Neil Truby said:

Ah. So we're sparing your blushes now, are we?

--
Bye now,
Obnoxio

"... no bill is required as no value was provided."
-- Christine Normile

--
This message has been scanned for viruses and
dangerous content by OpenProtect( http://www.yqcomputer.com/ ), and is
believed to be clean.
 
 
 

dostats on AIX with gcc

Post by Neil Trub » Wed, 15 Nov 2006 18:40:38


Either that or my money!
 
 
 

dostats on AIX with gcc

Post by Jonathan L » Thu, 16 Nov 2006 15:51:17


Well, the first step is to take a copy of the esql script from
$INFORMIXDIR/bin, and sanitize it so it works with GCC instead of xls.

That means remove -qlanglevel=ansi or whatever other options GCC
complains about.

Then, when you've demonstrated you can compile and run simple ESQL/C
programs using the hacked esql script, you can consider trying to
compile dostats with it.

If you need a simple ESQL/C program, look for esqlbasic.ec in the
DBD::Informix source code.


--
Jonathan Leffler #include <disclaimer.h>
Email: XXXX@XXXXX.COM , XXXX@XXXXX.COM
Guardian of DBD::Informix v2005.02 -- http://www.yqcomputer.com/
 
 
 

dostats on AIX with gcc

Post by Neil Trub » Thu, 16 Nov 2006 17:56:54


Thanks. I actually gave up and compiled dostats on a Linux server and ran
it remotely from there. Never could find, even from Google, what libmsaa
is.
 
 
 

dostats on AIX with gcc

Post by June C. Hu » Thu, 16 Nov 2006 22:50:02


Someday, if you find the time, you might want to take a look at the
'Scripts' area at www.oninit.com for an 'ESQLC for GCC/AIX' script. While
your solution worked, if you are anything like me, I wouldn't be able to let
it go at that. I do admit that I have been called stubborn - once or twice.
:-)

June
 
 
 

dostats on AIX with gcc

Post by Paul Watso » Thu, 16 Nov 2006 22:55:48

[cutting]


While I'd love to take all the credit for the script, the basic script
was
JLs, and since then it's been tweaked by a few people


Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com

GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend IDUG 2007 San Jose, North America
May 6-10, 2007
Visit http://www.yqcomputer.com/
 
 
 

dostats on AIX with gcc

Post by Carsten Ha » Thu, 16 Nov 2006 23:06:11


Is there a reason I don't see why Neil couldn't simply preprocess-only
the file with "esql -e" and then manually compile/link the resulting .c
file with gcc?

-Carsten
 
 
 

dostats on AIX with gcc

Post by Art S. Kag » Thu, 16 Nov 2006 23:30:32


Oh, sure, propose a completely logical solution! Who asked you? ;-}

Seriously though, it's not THAT simple. The steps would be (assuming ksh or
bash):

esql -e dostats.ec
gcc -o dostats dostats.ec -L$INFORMIXDIR/lib/esql -L$INFORMIXDIR/lib $(esql
-libs )

You need the esql/c library list to link.

Art S. Kagel
 
 
 

dostats on AIX with gcc

Post by Art S. Kag » Thu, 16 Nov 2006 23:30:32


Oh, sure, propose a completely logical solution! Who asked you? ;-}

Seriously though, it's not THAT simple. The steps would be (assuming ksh or
bash):

esql -e dostats.ec
gcc -o dostats dostats.ec -L$INFORMIXDIR/lib/esql -L$INFORMIXDIR/lib $(esql
-libs )

You need the esql/c library list to link.

Art S. Kagel