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

How to Restore RAM Production DB instance to RAM Dev instance

 Hi,

We have a RAM production instance running on version -7.5.1 using a DB2 database by name UISRAMDB (which has lot of data in it)

Similarily we have another RAM dev instance which is running on version - 7.5.2.1 Configured to use DB2 Database (it is a new installation) (Three Databases has been created as a part of installation - RAMDB,RTCDB and JTSDB)

Our Requirement is ?

We want the production DB instance to be mirrored to the prepod instance to complete the testing ?

What we have done >>>

1. In Dev instance we have created an empty database by same name UISRAMDB.
2. Took the backup of the PROD DB instance UISRAMDB and copied the file over to the dev server.
3. Ran the restore command from the Dev Server.

My question here is how will we make Dev RAM point to the database (UISRAMDB) in which we have restored the production data to.

0 votes



6 answers

Permanent link
hi,
Please still use RAM setup. Go back to the database configuration step and point to the Dev RAM db.
Thanks a lot.

0 votes


Permanent link
  Hi,

The production RAM is on 7.5.1 and if I remember in the older RAM we need only two databases ie one for RAM and one for RTC 

Here we have only two databases 1. UISRAMDB and other one is 2. JTSDB

These two databases we need to restore to the new instance of RAM Version 7.5.2.1 with DB2 10.1

With the new RAM setup I noticed we have to create three dbs RAM,CCM,JTS 

What I have done now is on the new server from DB2 command window ran the db2 restore command against the prod database back which is copied over to the new RAM server.

E:\Softwares\UISRAMDB backup12-08-2014>db2 restore database UISRAMDB taken at 20140812134339
SQL2555I  The database was restored and then successfully upgraded to the
current DB2 release where you issued the RESTORE DATABASE command.

E:\Softwares\RTCDB Backup12-08-2014>db2 restore database RTCDB taken at 20140812132738
SQL2555I  The database was restored and then successfully upgraded to the
current DB2 release where you issued the RESTORE DATABASE command.

During RAM 7.5.2.1 setup I think I can specify the current UISRAMDB ad RAM DB and RTCDB as CCMDB.

What about JTS DB ? 

0 votes


Permanent link
 Hi,

I followed the step you suggested -- Go back to the database configuration step and point to the Dev RAM db. Got the below setup page. 

Look like we need to copy the RTC 2.0 zip file file from the 7.5.1.1 RAM instance and proceed with the setup

Currently I am stuck at the below window.

ram_db_migrate

0 votes


Permanent link
Install location for RTC 2.0 I just specified a folder similar to the one showing for RTC 3.0 and and 4.0 

E:\Program Files (x86)\IBM\WebSphere\profiles\AppSrv01\config\cells\INBLR-3DBPDEVNode01Cell\RTC\server1

Similarly entered the paths for RTC and JTS cliked Migrate Button which took me to me the last page with out any warnings.

Another question I have is ?

Do we need to copy the RAM_Persist folder from the production server and replace the existing persist folder content with the old one ?




0 votes


Permanent link
 Hi,

After restoring the databases and running the RAM setup again we are getting the below error.

ram_db_err

0 votes


Permanent link
Please find the below message when we click on Migrate button

Migration Required
Couldn't find migration path between current version and desired version. Current repository version is 7.5.1.1.v20120730tf5 and software installed is at version 7.5.1.1.v20120229.

The Rational Asset Manager repository is not the correct version.

IBM Rational Asset Manager 7.5.1.1

The current database version is 7.5.1.1.v20120730tf5 and the software that is installed expects the database version 7.5.1.1.v20120229.

Click the Migrate button to perform the migration. Before migrating, back up the database and persistence storage in case there are errors during migration.     

We have tried redoing the whole setup and still have the same issue.

0 votes

Comments

 Any suggestion for applying a particular fix pack would be of great help. We tried applying a cumulative fix pack which did not fix the issue. 



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

Question asked: Sep 05 '14, 6:11 a.m.

Question was seen: 5,499 times

Last updated: Sep 30 '14, 8:46 a.m.

Confirmation Cancel Confirm