TIBCO Spotfire® Server and Environment - Installation and Administration

set-db-config

Sets the common database connection configuration.

set-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}

Overview

Use this command to set 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 10 The maximum time (in seconds) to wait for a connection to become available.
-o value
--connection-timeout=value
Optional 600 A comma-separated list of the library items (GUIDs) to download.
-i value
--min-connections=value
Optional 5 The minimum number of connections to keep in the connection pool.
-a value
--max-connections=value
Optional 40 The maximum number of connections to keep in the connection pool.
-p value
--pooling-scheme=value
Optional WAIT
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. Several properties can be specified.

Examples

To set the maximum number of connections in the pool:
config set-db-config  --max-connections=100
To set the pooling scheme:
config set-db-config  --pooling-scheme=WAIT
To set the size of the statement pool of the DataDirect driver:
config set-db-config   CMaxPooledStatements=20