Configuring a database server

TrueSight Server Automation works in conjunction with an Oracle or SQL Server database server. The installation program can configure the Application Server to communicate with this database. However, you can manually configure the Application Server to communicate with the database, as described in this procedure.

1. Start the Application Server Administration console, as described in Starting-the-Application-Server-Administration-console.
2. To specify a connection string for the database, enter the following:
   set database connectionstring "<ConnectionString>"
   where string is a string that specifies the database type, the server running the database, the port the database listens on, and SQL Server database name or Oracle SID. The connection string can use one of the following formats:
   • jdbc:oracle:thin:@DBSERVER:PORT:SID
   • jdbc:sqlserver://DBSERVER:PORT;DatabaseName=DBNAME;SelectMethod=cursor
      When using one of the formats shown above, do the following:
   • Replace DBSERVER with the name or IP address of the server running the database.
   • Replace DBNAME with the name of the database or replace <SID> with the Oracle SID.

   • Replace PORT with the port number the database is listening on. By default, a TrueSight Server Automation installation uses the following database ports:
3. To specify the driver class for the database, enter the following:
   set database driverclass <class>
    where <class>is the Java class used to communicate with the database. Depending on the type of database you are using, you can define the class with one of the following strings:
   • oracle.jdbc.driver.OracleDriver
   • com.microsoft.sqlserver.jdbc.SQLServerDriver

4. To specify the user ID and password for the database, enter the following two commands:
   set database userid <id> set database password ******
    where <id> is the user name that the database requires to authenticate your connection and ******** is the password assigned to that user ID.

   Note

   If you modify the TrueSight Server Automation database details (for example: server name, SID, or password), you must change the TrueSight Server Automation - Data Warehouse site context to use the modified details. For instructions on the changing the site context, see the TrueSight Smart Reporting for Server Automation documentation.

5. To specify a commit size for an Oracle database, enter the following:
   set database commitsize <size>
    where <size> is the maximum number of rows that can be updated in an Oracle database before you either have to commit your updates or roll them back. Commit size is primarily used when taking snapshots or performing audits in TrueSight Server Automation. A larger commit size means database processes execute more quickly, but at the same time you run the risk of losing more data if a database process fails.

   Tip

   Because Oracle databases can be highly tuned, consult your Oracle DBA to achieve best results when defining a commit size.

6. Restart the Application Server.