Hello,

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.

What is the procedure?

Thanx

Create database from backup: restore database (you need this).
Create database using Wizard: create new database (you don't need this).

Hey, thanks

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? )

Hi,

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).

Hope this helps,
Grofaty

Hi, thanks

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:
SQL00001
SQL00002
SQLDBDIR

( 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 ????

Thank you

What you have is

====>>> a backup file in the form of

<database_name>.<0>.<instance_name>.<Node_name>.<c at_name>.<timestamp>.<file_no>

This image can be restored to any database under an instance as long as any instance can read it.

First try to get an offline backup because online backup is difficult to restore using

backup database <database_name>

No application should be connected.

You can use this command to find what application are connected

list applications

Then use

force application all // This will force all application under an instance(all databases).


2. The OS(Window) of both the server must be same.It doesn't matter whether they are on shared drive or not, as long as the db2 instance can read the image file.

3.
Use restore database <database_name> taken at <timestamp>

In window you need to create all the directory structure like database_name and put the image at that place, sorry I am not a very good window guy.


regards

Mujeeb

Thank you,

one more question: I am attempting to make a backup of db. What am I supposed to do before executing:

BACKUP DATABASE TEST1
TO D:\BACKUP_TEST1


Is the circular logging better to chose than archival logging? What is the best selection?

Thanx

If you use circular logging then you can only take an offline backup, meaning there must be no connections to the database during the backup process.

Archive log mode allows you to take an online backup; in that case you have to copy the archived log files to the target system, in addition to the backup image itself, and roll forward the database.

1. offline can be done , only when no application connected to the database.

use

db2 list applications.

2. If there are force the application out

db2 force application all // for all applications under the instance
or
db2 force application<appl_id> // specific application.

3. do the backup

db2 backup database <database_name>

You can also use the

db2 quiesce database <database_name> immediate force connections
db2 terminate.
db2 backup db <database>

regards

Mujeeb

Thank you, Guys

Your assistance was a great leap into my knowledge of administration of DB2.

I succeeded in cerating backup, choosing right Logging procedure then I succesfully restored the DB.

Thanks a lot.

The db2 is lot more than backup/restore.Its a software that is really fun to
work. Welcome to the world of db2


mujeeb