Limited supportBMC 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 Pool Advisor for Db2 13.1.

REFRESH


REFRESH is a Data Collector command that you can issue only from the command text area of the Data Collector Command Interface panel (DOMECMDA) or the system operator console.

REFRESH is used to rebuild:

  • The product user authorization tables from the Db2 catalog
  • The trace data set indexes from all trace data sets of some or all output groups

GUID-B7B00758-BE22-4EA8-85B3-EF8091057919-low.png

Parameter

Description

DCssid

The subsystem ID of the Data Collector that owns the user authorization tables to be rebuilt, or the trace data set indexes to be rebuilt. Use this parameter only when issuing the command from the console. When the command is issued from the Data Collector Command Interface panel, it applies automatically to the currently selected Data Collector.

AUTH

The user authorization tables for the specified (or currently selected) Data Collector are rebuilt from the Db2 catalog. This is done using direct I/O (not SQL). It is needed after a GRANT for user trace/command authority when Db2 security is being used by this product (and ignored if product security is being used). To ensure correct results, invoke the DB2 QUIESCE utility for the SYSUSER table space before issuing the REFRESH command

DB2ssid

The subsystem ID of the Db2 subsystem that owns the authorization tables to be rebuilt.

ALL

Indicates that the authorization tables for all Db2 subsystems being monitored by the specified Data Collector are to be rebuilt.

You can find information about issuing commands from the Data Collector Command Interface panel in online Help (type HELP DOMECMDA).


 

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