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 ALTER and BMC AMI Change Manager for Db2 13.1.

-RNST (IBM RUNSTATS utility)

The -RNST command invokes the IBM RUNSTATS utility on table spaces or indexes.

The -RNST command can be processed in parallel. For more information about the worklist parallelism feature of the BMC Database Administration for DB2 and BMC AMI Database Administration for Db2 solutions, see Using-worklist-parallelism.

Note the following items when the -RNST command is used in a worklist:

  • The utility command starts on the second line of the statement. The first line is reserved for parameters that are passed to the utility.

  • If a table space has been rebuilt or has tables that are rebuilt or added, Analysis creates a -RNST command for the table space. If the table space is created explicitly, the command is executed as shown in the following example:

    -RNST 004450
                   RUNSTATS TABLESPACE KIF8D22A.MAF8S22E
                            HISTORY NONE
                            INDEX (ALL)
                            KEYCARD
  • If the table space is created implicitly, the command text is preceded with the character T. Execution looks up the table space name during processing and substitutes it for the table name before invoking the utility. This command might also be used due to referential integrity considerations.
  • If the Db2 catalog history tables will be updated with all of the statistics that have been collected, Analysis adds the HISTORY ALL parameter to the command. Conversely, if the history tables will not be updated, Analysis adds the HISTORY NONE parameter to the command.
  • If an index is created or rebuilt for a table space that had no table changes, Analysis creates a -RNST command for the index.

  • If Db2 created XML or LOB objects implicitly, the -RNST command includes the following parameters:

    • XMLTBO or LOBTBO, which identifies the owner of the table
    • XMLTBN or LOBTBN, which identifies the name of the table
    • XMLCOL or LOBCOL, which identifies the name of the XML or LOB column

    The RUNSTATS command syntax also includes the name of the XML or LOB table space that supports the XML or LOB column in the base table.

For more information, see the IBM documentation.

Related topic

Worklist-commands



 

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