Production database worksheet
Use the following worksheet to record production database setup information. You will need this information during IBM® Control Center installation.
| Parameter | Database Type | Value |
|---|---|---|
| Database type Attention: Production 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. |
All | |
| Port number to access the database | All | |
| Location of the sqljdbc4.jar file | Microsoft SQL Server (2012 and 2014) | |
| 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 ojdbc7.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 10.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 IBM Control Center with DB2 databases, the JDBC driver files must come from the DB2 database location where IBM Control Center connects.