Informix

 View Only
Expand all | Collapse all

How can I see in sysmaster if my instance is 'currently running a checkpoint'

  • 1.  How can I see in sysmaster if my instance is 'currently running a checkpoint'

    Posted Tue January 26, 2021 06:02 AM

    Hi Folks,

     

    I have tried looking into the sysmaster.sql file which is pretty well documented, but apparently my personal search engine is not efficient enough.

    I want to detect the 'Checkpoint In Progress' engine status with a query ( I know how to do it with onstat
    �� )

    I have found something like the engine status in some table, but not sure it tells about checkpoint in progress (or maybe a special undocumented value ).
    Any clue on how to get this info with a SQL query ?

     

    Thanks in advance, as always

     

    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

     

     


    #Informix


  • 2.  RE: How can I see in sysmaster if my instance is 'currently running a checkpoint'

    IBM Champion
    Posted Tue January 26, 2021 06:34 AM
    Hi Eric,

    try
    select * from sysshmhdr where name like "ckpt%";​


    BR,
     Andreas



    ------------------------------
    Andreas Legner
    ------------------------------



  • 3.  RE: How can I see in sysmaster if my instance is 'currently running a checkpoint'

    Posted Wed January 27, 2021 02:18 AM

    Works like a charm!

     

    Thanks bunches my friend!

     

    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