Informix OLTP benchmark

Hi, is there any tool available for benchmarking / comparing different servers? I'm reading about BenchmarkSQL used by the fasted DBA contest... But i can't find the fork that supports informix. Thx. ------------------------------ Josef Albert ------------------------------ #Informix

Hi Josef, I have put a 'simili-tpc-c benchmark available in the IIUG Repository on sourceforge. It is exactly done for that purpose You need IDS and CSDK and gcc, because the bench is written in ESQL/C Please private me if interested Eric

Hi Eric, i forget to say that the benchmark will run under windows. Is this possible? Thanks. ------------------------------ Josef Albert ------------------------------

Hi Josef, I never tested on Windows, but since ESQL/C can work on windows, theory says it should work. Best would be to install a gcc compiler on windows, that would probably avoid library issues. Regards Eric

Hello. Simple benchmarks can also be made using jmeter. HTH Alexandre Marini

Hi, are there any example sql scripts available for the benchmark? Like this: (Appendix) https://www.ibm.com/developerworks/data/library/techarticle/dm-1104tuneinformix1/index.html Unfortunately i can't find the database used in this example. ------------------------------ Josef Albert ------------------------------

It's all the source code You can find it there https://sourceforge.net/projects/iiug-software-repository/files/ESQL/tpc-c-ifmx/ Eric Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting KandooERP Founder and Community Manager IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020 Tel: +33(0) 298 51 3210 Mob : +33(0)626 52 50 68 skype: begooden-it Google Hangout: eric.vercelletto@begooden-it.com Email: eric.vercelletto@begooden-it.com www : http://www.vercelletto.com www https://kandooerp.org

Josef: The Informix port of the open source SQLBenchmark software used by Advanced DataTools Corp. for the Fastest DBA Contests was done by a third party who doesn't want it published. In addition to Eric's benchmark package, you might also want to look at iReplay from Exact-Solutions ( Home | Exact Solutions, Inc ). You use it to take a snapshot of actual production activity for a period of time (an hour, a day, etc.) which can then be replayed against a restored copy of the database's state at the start of the snapshot to get a performance baseline. Then you can tune that test engine, upgrade the version, migrate it to a new platform, and test again to see how those changes affect performance! Not inexpensive, but a far better indication of actual performance effects of different tuning settings, Informix versions, OS versions, hardware systems, etc. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

As you are testing the engine you could still run the 'Benchmark' from a Linux machine. Yes, you now have network load but you have no CPU 'Benchmark' load Cheers Paul

Folks, I would love to get the current version of BenchmarkSQL working with Informix. Any Java programmers who would like to work on this, please let me know. I don't know Java but I think it would be fairly easy. AGS did the original port for Informix over 10 years ago and it had worked great but they ask me to remove it from our website. And because it is Java it runs on Windows, Unix, Linux, and Mac OSX. Here is a YouTube clip from 8 years ago - https://youtu.be/ScDyRrsI3H4 Cheers. - Lester #Informix

Hi Lester, I've been able to run the latest benchmarksql software against informix and I can share my findings shortly. Will try to provide more info today and share links with you. Best Regards, Michal ------------------------------ Michał Łukaszewicz ------------------------------

Hi again, here it is https://github.com/brvlant/benchmarksql It is based on version 5. Enjoy In case you have any questions, please ping me somewhere here ..and yes, this is much different than benchmarksql used by ADT. BR, Michal ------------------------------ Michał Łukaszewicz ------------------------------

Awesome, thank you #Informix

Thank you, i'll try it. :) ------------------------------ Josef Albert ------------------------------

I have plan to do the benchmark testing on Power8 and Power 10 with informix. and I will try to use those ESQL/C program you provide. I migh need your help or suggestion. thanks. ------------------------------ chuan lu ------------------------------