SETCONNECTIONCONFIGPROPERTIES stored procedure

Set, change or remove multiple configuration properties specifically for a Data Virtualization connection by specifying the properties and its value in the CSV format string. The schema is DVSYS.

Input parameters

CID: The type of this required parameter is VARCHAR(128). Specifies the Data Virtualization connection identifier.

CSV_PROPERTY_KEYS_VALUES: The type of this required parameter is VARCHAR(32672). Specifies properties as comma-separated key=value pairs. To delete a property, provide only the property name (omit =value in the CSV input string).

Output parameters

NUMNODESUPDATED: The type of this parameter is INTEGER. Represents the number of nodes updated.
Note: Only Data Virtualization-specific properties are applied to the node (agent) during the update process. As a result, if the input includes only federation-specific properties, then the value of NUMNODESUPDATED will be 0. However, the specified property still updates successfully in the SYSCAT.SERVEROPTIONS catalog table.

DIAGS: The type of this parameter is VARCHAR(32672). Represents the diagnostic output in the case a failure occurs.

Syntax

Use the following syntax and replace the parameters for this stored procedure:

CALL DVSYS.SETCONNECTIONCONFIGPROPERTIES('<CID>', '<PROPERTY1>=<VALUE1>,<PROPERTY2>=<VALUE2>', ?, ?);

Example

The following example updates MIN_POOLSIZE to 7 and MAX_POOLSIZE to 22:

CALL DVSYS.SETCONNECTIONCONFIGPROPERTIES('ORACL10000', 'MIN_POOLSIZE=7,MAX_POOLSIZE=22', ?, ?);

The following example deletes MIN_POOLSIZE and updates MAX_POOLSIZE to 25:

CALL DVSYS.SETCONNECTIONCONFIGPROPERTIES('ORACL10000', 'MIN_POOLSIZE,MAX_POOLSIZE=25', ?, ?);