Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Stats for Db2 13.1.

Requirements and restrictions for BMC AMI Stats

This topic describes BMC AMI Stats requirements and restrictions:

Requirements

BMC AMI Stats

 requires the following authorizations:

  • 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 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

  • (PTF BQU2620 not applied) 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



Related topics

Getting started

Overview-of-BMC-AMI-Stats

 

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