Informix

 View Only
Expand all | Collapse all

Informix OLTP benchmark

  • 1.  Informix OLTP benchmark

    Posted Thu December 17, 2020 02:14 AM

    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


  • 2.  RE: Informix OLTP benchmark

    Posted Thu December 17, 2020 02:56 AM

    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

     

     

     






  • 3.  RE: Informix OLTP benchmark

    Posted Thu December 17, 2020 04:14 AM

    Hi Eric,

    i forget to say that the benchmark will run under windows.
    Is this possible?

    Thanks.



    ------------------------------
    Josef Albert
    ------------------------------



  • 4.  RE: Informix OLTP benchmark

    Posted Thu December 17, 2020 04:42 AM

    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

     






  • 5.  RE: Informix OLTP benchmark

    Posted Thu December 17, 2020 05:02 AM
    Hello.
    Simple benchmarks can also be made using jmeter.

    HTH
    Alexandre Marini





  • 6.  RE: Informix OLTP benchmark

    Posted Thu December 17, 2020 06:22 AM
    Edited by System Fri January 20, 2023 04:31 PM

    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
    ------------------------------



  • 7.  RE: Informix OLTP benchmark

    Posted Thu December 17, 2020 06:27 AM

    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
    ibm-champion-rgb-130px

    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

     

     






  • 8.  RE: Informix OLTP benchmark

    Posted Sat May 06, 2023 02:04 AM

     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
    ------------------------------



  • 9.  RE: Informix OLTP benchmark

    IBM Champion
    Posted Thu December 17, 2020 08:15 AM

    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
    ------------------------------



  • 10.  RE: Informix OLTP benchmark

    IBM Champion
    Posted Thu December 17, 2020 06:12 PM

    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

     






  • 11.  RE: Informix OLTP benchmark

    IBM Champion
    Posted Thu December 17, 2020 06:32 PM

    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


  • 12.  RE: Informix OLTP benchmark

    Posted Fri December 18, 2020 04:30 AM

    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
    ------------------------------



  • 13.  RE: Informix OLTP benchmark

    Posted Fri December 18, 2020 05:39 PM

    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
    ------------------------------



  • 14.  RE: Informix OLTP benchmark

    IBM Champion
    Posted Fri December 18, 2020 05:47 PM

    Awesome, thank you



    #Informix


  • 15.  RE: Informix OLTP benchmark

    Posted Mon December 21, 2020 04:30 AM

    Thank you, i'll try it. :)



    ------------------------------
    Josef Albert
    ------------------------------