Customized product setup

Set up IBM® Db2® Data Management Console with customized product settings by editing the setup.conf file and running the script installation setup program.

To set up IBM Db2 Data Management Console with a custom configuration:

1. Edit the setup.conf file to specify your configuration preferences.

   The setup.conf file is stored in the setup_directory/ibm-datamgmtconsole directory where you extracted the product files.

   Uncomment parameters, specify values, or update the default values for the following parameters as needed.

   Option	Description
   Base: Basic configuration parameters	product.license Uncomment this parameter to indicate that you have read the license text in the setup_directory/ibm-datamgmtconsole/Config/product/enterprise directory and that you accept its terms. http.port The port that is used to access the IBM Db2 Data Management Console web console from a web browser. https.port The secure port that is used to access the IBM Db2 Data Management Console web console from a web browser. admin.user The default administrator user ID that will be used to administer the product. The user ID is specific to the product and is independent of operating system user IDs. admin.password The encrypted password for the default administrator user ID. To encrypt the password, use the crypt utility: Linux®, UNIX and MAC : setup_directory/ibm-datamgmtconsole/dsutil/bin/crypt.sh <password> Windows: setup_directory/ibm-datamgmtconsole/dsutil/bin/crypt.bat <password>
   Repository database parameters (optional)	repositoryDB.host The repository database host name or IP address repositoryDB.port The port number for the repository database. repositoryDB.databaseName The name of the repository database repositoryDB.user The repository database user ID with administrator privileges repositoryDB.password The password for the repository database user ID. To encrypt the password, use the crypt utility: Linux, UNIX and MAC : setup_directory/ibm-datamgmtconsole/dsutil/bin/crypt.sh <password> Windows: setup_directory/ibm-datamgmtconsole/dsutil/bin/crypt.bat <password> repositoryDB.securityMechanism Additional JDBC properties that are used to connect to the repository database.

2. Optional: Edit the bootstrap.properties file to specify job-scheduler port.

   <dmc_install_location>/wlp/usr/servers/dsweb/bootstrap.properties 

   The port number for job-scheduler add-on is job.http.port . The default value is 11088.

3. Run the setup program.
   • Windows: Run the setup program as a user with Administrator privileges:
     setup_directory/ibm-datamgmtconsole/setup.bat-silent
   • Linux, UNIX, and Mac: Run the setup program as a user with write privilege to the setup_directory directory:
     setup_directory/ibm-datamgmtconsole/setup.sh-silent
     Note: To run the setup program on Linux and AIX® machines, both the root user and non-root user can run the setup utility, but the user must have write access to the setup_directory directory.
4. Verify that the repository database was correctly configured. If you included the repository database information as part of setup.conf file, the database is now configured to use as a IBM Db2 Data Management Console repository. Before you log in to the web console you should verify that the database is correctly configured.
   1. On the repository database server, connect to the repository database and then run the validate.sql script. The script is in the setup_directory/ibm-datamgmtconsole/samples/DB2LUW directory.
   2. Verify that no SQL errors are returned. If SQL errors are returned, address them and then run the validate.sql script again.