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.

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

The subsystem ID of the Data Collector for which the command reports the status. Use this parameter only when you are issuing the command from the console. When you issue the command from the Data Collector Command Interface panel, it automatically applies to the currently selected Data Collector.

DB2ssid

(Required) Subsystem ID of the Data Collector to which the product is 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*