Production database worksheet
Use the following worksheet to record production database setup information. You will need this information during Sterling Control Center installation.
| Parameter | Database Type | Value |
|---|---|---|
| Database type Note: Production, staging, and reports
databases must be of the same type and version.
|
All | |
| Database name | All | |
| User name | All | |
| Password | All | |
| Database hostname Can be an IP address or the server name. Note: For MS SQL Server 2005,
if you need to connect to a named instance of SQL server, use the
format servername;instancename. Example: CSGPQ2;SCCINSTANCE
|
All | |
| Port number to access the database | All | |
| Location of the sqljdbc4.jar | Microsoft SQL Server (2005 and 2008) | |
| Location of the db2jcc.jar file | DB2® (UNIX and Microsoft Windows) | |
| Location name of the DB2 database | DB2 (z/OS® or OS/390®) | |
| Location of the db2jcc.jar database driver | DB2 (z/OS or OS/390) | |
| Location of the DB2 database license file | DB2 (z/OS or OS/390, Microsoft Windows, UNIX) | |
| Location of the ojdbc14.jar, ojdbc5.jar, or ojdbc6.jar Oracle file | Oracle |
Note these points concerning the DB2 JDBC driver file:
- The DB2 JDBC driver files can be found in DB2InstallLocation\IBM\SQLLIB\java.
- DB2 version 9.x, type 4 driver. This driver comes with two files, dbjcc.jar and db2jcc_license_cu.jar (UNIX and Microsoft Windows) or db2jcc_license_cisuz.jar (z/OS or OS/390).
- When you use the JDBC driver to configure Sterling Control Center with DB2 databases, the JDBC driver files must come from the DB2 database location where Sterling Control Center will connect.