Db2 (On Premises and Cloud)

Expand all | Collapse all

DMC 3.1.4 monitoring profile settings : exact meaning of 'table data read for a collection'

  • 1.  DMC 3.1.4 monitoring profile settings : exact meaning of 'table data read for a collection'

    Posted Wed May 26, 2021 07:45 AM
    Hello ,

    This is a kind of back-to-basics question but could somebody explain what is meant by 'table data read for a collection' when editing a DMC monitoring profile ?
    KC does not elaborate a lot on this :


    How does this parameter relates with both package cache and locks ?

    Best regards

    Filip

    ------------------------------
    filip degryse
    ------------------------------


  • 2.  RE: DMC 3.1.4 monitoring profile settings : exact meaning of 'table data read for a collection'

    Posted Thu May 27, 2021 02:25 AM
    Hi Filip,

    The parameter limits the number of records copied to the repository for each collection period.  e.g. if there are > 1000 records collected from package cache for the 5 minutes interval, only 1000 rows will be copied to the repository.  Same goes for Locks.

    Thanks.

    ------------------------------
    Jason Sizto
    ------------------------------