How to migrate your database from Derby to another COTS (Common Off The Shelf) database
1. On JTS export JTS *.json file with
./repotools-jts.sh -prepareJsaSsoMigration adminUserId=<your Admin User> adminPassword=<your Admin Password> repositoryURL=https://[public-url]:[port]/jts toFile=JTS_output.json
2. Repeat on all other Applications, such as CCM, for example:
./repotools-ccm.sh -prepareJsaSsoMigration adminUserId=<your Admin User> adminPassword=<your Admin Password> repositoryURL=https://[public-url]:[port]/ccmtoFile=CCM_output.json
Attention: please check twice when you create *.json files for all existing applications (use the corresponding repotools-xxx.sh for each application)
3. Stop JAS and move to your DB choice described with this link:
https://jazz.net/wiki/bin/view/Deployment/PerformanceClusteredJAS
4. Start JAS and test your configuration as described in this link:
https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/c_jsasso_jas_deploy_start.html&scope=null
5. Stop all applications JTS, CCM, RM, QM etc.”. This step is necessary as if the applications are running you can not execute the migration command.
6. Migrate created *.json files starting with JTS using
./repotools-jts.sh -migrateToJsaSso authServerUrl=https://[jas-url]:9643/oidc/endpoint/jazzop authServerUserId=<your Admin User> authServerPassword=<your Admin Password>
jtsSsoDataFile=JTS_output.json
6. Then migrate all other application using as example fo CCM:
./repotools-ccm.sh -migrateToJsaSso authServerUrl=https://[jas-url]:9643/oidc/endpoint/jazzop authServerUserId=<your Admin User> authServerPassword=<your Admin Password>
jtsSsoDataFile=JTS_output.json appSsoDataFile=CCM_output.json
7. After migration, startup all Application beginning with JTS
8. Test availability of all Application after startup
Attention: please be aware that LDX/LQE/JRS may not be available so please try to unregister and reregister these applications after your Test step 9.)
External links: