What is the content of a database properties file?

Contents of the configureDB.properties file.

You can use properties files for providing input to the configureDB command without typing parameters in the command line when creating the database for the master domain manager and Dynamic Workload Console.

Consider the following example for the master domain manager database:

#This properties are the default for configureDb.sh command in configureDb.template file
#This properties are the input  for configureDb.sh command with -f option in configureDb.propeties file
#N.B.configureDb.template must not be changed, while configureDb.propeties can be changed when using -f option

#--lang language: C|en|de|es|fr|it|ja|ko|pt_BR|ru|zh_CN|zh_TW
LANG=

#--work_dir Working directory where user has write access. Used to modify input file for the db tool (optional, default: see below)
WORK_DIR=

#--log_dir Working directory where user has write access. Used to log (optional, default: see below)
CONFDB_LOG_DIR=

#--rdbmstype|-r The rdbmstype:      DB2 | ORACLE | MSSQL | POSTGRESQL
RDBMS_TYPE=

#--componenttype The IWS component that must be installed: MDM, BKM, DDM or BDM (default: see below)
COMPONENT_TYPE=MDM

#--dbdriverpath
DB_DRIVER_PATH=

#--dbname The name of IWS Database (default: see below)
DB_NAME=TWS

#--dbhostname The host name or IP address of DB server
DB_HOST_NAME=

#--dbport The port of the DB server
DB_PORT=50000

#--dbadminuser DB administrator user that creates the IWS schema objects on the DB server
DB_ADMIN_USER=db2admin

#--dbadminuserpw The password of the DB administrator user that creates the IWS schema objects on the DB2 server
DB_ADMIN_USER_PWD=

#--dbuser DB user that accesses the IWS tables on the DB server
DB_USER=db2tws

#--dbpassword DB user that accesses the IWS tables on the DB server
DB_PASSWORD=

#--wlpdir|-w wlp directory needed only if any password in input is encrypted and has the form {xor}password
WLP_INSTALL_DIR=

#--iwstsname The name of the tablespace for IWS data (default: see below)
IWS_TS_NAME=TWS_DATA

#--iwstspath The path of the tablespace for IWS data (default: see below)
IWS_TS_PATH=TWS_DATA

#--iwslogtsname The name of the tablespace for IWS log (default: see below)

#--iwslogtspath The path of the tablespace for IWS log (default: see below)
IWS_LOG_TS_PATH=TWS_LOG

#--iwsplantsname The name of the tablespace for IWS plan (default: see below)
IWS_PLAN_TS_NAME=TWS_PLAN

#--iwsplantspath The path of the tablespace for IWS plan (default: see below)
IWS_PLAN_TS_PATH=TWS_PLAN

# Automatically apply the generated SQL statements needed to create the IWS database schema objects (Default: TRUE)
# If you want manually apply the generated statement in ./customSQL.sql file, set FALSE.
#--execsql
EXEC_GENERATED_SQL=TRUE

# --------------------------------
# needed for SSL
# --------------------------------
#  Configuration options when customized certificates are used for SSL connections:
#--sslkeysfolder        The name and path of the folder containing certificates in PEM format.
#                       This parameter is required if you set the --dbsslconnection parameter to true.
SSL_KEY_FOLDER=
#--sslpassword          If you provide PEM certificates with the --sslkeysfolder parameter, this is the password for the certificates automatically generated by the installation program.
SSL_PASSWORD=
# --------------------------------
# needed for SSL  unix only
# --------------------------------
#--dbsslconnection       true | false  (DB2 only)
DB_SSL_CONNECTION=false

Consider the following example for the Db2 database for the Dynamic Workload Console:

#This properties are the default for configureDb.sh command in configureDb.template file
#This properties are the input  for configureDb.sh command with -f option in configureDb.propeties file
#N.B.configureDb.template must not be changed, while configureDb.propeties can be changed when using -f option

#--lang language: C|en|de|es|fr|it|ja|ko|pt_BR|ru|zh_CN|zh_TW
LANG=

#--work_dir Working directory where user has write access. Used to modify input file for the db tool (optional, default: see below)
WORK_DIR=

#--log_dir Working directory where user has write access. Used to log (optional, default: see below)
CONFDB_LOG_DIR=

#--rdbmstype|-r The rdbmstype:      DB2 | DB2Z | ORACLE | MSSQL | POSTGRESQL
RDBMS_TYPE=DB2

#--componenttype The DWC component that must be installed: DWC
COMPONENT_TYPE=DWC

#--dbdriverpath
DB_DRIVER_PATH=

#--dbname  The name of DWC Database (default: see below)
DB_NAME=TDWC

#--dbhostname The host name or IP address of DB server
DB_HOST_NAME=<my_DB_host>

#--dbport The port of the DB server
DB_PORT=50000

#--dbadminuser DB administrator user that creates the IWS schema objects on the DB server
DB_ADMIN_USER=db2admin

#--dbadminuserpw The password of the DB administrator user that creates the DWC schema objects on the DB2 server
DB_ADMIN_USER_PWD=<database_administrator_password>

#--dbuser DB user that accesses the DWC tables on the DB server
DB_USER=db2dwc

#--dbpassword DB user that accesses the DWC tables on the DB server
DB_PASSWORD=database_password

#--wlpdir|-w wlp directory needed only if any password in input is encrypted and has the form {xor}password
WLP_INSTALL_DIR=<WebSphere Application Server
                        Liberty_installation_directory>

#--iwstsname The name of the tablespace for data (default: TWS_DATA)
IWS_TS_NAME=TWS_DATA

#--iwstspath The path of the tablespace for data (default: TWS_DATA)
IWS_TS_PATH=TWS_DATA

# Automatically apply the generated SQL statements needed to create the DWC database schema objects (Default: TRUE)
# If you want manually apply the generated statement in ./customSQL.sql file, set FALSE.
#--execsql
EXEC_GENERATED_SQL=TRUE

# --------------------------------
# needed for SSL
# --------------------------------
#  Configuration options when customized certificates are used for SSL connections:
#--sslkeysfolder        The name and path of the folder containing certificates in PEM format.
#                       If you provide PEM certificates, the installation program generates the keystore and truststore files using the password you specify with the --sslpassword parameter.
#                       This parameter is required if you set the --dbsslconnection parameter to true.
SSL_KEY_FOLDER=
#--sslpassword          If you provide PEM certificates with the --sslkeysfolder parameter, this is the password for the certificates automatically generated by the installation program.
SSL_PASSWORD=
# --------------------------------
# needed for SSL  unix only
# --------------------------------
#--dbsslconnection       true | false  (DB2 only)
DB_SSL_CONNECTION=false