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

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

Hi Eric, try select * from sysshmhdr where name like "ckpt%";BR, Andreas ------------------------------ Andreas Legner ------------------------------

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