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------------------------------
Original Message:
Sent: Fri September 03, 2021 06:45 AM
From: Eric Vercelletto
Subject: 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