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 VercellettoData Management Architect and Owner / Begooden IT ConsultingKandooERP Founder and Community ManagerIBM Champion 2013,2014,2015,2016,2017,2018,2019,2020
Tel: +33(0) 298 51 3210Mob : +33(0)626 52 50 68skype: begooden-itGoogle Hangout: email@example.comEmail: firstname.lastname@example.org : http://www.vercelletto.comwww https://kandooerp.org
select * from sysshmhdr where name like "ckpt%";
Works like a charm!
Thanks bunches my friend!