ADDDB2


ADDDB2 is a Data Collector command. You can issue the ADDDB2 command only from the following places:

  • Command text area of the Data Collector Command Interface panel (DOMECMDA)
  • System operator console

Use ADDDB2 to temporarily access a Db2 subsystem that is not defined in the DOMPLEX option set. The Db2 subsystem is added to the list of Db2 subsystems that the specified Data Collector can monitor.

The default parameters from the DOMPLEX option set are used, but the Db2 subsystem is not added to the list of Db2 subsystems in the DOMPLEX option set. It remains available for use until it is deleted using the DELDB2 command or until the Data Collector is cycled.

GUID-F20313B6-9A5F-4E95-841D-2C6DCC52FDD4-low.png

Parameter

Description

DCssid

Subsystem ID of the Data Collector to which the Db2 subsystem is being added. Use this parameter only when you issue 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.

DB2ssid

(Required) Subsystem ID of the Db2 subsystem being added.

planName

Apptune and SQL Performance

(Optional) The name of the plan that this Db2 uses for Dynamic Explain. The plan must match the plan name specified in the $740INST job that was run against this Db2.

You must run job $740INST on every Db2 on which you intend to use the dynamic Explain function.

 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*