Derby data source configuration

Use this information to create and configure a Derby data source.

Table 1. General settings for Derby data source window
Window element	Description
Data Source Name	Enter a unique name to identify the data source. You can use only letters, numbers, and the underscore character in the data source name. If you use UTF-8 characters, make sure that the locale on the Impact Server where the data source is saved is set to the UTF-8 character encoding.
Username	Type a user name with which you can access the database.
Password	Type a password that allows you access to the database. As you type, the characters are concealed by asterisks (*).
Maximum SQL Connection	For maximum performance set the size of the connection pool as greater than or equal to the maximum number of threads that are running in the event processor. Important: Changing the maximum connections setting in an SQL data source requires a restart of the Impact Server. For information about viewing existing thread and connection pool information, see the information in the Netcool/Impact Administration in the section Command-Line tools, Event Processor commands. See the Select PoolConfig from Service where Name='EventProcessor'; Important: In a clustered environment, the event processor configuration is not replicated between servers. You must run the Select PoolConfig from Service where Name='EventProcessor'; command on the primary and the secondary servers. Limiting the number of concurrent connections manages performance. Type the maximum number of connections that are allowed to the database at one time. That number must be greater than or equal to the number of threads that are running in the Event Processor. See Configuring the Event processor service.
Database Failure Policy	Select the failover option. Available options are Fail over and Disable Backup. The Fail back option is not supported for Derby databases. For more information about failover options, see SQL database DSA failover modes.

Table 2. Primary source settings for Derby data source window
Window element	Description
Host Name	Type the host name. The default value is `localhost`.
Port	Select a port number. The default number is `1527`.
Database	Type the name of the database to connect to. The default database is `database`.
Test Connection	Click to test the connection to the host to ensure that you entered the correct information. Success or failure is reported in a message box. If the host is not available at the time you create the data source, you can test it later. To test the connection at any time, from the data source list, right-click the data source and select Test Connections from the list of options.

Table 3. Backup source settings for Derby data source window
Window element	Description
Host Name	Type the host name. The default value is `localhost`.
Port	Select a port number. The default value is `1527`.
Database	Type the name of the database to connect to. The default database is `database`.
Test Connection	Click to test the connection to the host to ensure that you entered the correct information. Success or failure is reported in a message box. If the host is not available at the time you create the data source, you can test it later. To test the connection at any time, from the data source list, right-click the data source and select Test Connections from the list of options.