How to I emulate 'onstat -P' ( capital P ) with a sysmaster table ?
I mainly want to know how many buffers used for table pages, btree pages and 'other'
I bet I have to query sysbufhdr and work with hex(bflags) but I did not find documentation on those flags
Or do I need another table ?
Thanks in advance
Eric VercellettoData Management Architect and Owner / Begooden IT ConsultingKandooERP Founder and CTOIBM 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
I was coming to some conclusion like this. That may explain why onstat -P takes forever on large buffer pools ....