Database server

The database server is used by the HCL Docs components to store and retrieve session information while the documents are being edited as well as other information needed by HCL Docs.

General information

  • The Database Version and Operating System fields help provide information to Support or to those helping with the deployment to ensure that the supported databases and proper versions are being used.
  • The Server and Server Port fields specify the database server hostname and port for the database instance used. These values are used in the HCL Docs server configuration file.
  • The Database Installation Directory and OS Account for Install fields are the installation location of the database and the user doing the installation.
  • During the installation of HCL Docs, one of the configuration parameters for the HCL Docs server is the location of the database JDBC drivers that were copied over from the database server to a local path on the HCL Docs server. The Remote Server JDBC Directory field is this local path on the HCL Docs server to which these files will be copied. This value is also used in the HCL Docs server configuration file.
Table 1. Database server parametersThis table provides suggested default values pertaining to the database server.

Field Name Parameter
Database Version IBM® DB2® v10.1
Operating System Windows 2008 R2 SP1
Server VHOST_ConnectionsDB, for example, ConnectionsDB.renovations.com
Service Port VPORT_ConnectionsDB, for example, 50000
Database Installation Directory DB2_INSTALL_PATH_LINUX, for example, /opt/IBM
OS Account for install Administrator
Remote Server JDBC Directory (contains db2jcc4.jar and db2jcc_license_cu.jar for DB2®, and ojdbc6.jar for Oracle) JDBC_DRIVER_PATH_LINUX, for example, /opt/IBM/SQLLIB

Database credentials

There are two sets of users that are potentially needed to install the database tables needed by HCL Docs. The DB2 Instance Owner field is for the user that has access to the database instance that will be used during the creation of the HCL Docs database and the DB2 User field is for the user that the HCL Docs application will use when accessing the database.

Table 2. Database credential parametersThis table provides suggested default values for the two sets of users who install the databases.

The rows list the user fields. The columns provide the user name, group, and password for each user.

User name Group Password
DB2 Instance Owner DB2INSTOWNER_USERNAME, for example, db2admin DB2INSTOWNER_GROUPNAME, for example, DB2ADMNS DB2INSTOWNER_PASSWORD, for example, password
DB2 User DBA_USERNAME, for example, lcuser DB2INSTOWNER_GROUPNAME, for example, DB2ADMNS DBA_PASSWORD, for example, password

Networking (load balancer):

If there is a load balancer for the database server, you need to specify the value in the Virtual Address:Port field in the HCL Docs configuration files during installation. If there is no load balancer, use theTarget Server:Port field.

Table 3. Networking parametersThis table provides suggested default ports.

Field Parameter
Virtual Address:Port VHOST_ConnectionsDB, for example, ConnectionsDB.renovations.com:50000
Target Server:Port DocsLab01.renovations.com:VPORT_ConnectionsDB, for example, 50000