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

Is there an impact on changing the default database names for clm?

Questions
Tags
Users
Badges
Brad Middleton
JAZZ DEVELOPER (69●1●10●10) retagged
Feb 08 '13, 5:55 p.m.

Can I change the database names to have a prefix of ‘Rational_ on SQL Server. So they would be the following:

  • Rational_RICM
  • Rational_CCM  
  • Rational_QM
  • Rational_RM
  • Rational_JTS
Is there an impact of doing this on future upgrades?

0 votes

1 answer
7,203 views
0 votes

Accepted answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) Feb 06 '13, 7:12 a.m.
Hi Brad,

as far as I can tell, no. From a Jazz perspective, you can name the DB as you like, as long as the user permissions don't change. If you rename them afterwards, make sure to adjust the connection strings in the teamserver.properties for the DB's you renamed.
Brad Middleton selected this answer as the correct answer

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Feb 06 '13, 7:17 a.m.
With respect to upgrade: I was assuming you may be able to rename the DB in the DBMS tools. In this case you could do the rename independent of any upgrade. In general use the tools that come along the DBMS. If you are forced to do a repotools -export/-import during an upgrade that would be a chance to create new databases and change the connection string before doing the rename. This case is similar to the scenario of changing the DB vendor that is described in the documentation.

Amy Laird
JAZZ DEVELOPER Feb 07 '13, 3:01 p.m.
Here is a link to the help topic that Ralph refers to: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/topic/com.ibm.jazz.install.doc/topics/t_server_rename_change_dbvendor.html

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.

Ask a question
Guidelines
FAQ
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,622
× 2,382
× 1,381

Question asked: Feb 06 '13, 7:00 a.m.

Question was seen: 7,203 times

Last updated: Feb 08 '13, 5:55 p.m.

Confirmation Cancel Confirm