Open topic with navigation

TIBCO® BPM Enterprise 5.5.0

# 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.5.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.5.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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® BPM Enterprise

Copyright © 2015-2024. Cloud Software Group, Inc. All Rights Reserved.