Unanswered: RE: How to copy existing DB to new machine?
we ( me and my partner ) are quite newbies to IBM UDB2. We are now on a threshold of launching / or better "copying" existing database from db server 1
to new db server 2. We successfully finished backup of db on server 1 and now we are facing problem how to launch ( "paste" ) db to server 2.
We put the database into a shared folder; then through IBM DB2 - Administration Tools - Control Center we created database from backup ( right mous-click on folder "Databases": Create - Database from Backup ).
Here we are not quite sure if this is right procedure. If it is Create - Database from Backup or Create - Database using Wizard ?????
Please give us a right idea on this. Basically we only want to "copy and paste" existing database to this new machine.
maybe I should write this in more detail. I am really newbie to DB2 administration, have never put my finger on it really.
So, from an existing database on SERVER 1 on separate PC we have managed to create backup of database setting logging to archival ( instead of circular ). We placed this databese to D:\database_01. We shared this folder. This was without any major problems.
NOW, we want to restore ("paste") this database_01 to SERVER 2 on another separate PC. At this point I am absolutely puzzled what to really do ????
I use Control Center; here am I supposed firstly to Creat Database from Backup?? If yes, at first step titled: DEFINE THE LOCATION INFORMATION FOR YOUR NEW DATABASE these fields appear:
1. Database being restored ( Is this the database we have on shared folder D:\database_01 ? )
2. Name for new database ( This is rather explanatory )
3. Location of the database after restore
4. Location of the logs after restor ( Does this have to be a new blank folder? )
I think you can't restore database from 'shared volume'. I think database image must be copied to 'local volume'.
1. yes this is the database you make a backup from. So put the database name into this field.
2. new database name: if you would like to rename your database you can put new name in this field if not just put the same name as in first step.
3. put this field empty to restore it to system volume (it is probably C: volume)
4. you can put this empy, it depends if you would like to have log files on different disk volume or not (from performance point of view it is better to have on different disk volume).
Yes, I sort of was considering this. So now I have copied the backup database to C:\DB2\NODE0000. Under this dir there are already these folders:
( these folders were created after my partner finished instalation of DB2 application/client and created a default database from IBM DB Control Center tool )
The name of the database backup folder is 20050214 ( date format when this backup was made on another PC ). It contains a file of 1,5Mb named as 152037.001 ( I think it is a time of backup ). What would I do now? Rename the folder to e.g. SQL00003 ????