>/repodebug/repository/itemCount"
2. Save the page in HTML
3. Stop all ELM application including DNG.
4. Backup of the Derby DB of DNG
eg:
cd to /opt/IBM/JazzTeamServer/server/conf/rm
cp derby derby.ORG.{date}
5. Run the export command
cd to /opt/IBM/JazzTeamServer/server/conf/rm
$repotools-rm.sh -export toFile=/tmp/exportRMDB.tar teamserver.properties=conf/rm/teamserver.properties
The export can take several hours as depends on amount of data it needs to be exported. You can check the status of the export command in the export log in the file system. Once the export is completed you will see a message like this in the export log
2020-09-12 17:57:19,833 Repo Tools
2020-09-12 17:57:19,834 java.version=1.8.0_191
2020-09-12 17:57:19,834 java.runtime.version=8.0.5.25 - pxa6480sr5fp25-20181030_01(SR5 FP25)
2020-09-12 17:57:19,837 Provisioning using "./conf/rm/provision_profiles".
2020-09-12 17:57:19,862 repotools-rm -export teamserver.properties=conf/rm/teamserver.properties toFile=/tmp/exportRM.tar
2020-09-12 17:57:19,863 Global patch active at /opt/IBM/JazzTeamServer/server/patch/CLM_server_patch_6.0.6.1-iFix003-CALM6061M-I20190718-0352.zip: "CLM_server_patch_6.0.6.1-CALM6061M-I20190718-0352.zip"
2020-09-12 17:57:19,880
To submit questions about issues, go to the Jazz.net forum at https://jazz.net/forum.
To find more information about a message, see the online product documentation.
2020-09-12 17:57:19,881 CRJAZ1363I Loading the configuration from "file:conf/rm/teamserver.properties".
2020-09-12 17:57:23,337 CRJAZ1778I This server is configured as an application.
2020-09-12 17:57:23,529 CRJAZ1365I The server is attempting to connect to the following database: "conf/rm/derby/repositoryDB"
2020-09-12 17:57:23,932 CRJAZ1364I The connection to the following database was successful:
Db Product Name: Apache Derby
Db Product Version: 10.10.2.0 - (1582446)
Db URL: jdbc:derby:conf/rm/derby/repositoryDB;create=true
Jdbc Driver Name: Apache Derby Embedded JDBC Driver
Jdbc Driver Version: 10.10.2.0 - (1582446)
SchemaPrefix:
2020-09-12 17:57:27,369 CRJAZ2558I Setting the local server rename state to false and the openServerDescriptionServiceTemporarily state to false.
2020-09-12 17:57:27,392 CRJAZ1970I The application is configured with:
Public URI: "https://<<server>>/rm"
Jazz Team Server location: "https://<<server>>/jts/"
2020-09-12 17:57:27,511 CRJAZ2523I Setting the global server rename state to false and the validation state to false.
2020-09-12 17:57:28,858 CRJAZ8190I: The full-text index should point to an absolute directory, but is currently set to 'conf/rm/indices/artifactindex'. The location of the full-text index will resolve to '/opt/IBM/JazzTeamServer/server/conf/rm/indices/artifactindex/_8GsW0K_MEemqyLEbJf8Kng'.
2020-09-12 17:57:29,913 CRJAZ2105I Checking for a running server...
2020-09-12 17:57:29,966 The user "ADMIN" has logged in to the database "conf/rm/derby/repositoryDB".
2020-09-12 17:57:29,971 Exporting the data from the database "conf/rm/derby/repositoryDB" to the file "/tmp/exportRMDB.tar".
2020-09-12 17:57:29,971 Using encoding "UTF-8" for TAR file headers.
2020-09-12 17:57:42,273
2020-09-12 17:57:42,275 Exporting all the items present in the repository in offline mode.
2020-09-12 17:57:42,275
2020-09-12 17:57:42,399 Exporting com.ibm.team.repository/ChangeEvent.
2020-09-12 17:57:42,589 Exported 93 ChangeEvent items in 189 ms.
....
.....
......
2020-09-12 18:16:45,345 Marker : 1602 items, 1602 item states exported in 684ms.
2020-09-12 18:16:45,345 com.ibm.team.globalconfiguration
2020-09-12 18:16:45,345 UriPair : 10 items, 10 item states exported in 10ms.
2020-09-12 18:16:45,345 GlobalConfiguration : 4 items, 4 item states exported in 6ms.
2020-09-12 18:16:45,345 com.ibm.team.reports
2020-09-12 18:16:45,345 ReportQueryDescriptor : 0 items, 0 item states exported in 0ms.
2020-09-12 18:16:45,345 StorageNode : 293 items, 293 item states exported in 165ms.
2020-09-12 18:16:45,345 FolderDescriptor : 0 items, 0 item states exported in 0ms.
2020-09-12 18:16:45,345 ReportDescriptor : 0 items, 0 item states exported in 0ms.
2020-09-12 18:16:45,345
2020-09-12 18:16:45,345 Export completed successfully.
2020-09-12 18:16:45,345 The user "ADMIN" has logged out of the database "conf/rm/derby/repositoryDB".
Please note:
Before running a export increase JVM heap size in the repotools-rm.sh command. Eg (to be added)
Ensure, all applications are down until a import process is completed!!
DB migration - Import
1. Make a backup of existing teamserver.properties which contain a DB connections to Derby
2. Edit teamserver.properties file, comment out the Derby lines and add the following (eg)
#com.ibm.team.repository.db.jdbc.location=conf/rm/derby/repositoryDB
#com.ibm.team.repository.db.vendor=DERBY
com.ibm.team.repository.db.repoLockId=_7-DYMK_MEemqyLEbJf8Kng
com.ibm.team.repository.db.timezone=America/New_York
com.ibm.team.repository.db.vendor = ORACLE
com.ibm.team.repository.db.jdbc.location=thin\:RM_DB_USER/{password}@//localhost\:1521/vision1.fyre.ibm.com
com.ibm.team.repository.db.jdbc.password=PWDforRM_DB_USER
3. Save teamserver.properties file
4. Run the repotool command import eg
Cd to /opt/IBM/JazzTeamServer/server/conf/rm
Run repotools-rm.sh -import fromFile=/tmp/exportRMDB.tar teamserver.properties=conf/rm/teamserver.properties
The repotool command will read /tmp/exportRMDB.tar file and will import into Oracle database. The import command could take longer then an export because during import we write data into database
2020-09-13 01:50:03,084 Repo Tools
2020-09-13 01:50:03,084 java.version=1.8.0_191
2020-09-13 01:50:03,084 java.runtime.version=8.0.5.25 - pxa6480sr5fp25-20181030_01(SR5 FP25)
2020-09-13 01:50:03,088 Provisioning using "./conf/rm/provision_profiles".
2020-09-13 01:50:03,103 repotools-rm -import fromFile=/tmp/exportRMDB.tar teamserver.properties=conf/rm/teamserver.properties
2020-09-13 01:50:03,105 Global patch active at /opt/IBM/JazzTeamServer/server/patch/CLM_server_patch_6.0.6.1-iFix003-CALM6061M-I20190718-0352.zip: "CLM_server_patch_6.0.6.1-CALM6061M-I20190718-0352.zip"
2020-09-13 01:50:03,123
To submit questions about issues, go to the Jazz.net forum at https://jazz.net/forum.
To find more information about a message, see the online product documentation.
2020-09-13 01:50:03,123 CRJAZ1363I Loading the configuration from "file:conf/rm/teamserver.properties".
2020-09-13 01:50:06,189 CRJAZ1778I This server is configured as an application.
2020-09-13 01:50:06,368 CRJAZ1365I The server is attempting to connect to the following database: "thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>"
2020-09-13 01:50:06,727 CRJAZ3002I The connection to the following database was successful:
Db Product Name: Oracle
Db Product Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Db URL: jdbc:oracle:thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 12.2.0.1.0
SchemaName: RM_DB_USER
2020-09-13 01:50:07,928 CRJAZ2558I Setting the local server rename state to false and the openServerDescriptionServiceTemporarily state to false.
2020-09-13 01:50:07,945 CRJAZ1970I The application is configured with:
Public URI: "https://<<Server>>/rm"
Jazz Team Server location: "https://<<serer>>/jts/"
2020-09-13 01:50:08,221 CRJAZ2523I Setting the global server rename state to false and the validation state to false.
2020-09-13 01:50:08,475 CRJAZ2105I Checking for a running server...
2020-09-13 01:50:08,524 Creating the tables for the database "thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>" without indices.
2020-09-13 01:50:26,808 CRJAZ1970I The application is configured with:
Public URI: "https://<<server>>/rm"
Jazz Team Server location: "https://<<server>>/jts/"
2020-09-13 01:50:27,456 CRJAZ8190I: The full-text index should point to an absolute directory, but is currently set to 'conf/rm/indices/artifactindex'. The location of the full-text index will resolve to '/opt/IBM/JazzTeamServer/server/conf/rm/indices/artifactindex/__bHWQfWEEeqNNc3NAFxjqQ'.
2020-09-13 01:50:28,789 The user "ADMIN" has logged in to the database "thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>".
2020-09-13 01:50:28,939 The user "ADMIN" has logged out of the database "thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>".
2020-09-13 01:50:28,956 CRJZS5650I Indices directory is /opt/IBM/JazzTeamServer/server/conf/rm/indices
2020-09-13 01:50:28,957 The database tables were created successfully.
2020-09-13 01:50:29,557 CRJAZ1365I The server is attempting to connect to the following database: "thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>"
2020-09-13 01:50:29,595 CRJAZ3002I The connection to the following database was successful:
Db Product Name: Oracle
Db Product Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Db URL: jdbc:oracle:thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 12.2.0.1.0
SchemaName: RM_DB_USER
2020-09-13 01:50:33,410 CRJAZ1970I The application is configured with:
Public URI: "https://<<server>>/rm"
Jazz Team Server location: "https://<<server>>/jts/"
2020-09-13 01:50:34,569 The user "ADMIN" has logged in to the database "thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>".
2020-09-13 01:50:34,569 Importing the data from the file "/tmp/exportRM.tar" into the database "thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>".
2020-09-13 01:50:34,569 Using encoding "UTF-8" for TAR file headers.
2020-09-13 01:50:34,576
Reading the TAR file /tmp/exportRM.tar...
2020-09-13 01:50:35,296 Finished reading the TAR file "/tmp/exportRMDB.tar" in 722 ms.
2020-09-13 01:50:35,297 Using deserializer caching options to improve migration performance.
2020-09-13 01:50:35,297 Configured to update database stats every 1800000ms.
2020-09-13 01:50:35,297 Importing contents from /tmp/exportRMDB.tar into the repository.
2020-09-13 01:50:36,077
Migrating data exported from the following model versions
2020-09-13 01:50:36,077 Namespace URI = com.ibm.team.repository.auth, Version = 4
...
....
....
....
2020-09-13 04:18:36,579 Marker : 1602 items, 1602 item states imported.
2020-09-13 04:18:36,579 com.ibm.team.globalconfiguration
2020-09-13 04:18:36,579 UriPair : 10 items, 10 item states imported.
2020-09-13 04:18:36,579 GlobalConfiguration : 4 items, 4 item states imported.
2020-09-13 04:18:36,579 com.ibm.team.reports
2020-09-13 04:18:36,579 StorageNode : 293 items, 293 item states imported.
2020-09-13 04:18:36,579
2020-09-13 04:18:36,579 Migration completed successfully.
2020-09-13 04:18:36,580 The user "ADMIN" has logged out of the database "thin:xxxxxxxx@//<<OracleDBHostName>>:1521/<<SIDName>>".
Validation and Release application for usage
Assuming, import log shows all green, its time to bring up all ELM application. Remember on start up, JTS starts up first and then followed by all ELM applications. The plain text password that was included in the import process in teamserver.properties file, will be encrypted on a server start-up.
Once the RM application is up and running you may want to check RM admin page to ensure all diagnostic tests are passed including DB connections to Oracle.
1. Get a count of the number of objects in the DB
"https://<>:<>/rm/repodebug/repository/itemCount"
2. Save item count into a html page for validation.
This can be compared with 1:1 mapping from the item count that was taken out of Derby database. The item must match from Derby to Oracle.
Heading 1
External links: