Creating the TIBCO BPM Enterprise Schema
To create a database schema, run the -setupDatabase option with the following execute argument:
docker run -it --rm tibco/bpm/utility:5.6.0 utility -setupDatabase execute
Note: Ensure that the database credentials of the user you created in the previous section are provided to the tool using the -dbConfig option. Also, the URL must reflect the type and location of the database you are using.
Note: If you do not run the -setupDatabase option with the execute argument, the required SQL script file is sent to STDOUT. You can redirect STDOUT to a file in the normal way to run the script yourself.
Alternatively, to create a database schema running the utility as a Kubernetes job, use the following code:
cat <<EOF | kubectl apply -f -
apiVersion: batch/v1
kind: Job
metadata:
name: utility
namespace: bpme
spec:
template:
spec:
hostPID: true
containers:
- name: utility
image: tibco/bpm/utility:5.6.0
command: ["utility","-dbConfig","url=jdbc:db2://bpm-db2:50000/bpm:driverType=4;fullyMaterializeLobData=true;fullyMaterializeInput
Streams=true;progressiveStreaming=2;progressiveLocators=2;useJDBC4C
olumnNameAndLabelSemantics=2;"]
restartPolicy: Never
EOF
Note: Update the above -dbConfig options depending on the database that is used.
Note: As a Kubernetes and OpenShift user, you can use this to create a database schema running utility.
For more details regarding utility and its commands, see Appendix: Utility Commands of the TIBCO® BPM Enterprise Administration Guide.