Informix

  • 1.  for the sysmaster gurus

    Posted Fri September 03, 2021 06:45 AM

    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
    ibm-champion-rgb-130px

    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

     

     



  • 2.  RE: for the sysmaster gurus

    Posted Fri September 03, 2021 08:07 AM
    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
    ------------------------------



  • 3.  RE: for the sysmaster gurus

    Posted Fri September 03, 2021 09:45 AM

    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
    ibm-champion-rgb-130px

    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