Informix

nested-group-icon.png

DB2

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


  • 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 Josef Albert Thu December 17, 2020 06:25 AM

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



  • 9.  RE: Informix OLTP benchmark

    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

     






  • 10.  RE: Informix OLTP benchmark

    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



    ------------------------------
    Lester Knutsen
    President and Principal Database Consultant
    Advanced DataTools Corporation
    ------------------------------



  • 11.  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
    ------------------------------



  • 12.  RE: Informix OLTP benchmark

    Posted 30 days ago

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



  • 13.  RE: Informix OLTP benchmark

    Posted 30 days ago

    Awesome, thank you



    ------------------------------
    Lester Knutsen
    President and Principal Database Consultant
    Advanced DataTools Corporation
    ------------------------------



  • 14.  RE: Informix OLTP benchmark

    Posted 28 days ago

    Thank you, i'll try it. :)



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