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.
|
6 answers
hi,
Please still use RAM setup. Go back to the database configuration step and point to the Dev RAM db. Thanks a lot. |
|
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 ?
|
|
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.
|
|
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 ?
|
|
Hi,
After restoring the databases and running the RAM setup again we are getting the below error.
|
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.