Creating the databases without running the provided scripts
If you used the cp4a-prerequisites.sh script to generate the
database SQL statement files (scripts) and YAML template files for the database secrets, then you do
not need to create these resources and apply them again.
About this task
Tip: When you use the cp4a-prerequisites.sh script, you must review
the requirements in the documented steps to create a database. Make sure that the databases that you
create satisfy your intended workload.
For more information about running the cp4a-prerequisites.sh script, see Recommended: Preparing databases and secrets for your chosen capabilities by running a script.
Business Automation Navigator requires a configuration database. If you are using Navigator with FileNet Content Manager, the databases or data sources must be separate.
The database details are captured in the custom resource file in the following
parameters:
dc_icn_datasource:
dc_database_type: "<Required>"
dc_common_icn_datasource_name: "ECMClientDS"
database_servername: "<Required>"
database_port: "<Required>"
database_name: "<Required>"
database_ssl_secret_name: "<Required>"
dc_oracle_icn_jdbc_url: "<Required>"
navigator_configuration:
icn_production_setting:
icn_jndids_name: ECMClientDS
icn_schema: ICNDB
icn_table_space: ICNDB
If you are configuring a Db2 HADR database for your IBM Business Automation Navigator, use the
dc_icn_datasource section of the custom YAML to provide values. Example
settings are:
dc_icn_datasource:
dc_database_type: "db2HADR"
dc_hadr_validation_timeout: 15
dc_hadr_standby_servername: "10.1.0.17"
dc_hadr_standby_port: "30352"
dc_hadr_retry_interval_for_client_reroute: 15
dc_hadr_max_retries_for_client_reroute: 3
For more information about the settings, see Datasource parameters.
When the Navigator deployment first starts, Navigator checks whether the configuration database schema and tables are present. If not, Navigator runs the necessary SQL commands to create them.