Wednesday 18 March 2015

IBM Business Process Manager Advanced 8.5.6 - Continuing the build-out

Following my earlier post: -


I'm now building out the configuration for my Process Center

I've taken one of the sample configuration files from here: -

/opt/IBM/WebSphere/AppServer/BPM/samples/config/advanced/Advanced-PC-ThreeClusters-DB2.properties

and amended it to meet my requirements ( I've attached my copy at the bottom of this post ).

I then used BPMConfig to create the Deployment Environment: -

su - wasadmin
/opt/IBM/WebSphere/AppServer/bin/BPMConfig.sh -create -de Advanced-PC-ThreeClusters-DB2.properties 

Logging to file /opt/IBM/WebSphere/AppServer/logs/config/BPMConfig_20150318-173858.log.
Validating the profile registry.
[]
Configuring the deployment manager.
Creating the deployment manager profile.
INSTCONFSUCCESS: Success: Profile Dmgr01 now exists. Please consult /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/logs/AboutThisProfile.txt for more information about this profile.
Starting deployment manager profile Dmgr01.
CWUPO0001I: Running configuration action detectNewProducts.ant
ADMU0116I: Tool information is being logged in file
           /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/logs/dmgr/startServer.log
ADMU0128I: Starting tool with the Dmgr01 profile
ADMU3100I: Reading configuration for server: dmgr
ADMU3200I: Server launched. Waiting for initialization status.
ADMU3000I: Server dmgr open for e-business; process id is 46599
Configuring managed node profiles.
Creating the managed node Node1 profile.
INSTCONFSUCCESS: Success: Profile AppSrv01 now exists. Please consult /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/AboutThisProfile.txt for more information about this profile.
Adding the node Node1 to the cell PCCell1.
ADMU0116I: Tool information is being logged in file
           /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/addNode.log
ADMU0128I: Starting tool with the AppSrv01 profile
CWPKI0308I: Adding signer alias "CN=bpm855.uk.ibm.com, OU=Root C" to local
           keystore "ClientDefaultTrustStore" with the following SHA digest:
           7B:1F:21:A9:72:6B:7C:2E:58:8B:6A:4B:3C:4D:6E:DB:7F:7D:F2:BE
CWPKI0309I: All signers from remote keystore already exist in local keystore.
ADMU0001I: Begin federation of node Node1 with Deployment Manager at
           bpm855.uk.ibm.com:8879.
ADMU0009I: Successfully connected to Deployment Manager Server:
           bpm855.uk.ibm.com:8879
ADMU0507I: No servers found in configuration under:
           /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/config/cells/PCCell1Node1/nodes/Node1/servers
ADMU2010I: Stopping all server processes for node Node1
ADMU0024I: Deleting the old backup directory.
ADMU0015I: Backing up the original cell repository.
ADMU0012I: Creating Node Agent configuration for node: Node1
ADMU0014I: Adding node Node1 configuration to cell: PCCell1
ADMU0016I: Synchronizing configuration between node and cell.


ADMU0300I: The node Node1 was successfully added to the PCCell1 cell.


ADMU0306I: Note:
ADMU0302I: Any cell-level documents from the standalone PCCell1 configuration
           have not been migrated to the new cell.
ADMU0307I: You might want to:
ADMU0303I: Update the configuration on the PCCell1 Deployment Manager with
           values from the old cell-level documents.


ADMU0306I: Note:
ADMU0304I: Because -includeapps was not specified, applications installed on
           the standalone node were not installed on the new cell.
ADMU0307I: You might want to:
ADMU0305I: Install applications onto the PCCell1 cell using wsadmin $AdminApp
           or the Administrative Console.


ADMU0003I: Node Node1 has been successfully federated.
Generating SQL files.
Provisioning cell.
Generating database configuration files to /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/PCCell1.
Configuring the cell.
Configuring the deployment manager.
Provisioning deployment environment.
Generating database configuration files to /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/PCCell1.De1.
Performing security configuration.
Creating clusters.
Configuring data sources.
Configuring the databases.
Configuring clusters.
Configuring cluster MECluster for capability Messaging.
Configuring cluster AppCluster for capability Application.
Operation completed successfully
Configuring cluster SupCluster for capability Support.
Provisioning managed node Node1.
The HTTP and HTTPS ports are added to the virtual hosts list.
Creating cluster members.
Configuring the REST services end points.
Saving configuration changes...
Synchronizing node Node1.
ADMU0116I: Tool information is being logged in file
           /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/syncNode.log
ADMU0128I: Starting tool with the AppSrv01 profile
ADMU0401I: Begin syncNode operation for node Node1 with Deployment Manager
           bpm855.uk.ibm.com: 8879
ADMU0016I: Synchronizing configuration between node and cell.
ADMU0402I: The configuration for node Node1 has been synchronized with
           Deployment Manager bpm855.uk.ibm.com: 8879
Stopping deployment manager profile Dmgr01.
ADMU0116I: Tool information is being logged in file
           /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/logs/dmgr/stopServer.log
ADMU0128I: Starting tool with the Dmgr01 profile
ADMU3100I: Reading configuration for server: dmgr
ADMU3201I: Server stop request issued. Waiting for stop status.
ADMU4000I: Server dmgr stop completed.

The 'BPMConfig.sh -create -de Advanced-PC-ThreeClusters-DB2.properties' command completed successfully.

and then created my DB2 databases: -

su - db2inst1

cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/PCCell1/DB2/CMNDB/
./createDatabase.sh 
db2 connect to cmndb
db2 grant dbadm on database to user db2user1
db2 -tvf createSchema_Advanced.sql 
db2 terminate


cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/PCCell1.De1/DB2/CMNDB/
db2 connect to cmndb
db2 -tvf createSchema_Advanced.sql 
db2 -tvf createSchema_Messaging.sql 
db2 terminate


cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/PCCell1.De1/DB2/BPMDB
./createDatabase.sh 
db2 connect to bpmdb
db2 grant dbadm on database to user db2user1
db2 -tvf createSchema_Advanced.sql
db2 -tdGO -vf createProcedure_Advanced.sql
db2 terminate


cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/PCCell1.De1/DB2/PDWDB
./createDatabase.sh 
db2 connect to pdwdb
db2 grant dbadm on database to user db2user1
db2 -tvf createSchema_Advanced.sql
db2 terminate


and then bootstrap the BPM DB: -

su - wasadmin
/opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin/bootstrapProcessServerData.sh -clusterName AppCluster

Bootstraping data into cluster AppCluster and logging into /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/logs/bootstrapProcesServerData.AppCluster.log

WASX7357I: By request, this scripting client is not connected to any server process. Certain configuration and application operations will be available in local mode.
'BootstrapProcessServerData admin command completed successfully.....'

and then start the Deployment Environment: -

/opt/IBM/WebSphere/AppServer/bin/BPMConfig.sh -start -profile Dmgr01 -de De1

Logging to file /opt/IBM/WebSphere/AppServer/logs/config/BPMConfig_20150318-185611.log.
Starting deployment manager profile Dmgr01.
CWUPO0001I: Running configuration action detectNewProducts.ant
ADMU0116I: Tool information is being logged in file
           /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/logs/dmgr/startServer.log
ADMU0128I: Starting tool with the Dmgr01 profile
ADMU3100I: Reading configuration for server: dmgr
ADMU3200I: Server launched. Waiting for initialization status.
ADMU3000I: Server dmgr open for e-business; process id is 61506
Starting node Node1.
CWUPO0001I: Running configuration action detectNewProducts.ant
ADMU0116I: Tool information is being logged in file
           /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/nodeagent/startServer.log
ADMU0128I: Starting tool with the AppSrv01 profile
ADMU3100I: Reading configuration for server: nodeagent
ADMU3200I: Server launched. Waiting for initialization status.
ADMU3000I: Server nodeagent open for e-business; process id is 61908
Starting cluster MECluster.
Starting cluster AppCluster.
Starting cluster SupCluster.
When the BPMConfig command is used to start a deployment environment, it invokes the processes that are used to start the associated clusters. If the command is successful in invoking the processes, it returns a message to report that the command completed successfully. However, to determine whether the cluster members were all started successfully, you need to check the log files of the cluster members. The log files are located in <WAS_HOME>/profiles/logs.
The 'BPMConfig.sh -start -profile Dmgr01 -de De1' command completed successfully.


and watched the logs looking for the infamous "Open for e-business": -

tail -f /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/MEClusterMember1/SystemOut.log

tail -f /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/SupClusterMember1/SystemOut.log

tail -f /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/AppClusterMember1/SystemOut.log

and then finally tested Process Center: -





and Process Admin: -



and Performance Admin: -



which is all nice :-)

Advanced-PC-ThreeClusters-DB2.properties

##########################################
# Deployment environment properties: De1 #
##########################################
bpm.de.name=De1
# The type of product configuration: Express, Standard, Advanced, or AdvancedOnly.
bpm.de.type=Advanced
# The type of deployment environment: Process Center or Process Server.
bpm.de.environment=Process Center
# Options: 'true' or 'false'. If false is specified, the database schemas are created when the deployment environment is created. If true is specified, the database schemas must be created manually using the generated scripts, and the bootstrapProcessServerData script must be run manually. When using DB2 for z/OS, the option must be set to true.
bpm.de.deferSchemaCreation=true
# The context root prefix for all web modules in this environment. If set, the context root prefix must start with a forward slash character (/).
bpm.de.contextRootPrefix=
# The virtualHost for all web modules in this environment. If a value is not set for virtualHost, the default value 'default_host' is used.
bpm.de.virtualHost=

######################################################################################################################################################
# Deployment environment administrator authentication alias, it cannot have the same user name as the authentication alias of the cell administrator #
######################################################################################################################################################
bpm.de.authenticationAlias.1.name=DeAdminAlias
bpm.de.authenticationAlias.1.user=deAdmin
bpm.de.authenticationAlias.1.password=password

######################################
# Database user authentication alias #
######################################
bpm.de.authenticationAlias.2.name=BPM_DB_ALIAS
bpm.de.authenticationAlias.2.user=db2user1
bpm.de.authenticationAlias.2.password=passw0rd

#########################################################################################################################################################################################################################################################################################################################################################################################
# The deployment environment administrator role and authentication alias association. If you do not specify the BPMAuthor role, the authentication alias that maps to this role will be used when Process Center connects to IBM Process Server for online deployment. It must be defined in both Process Server and Process Center, and the user names and passwords must be the same. #
#########################################################################################################################################################################################################################################################################################################################################################################################
# Do not modify the name of the role mapping. Role mapping names are predefined. Specify the user name in the authentication alias that corresponds to this role.
bpm.de.roleMapping.1.name=DeAdmin
bpm.de.roleMapping.1.alias=DeAdminAlias

############################
# Cell properties: PCCell1 #
############################
bpm.cell.name=PCCell1
# The database at the cell level. This database is only applicable to IBM BPM Advanced and AdvancedOnly configurations. The value should correspond to the name of a database that is defined in this file.
bpm.cell.db=CellOnlyDb

##################################################
# Cell (WAS) administration authentication alias #
##################################################
bpm.cell.authenticationAlias.1.name=CellAdminAlias
bpm.cell.authenticationAlias.1.user=wasadmin
bpm.cell.authenticationAlias.1.password=passw0rd

##################################################
# Cell role and authentication alias association #
##################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.cell.roleMapping.1.name=CellAdmin
bpm.cell.roleMapping.1.alias=CellAdminAlias



#################################
# Deployment manager properties #
#################################
# The name of the deployment manager node.
bpm.dmgr.nodeName=Dmgr
# The host name of the deployment manager. Do not use localhost for environments that span multiple hosts.
bpm.dmgr.hostname=bpm855.uk.ibm.com
# The installation location of the BPM product. If you want to use a backslash character (\) in your properties file, you must use an escape backslash before it, for example bpm.dmgr.installPath=c:\\IBM\\BPM85.
bpm.dmgr.installPath=/opt/IBM/WebSphere/AppServer
# The name of the deployment manager profile.
bpm.dmgr.profileName=Dmgr01
# Custom options that are passed to the 'manageprofiles' command and used primarily to customize port assignments.
bpm.dmgr.profileOptions=
# To override the default port assignments for this profile, specify a starting port number for generating and assigning ports.
bpm.dmgr.initialPortAssignment=
# The deployment manager SOAP port. This port is used to establish a connection to the deployment manager during the creation of remote nodes. Update this property after you create the deployment manager profile.
bpm.dmgr.soapPort=8879



##################################
# Cluster properties: AppCluster #
##################################
bpm.de.cluster.1.name=AppCluster
# Options: Application, Support, Messaging. These three capabilities correspond to the three-cluster topology that is supported by IBM BPM. If this is a single-cluster environment, specify all three of these capabilities here.
bpm.de.cluster.1.capabilities=Application
# The name of the messaging cluster used by this cluster.
bpm.de.cluster.1.usesMessagingCluster=MECluster
# The name of the support cluster used by this cluster.
bpm.de.cluster.1.usesSupportCluster=SupCluster
# The list of databases that are used on this cluster. Each value should correspond to the name of a database defined in this file. For a single-cluster topology, the list should include all of the databases that are used (with the exception of the CellOnlyDb in IBM BPM Advanced environments). For a three-cluster topology, the Application cluster includes all of the databases except those that are used for messaging and the Performance Data Warehouse (PDW). The messaging and PDW databases are included in the Messaging and Support clusters.
bpm.de.cluster.1.db=ProcessServerDb,SharedDb
bpm.de.cluster.1.capability.1.component.1.name=ProcessPortal
# The context root prefix for all web modules in the specified component. If set, the context root prefix must start with a forward slash character (/).
bpm.de.cluster.1.capability.1.component.1.contextRootPrefix=



#################################
# Cluster properties: MECluster #
#################################
bpm.de.cluster.2.name=MECluster
# Options: Application, Support, Messaging. These three capabilities correspond to the three-cluster topology that is supported by IBM BPM. If this is a single-cluster environment, specify all three of these capabilities here.
bpm.de.cluster.2.capabilities=Messaging
# The list of databases that are used on this cluster. Each value should correspond to the name of a database defined in this file. For a single-cluster topology, the list should include all of the databases that are used (with the exception of the CellOnlyDb in IBM BPM Advanced environments). For a three-cluster topology, the Application cluster includes all of the databases except those that are used for messaging and the Performance Data Warehouse (PDW). The messaging and PDW databases are included in the Messaging and Support clusters.
bpm.de.cluster.2.db=SharedDb



##################################
# Cluster properties: SupCluster #
##################################
bpm.de.cluster.3.name=SupCluster
# Options: Application, Support, Messaging. These three capabilities correspond to the three-cluster topology that is supported by IBM BPM. If this is a single-cluster environment, specify all three of these capabilities here.
bpm.de.cluster.3.capabilities=Support
# The name of the messaging cluster used by this cluster.
bpm.de.cluster.3.usesMessagingCluster=MECluster
# The list of databases that are used on this cluster. Each value should correspond to the name of a database defined in this file. For a single-cluster topology, the list should include all of the databases that are used (with the exception of the CellOnlyDb in IBM BPM Advanced environments). For a three-cluster topology, the Application cluster includes all of the databases except those that are used for messaging and the Performance Data Warehouse (PDW). The messaging and PDW databases are included in the Messaging and Support clusters.
bpm.de.cluster.3.db=PerformanceDb



##########################
# Node properties: Node1 #
##########################
bpm.de.node.1.name=Node1
# If the host name is the same as deployment manager, this node will be created on the same computer. Do not use localhost for environments that span multiple hosts.
bpm.de.node.1.hostname=bpm855.uk.ibm.com
# The installation location of the BPM product. If you want to use a backslash character (\) in your properties file, you must use an escape backslash before it, for example bpm.de.node.1.installPath=c:\\IBM\\BPM85.
bpm.de.node.1.installPath=/opt/IBM/WebSphere/AppServer
# The name of the node profile.
bpm.de.node.1.profileName=AppSrv01
# Custom options that are passed to the 'manageprofiles' command and used primarily to customize port assignments.
bpm.de.node.1.profileOptions=
# To override the default port assignments for this profile, specify a starting port number for generating and assigning ports.
bpm.de.node.1.initialPortAssignment=

################################################
# Cluster member properties: AppClusterMember1 #
################################################
bpm.de.node.1.clusterMember.1.name=AppClusterMember1
# The cluster this cluster member belongs to. This value should correspond to the name of a cluster defined in this file.
bpm.de.node.1.clusterMember.1.cluster=AppCluster
# The proportion of requests that are sent to this cluster member
bpm.de.node.1.clusterMember.1.weight=2
bpm.de.node.1.clusterMember.1.initialPortAssignment=

###############################################
# Cluster member properties: MEClusterMember1 #
###############################################
bpm.de.node.1.clusterMember.2.name=MEClusterMember1
# The cluster this cluster member belongs to. This value should correspond to the name of a cluster defined in this file.
bpm.de.node.1.clusterMember.2.cluster=MECluster
# The proportion of requests that are sent to this cluster member
bpm.de.node.1.clusterMember.2.weight=2
bpm.de.node.1.clusterMember.2.initialPortAssignment=

################################################
# Cluster member properties: SupClusterMember1 #
################################################
bpm.de.node.1.clusterMember.3.name=SupClusterMember1
# The cluster this cluster member belongs to. This value should correspond to the name of a cluster defined in this file.
bpm.de.node.1.clusterMember.3.cluster=SupCluster
# The proportion of requests that are sent to this cluster member
bpm.de.node.1.clusterMember.3.weight=2
bpm.de.node.1.clusterMember.3.initialPortAssignment=

#################################
# Database properties: SharedDb #
#################################
# Keyword to use to refer to this set of database properties. This is not the database name.
bpm.de.db.1.name=SharedDb
# The list of available options depends on the product configuration. For IBM BPM Express and Standard, the options are ProcessServer, EmbeddedECM, PDW, Messaging, and BusinessSpace. For IBM BPM Advanced, the options are ProcessServer, EmbeddedECM, PDW, CellScopedDB, Messaging, BusinessSpace, CommonDB, and BPC. For IBM BPM Advanced Only, the options are CellScopedDB, Messaging, BusinessSpace, CommonDB, and BPC. For EmbeddedECM, there is no support if the operating system for the IBM BPM environment is z/OS.
bpm.de.db.1.dbCapabilities=Messaging,BusinessSpace,CommonDB,BPC
# Options: DB2, DB2zOS, Oracle, or SQL Server.
bpm.de.db.1.type=DB2
# The host name of the database. Do not use localhost for environments that span multiple hosts.
bpm.de.db.1.hostname=bpm855.uk.ibm.com
bpm.de.db.1.portNumber=60012
# The name of the database.
bpm.de.db.1.databaseName=CMNDB
bpm.de.db.1.schema=db2user1

#######################################################
# Database role and authentication alias associations #
#######################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.de.db.1.roleMapping.1.name=DbUser
bpm.de.db.1.roleMapping.1.alias=BPM_DB_ALIAS

#######################################################
# Database role and authentication alias associations #
#######################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.de.db.1.roleMapping.2.name=DbUserXAR
bpm.de.db.1.roleMapping.2.alias=BPM_DB_ALIAS



########################################
# Database properties: ProcessServerDb #
########################################
# Keyword to use to refer to this set of database properties. This is not the database name.
bpm.de.db.2.name=ProcessServerDb
# The list of available options depends on the product configuration. For IBM BPM Express and Standard, the options are ProcessServer, EmbeddedECM, PDW, Messaging, and BusinessSpace. For IBM BPM Advanced, the options are ProcessServer, EmbeddedECM, PDW, CellScopedDB, Messaging, BusinessSpace, CommonDB, and BPC. For IBM BPM Advanced Only, the options are CellScopedDB, Messaging, BusinessSpace, CommonDB, and BPC. For EmbeddedECM, there is no support if the operating system for the IBM BPM environment is z/OS.
bpm.de.db.2.dbCapabilities=ProcessServer,EmbeddedECM
# Options: DB2, DB2zOS, Oracle, or SQL Server.
bpm.de.db.2.type=DB2
# The host name of the database. Do not use localhost for environments that span multiple hosts.
bpm.de.db.2.hostname=bpm855.uk.ibm.com
bpm.de.db.2.portNumber=60012
# The name of the database.
bpm.de.db.2.databaseName=BPMDB
bpm.de.db.2.schema=db2user1

#######################################################
# Database role and authentication alias associations #
#######################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.de.db.2.roleMapping.1.name=DbUser
bpm.de.db.2.roleMapping.1.alias=BPM_DB_ALIAS

#######################################################
# Database role and authentication alias associations #
#######################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.de.db.2.roleMapping.2.name=DbUserXAR
bpm.de.db.2.roleMapping.2.alias=BPM_DB_ALIAS



######################################
# Database properties: PerformanceDb #
######################################
# Keyword to use to refer to this set of database properties. This is not the database name.
bpm.de.db.3.name=PerformanceDb
# The list of available options depends on the product configuration. For IBM BPM Express and Standard, the options are ProcessServer, EmbeddedECM, PDW, Messaging, and BusinessSpace. For IBM BPM Advanced, the options are ProcessServer, EmbeddedECM, PDW, CellScopedDB, Messaging, BusinessSpace, CommonDB, and BPC. For IBM BPM Advanced Only, the options are CellScopedDB, Messaging, BusinessSpace, CommonDB, and BPC. For EmbeddedECM, there is no support if the operating system for the IBM BPM environment is z/OS.
bpm.de.db.3.dbCapabilities=PDW
# Options: DB2, DB2zOS, Oracle, or SQL Server.
bpm.de.db.3.type=DB2
# The host name of the database. Do not use localhost for environments that span multiple hosts.
bpm.de.db.3.hostname=bpm855.uk.ibm.com
bpm.de.db.3.portNumber=60012
# The name of the database.
bpm.de.db.3.databaseName=PDWDB
bpm.de.db.3.schema=db2user1

#######################################################
# Database role and authentication alias associations #
#######################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.de.db.3.roleMapping.1.name=DbUser
bpm.de.db.3.roleMapping.1.alias=BPM_DB_ALIAS

#######################################################
# Database role and authentication alias associations #
#######################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.de.db.3.roleMapping.2.name=DbUserXAR
bpm.de.db.3.roleMapping.2.alias=BPM_DB_ALIAS



###################################
# Database properties: CellOnlyDb #
###################################
# Keyword to use to refer to this set of database properties. This is not the database name.
bpm.de.db.4.name=CellOnlyDb
# The list of available options depends on the product configuration. For IBM BPM Express and Standard, the options are ProcessServer, EmbeddedECM, PDW, Messaging, and BusinessSpace. For IBM BPM Advanced, the options are ProcessServer, EmbeddedECM, PDW, CellScopedDB, Messaging, BusinessSpace, CommonDB, and BPC. For IBM BPM Advanced Only, the options are CellScopedDB, Messaging, BusinessSpace, CommonDB, and BPC. For EmbeddedECM, there is no support if the operating system for the IBM BPM environment is z/OS.
bpm.de.db.4.dbCapabilities=CellScopedDB
# Options: DB2, DB2zOS, Oracle, or SQL Server.
bpm.de.db.4.type=DB2
# The host name of the database. Do not use localhost for environments that span multiple hosts.
bpm.de.db.4.hostname=bpm855.uk.ibm.com
bpm.de.db.4.portNumber=60012
# The name of the database.
bpm.de.db.4.databaseName=CMNDB
bpm.de.db.4.schema=db2user1

#######################################################
# Database role and authentication alias associations #
#######################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.de.db.4.roleMapping.1.name=DbUser
bpm.de.db.4.roleMapping.1.alias=BPM_DB_ALIAS

#######################################################
# Database role and authentication alias associations #
#######################################################
# Do not modify this value. Role mapping names are predefined. Specify the user name in the authentication alias corresponding to this role.
bpm.de.db.4.roleMapping.2.name=DbUserXAR
bpm.de.db.4.roleMapping.2.alias=BPM_DB_ALIAS



Visual Studio Code - Wow 🙀

Why did I not know that I can merely hit [cmd] [p]  to bring up a search box allowing me to search my project e.g. a repo cloned from GitHub...