for the sysmaster gurus

Hi Friends 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 Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting KandooERP Founder and CTO 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

Eric: Looking at my own system, the xflags column seems to always be zero and the bflags column does not seem to correspond to the type of page in the buffers. You may have to map the dbspace, chunk, and offset to the sysextents rows of every object and categorize based on whether the sysptnhdr row for that object has nrows = 0, nkeys = 1, and npdata = 0 (index partitions the only indicator that an object may not be a table partition). Though be careful of empty tables. An empty table with one attached index will look the same as a detached or semi-attached index, but probably will have not presence in the buffers anyway. Only legacy tables (those created prior to v7.30) and catalog tables typically have fully attached indexes anyway. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

Thanks Art, I was coming to some conclusion like this. That may explain why onstat -P takes forever on large buffer pools .... Cheers Eric Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting KandooERP Founder and CTO 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