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 following objects:

  • 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

Syntax of the REFRESH command

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

Parameter

Description

DCssid

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

User authorization tables for the specified (or currently selected) Data Collector are rebuilt from the Db2 catalog. They are rebuilt using direct I/O (not SQL).

Rebuilding is required after a GRANT for user trace/command authority when Db2 security is 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

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

ALL

Indicates that the authorization tables for all Db2 subsystems 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*