Appreciations accepted

Vladlen Litvinov, the author:If you have some job offer for me, I'm ready to discuss it.

Password

WebSphere Application Server password decoder (decryptor)

Encoded password:

!doctype>

Monday, December 5, 2016

Moving IBM BPM Document Store into a separate DB schema

The task – move IBM BPM Document Store into a separate DB schema. This
problem has two solutions:

1.You can create properties file for
the command BPMConfig and use it. But, if the environment has already been
created, we cannot use BPMConfig because it does not permit to change all the
parameters of Deployment Environment. We need to delete our Deployment
Environment before.

2.If you have already installed a new Deployment
Environment, you can use this solution.

The
disclaimer:The
solution is not recommended by IBM, it is hack and any actions you make on own risk!The
solution does not move the content of IBM BPM Document Store, it only creates a
new one in the separate schema.

I prepared this solution for Oracle DB, but, I think, it can be used
with some changes for other RDBMS.

Initial conditions (the example).

We have installed IBM BPM Deployment Environment named BPMAPS, the
schema for Process Server named BPMDBAPS and Oracle SID is BPM8. It is
necessary to move IBM BPM Document Store into another schema named ECMDBAPS.

The numbers using in this example will
be different for different environments, but bold values must be equal to each
other in a particular environment. In our case, for the string schema="ECMDBAPS" (After, number 5)
you must use the value from the string name="EmbeddedECM"
(Before, number 2).

7.Run Deployment Manager and Node
Agents.

8.Sync the configuration with nodes.

9.StartDeployment Environment.

10.After starting DE, check that in the
schema ECMDBAPS the tables of IBM BPM Document Store were created.

11.Open Deployment Environments > BPMAPS > Health Center and check
that all the components have the status Healthy and for the component EmbeddedECM
the schema ECMDBAPS is set up.

12.If you have any doubts, make the
export of the settings of our IBM BPM environment using the command BPMConfig
and check that you have the separate database EmbeddedECMDb: