Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

What is the configuration steps for DB2 database with CLM 4.0.5 after import the DB2 data from one server to another?

 Hello,
I have an environment of CLM 4.0.5 with tomcat application server and IBM DB2 v10.1.3 deployed on Windows 2008 64 bit standard edition.
I have imported the data (JTS, RTC,RQM and DW) from one DB2 server to another DB2 server and have to configure with CLM server, in my case CLM and DB2 both are on different servers.

Can any one help to let me know the steps for configuration of CLM with DB2 server?

Thanks
Regards,
Raj

0 votes



3 answers

Permanent link
These steps are for JTS:
  1. Stop the Jazz Team Server.
  2. Move the database to the new location using the database vendor-specific tools.
  3. Update the /server/conf/jts/teamserver.properties to point to this new location.
  4. Run the script 'repotools-jts -verify' to verify the new database connection is successful.
  5. Start the Jazz Team Server.
but they should be valid for any CLM application you installed.
You can refer to https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/t_migrate_dbs.html&scope=null for further information.
Cheers.

1 vote


Permanent link
Hi Raj,

The easiest way is to run the JTS Setup Wizard (https://<host>:<port>/jts/setup). Click "Next" until you reach the Database configuration page for each application. Then update the connection string to point to the new DB2 server.

0 votes


Permanent link
 Hello Alexandre,
Thanks for your reply. I explained you more in details what environment and what i want.
I have environment RTC 4.0.5 is on different window server and DB 10.1.3 is on different server. I have configured DB2 with RTC and it is working fine. But after some we started to face the issue from DB2 server every time our DB2 server get down and so the reason application become down. we tried many ways to resolve it but did not get any luck.
So that's the reason I have created new windows server where we will install the DB2 10.1.3 and import the data from the existing DB2 server. After that i will have to configured new DB2 server with the existing RTC server. 

That's the reason i want to know the steps how do we configured the existing RTC server our new DB2 server? Is ther any prerequisite which I have to take care?

Many thanks for your kind help and advise.

Kind Regards,
Raj 

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,498
× 6,125

Question asked: May 08 '15, 7:48 a.m.

Question was seen: 3,129 times

Last updated: May 13 '15, 9:57 a.m.

Confirmation Cancel Confirm