modify-db-config

Modifies the common database connection configuration.

modify-db-config 
[-c value | --configuration=value] 
[-b value | --bootstrap-config=value] 
[-l value | --login-timeout=value] 
[-o value | --connection-timeout=value]
[-i value | --min-connections=value] 
[-a value | --max-connections=value] 
[-p value | --pooling-scheme=value]
[-q value] 
{-Ckey=value} 
[-e <true|false> | --clear-connection-properties=<true|false>]

Overview

Use this command to modify the common configuration for the connection to the Spotfire Server database. This configuration (which affects all servers) is merged with the configuration in the bootstrap.xml file on each server.

Options


Option	Optional or Required	Default Value	Description
`-c value --configuration=value`	Optional	configuration.xml	The path to the server configuration file.
`-b value --bootstrap-config=value`	Optional	none	The path to the bootstrap configuration file. See Bootstrap.xml file for more information about this file.
`-l value --login-timeout=value`	Optional	none	The maximum time (in seconds) to wait for a connection to become available.
`-o value --connection-timeout=value`	Optional	none	The maximum time (in seconds) that a connection can stay idle in the connection pool before being closed and discarded.
`-i value --min-connections=value`	Optional	none	The minimum number of connections to keep in the connection pool.
`-a value --max-connections=value`	Optional	none	The maximum number of connections to keep in the connection pool.
`-p value --pooling-scheme=value`	Optional	none	The connection pooling algorithm to be used. Valid values are: `WAIT`: The `--max-connections` parameter is strictly respected. `DYNAMIC`: The number of connections can occasionally exceed the configured maximum number.
`-q value`	Optional	none	An SQL query that should be run directly after a connection has been created.
`-Ckey=value`	Optional	none	A JDBC connection property that is added to the existing list of connection properties. Several properties can be specified. (Can be specified multiple times with different keys.)
`-e <true\|false> --clear-connection-properties=<true\|false>`	Optional	false	Clears the existing list of connection properties.

Examples

Setting the maximum number of connections in the pool:

config modify-db-config  --max-connections=100

Setting the pooling scheme:

config modify-db-config  --pooling-scheme=WAIT

Setting the size of the statement pool of the DataDirect driver:

config modify-db-config  -CMaxPooledStatements=20