BMC AMI Stats requirements and restrictions

This topic describes BMC AMI Stats requirements and restrictions:

Requirements

BMC AMI Stats requires the following authorizations:

Related topics

Getting-started-with-BMC-AMI-Stats

Overview-of-BMC-AMI-Stats

  • For the database, STATS authority
  • One of the following administrator authorities:
    • SYSADM
    • SYSOPR
    • DBADM
    • DBCTRL
    • DBMAINT

Restrictions

BMC AMI Stats has the following restrictions:

  • Does not support the PART keyword
  • Does not support sampling
  • Does not support Indexes in RBDPM status
  • Does not collect SPACE statistics in SYSTABLEPART when you run the product on an object that has no partitioning index
  • Does not collect:
    • Histogram statistics
    • Statistics for table spaces that have a restricted Db2 state
    • Db2 compression statistics (PCTROWCOMP and PAGESAVE)
    • LOB objects
    • XML objects
    • CLONE objects
    • Multi-table simple table spaces
    • HASH tables   
    • Clone table spaces or table spaces with an instance qualifier of 2

  • BMC AMI Stats supports partition-by-range (PBR) and partition-by-growth (PBG) table spaces with partition sizes (DSSIZE) greater than 64 GB except for the following PAGESIZE and DSSIZE combinations: 

    PAGESIZE

    DSSIZE

    4 KB

    128 GB

    256 GB

    8 KB

    256 GB

 

  • 13.1
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*