manually migrating from Derby to DB2 under linux ssh shell
Maybe someone would find it useful. I have written my step taken to migrate from Derby testing environment to DB2 which allowed as to have more then 10 users:
The main problem was that DB2 has to be installed on a remote server and I had just ssh shell to connect to it. 1. download DB2 and the licence Start here http://www-01.ibm.com/software/data/db2/9/download.html and download the DB2 file and licence. 2. install under linux ssh shell Unpack the file under a directory with enough free space. I took steps described here: http://snippets.dzone.com/posts/show/3682 http://www.fduran.com/blog/db2-linux-installation-notes/ 3. remember to enable TCP/IP connectivity look at page 78: http://www.redbooks.ibm.com/redbooks/pdfs/sg246899.pdf 4. make RTC aware of the new db it needs to connect to: You have a very handy web UI wizard to do this task. https://yourServersAddress.com/jazz/setup and follow the steps. You can also do it manually, by changing the teamserver.properties file, which can be found in /jazz/server/ directory. The most tricky part is to give a proper db location properties set up correctly: # Comment out above lines, uncomment the following three lines and customize example location to use DB2 These lines are the same in the webUI interface. After fulfilling them in the UI wizard, you can choose to test your db connection. It should return green thick :-) 5. enjoy! Now you can enjoy the new db running under your RTC. In case you would need to backup your data from Derby, check here: https://jazz.net/help/rational-team-concert/1.0/index.jsp?topic=/com.ibm.team.install.doc/topics/t_migrate_derby_db2.html Hope this helped, Regards Blazej Post scriptum: You can find this also here: http://jezzyk.blogspot.com/2009/05/rational-team-concert-migrating-from.html |
Be the first one to answer this question!
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.