Monday, 28 April 2014

IBM BPM 8.5 - More about Databases

So a quick splurge ( aka aide memoire ) as I'll be setting up IBM BPM 8.5 and DB2 as part of a PoC tomorrow.

So here's the formal IBM documentation: -


If you run the BPMConfig command with the property bpm.de.deferSchemaCreation set to true, or if you used the Deployment Environment Wizard and cleared the Create Tables option, you must run the generated database scripts manually to create the database tables.

Before you begin

Before you begin this task, you must have run the BPMConfig command or the Deployment Environment Wizard to generate the correct SQL scripts.
If the property bpm.de.deferSchemaCreation is set to false, or if you used the Deployment Environment Wizard and did not clear the Create Tables option, the SQL scripts are run during configuration of the deployment environment.

About this task

The database SQL scripts are generated in the dmgr_profile_name/dbscripts folder by default.

So this is what I did: -

( as db2inst1 )

cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/PCCell1/DB2/CMNDB./createDatabase.shdb2 connect to CMNDB
db2 -tvf createSchema_Advanced.sql


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

cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/De1/DB2/BPMDB
./createDatabase.sh
db2 connect to BPMDB
db2 -tvf createSchema_Advanced.sql
db2 -tdGO -vf createProcedure_Advanced.sql


( NOTE that the command for the Stored Procedure is different because the SQL script uses different separators )

cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/dbscripts/De1/DB2/PDWDB
./createDatabase.sh
db2 connect to PDWDB
db2 -tvf createSchema_Advanced.sql


I also needed to do this: -

$ db2 update db cfg for BPMDB using LOGSECOND 40

DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for BPMDB using LOGFILSIZ 2048
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

as per my previous experiences: -


Then I ran the bootstrap process: -

Bootstrap the Database for the AppTarget Cluster

cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin ./bootstrapProcessServerData.sh -clusterName BPM85Advanced.AppCluster

which returns: -

Bootstraping data into cluster BPM85Advanced.AppCluster

and then we're good to go :-)

No comments: