Backups in DB2 for a Newbie

Edeshi · #1 (**permalink**) 02-18-09, 10:56

Well, like the title says im a complete newbie in DB2, what i need is a "How to back up a Database in DB2 for Dummies" Tutorial, any suggestions ?

What i need to do is to copy an entire database from a computer to another, i have already done a security backup in a file that has a .001 Extension, but i dont know how to get it into the other comp.

Thanx in advice

E.

nick.ncs · #2 (**permalink**) 02-18-09, 10:59

Well I would suggest you TRY TO DO IT YOURSELF first and if you face any issues you can always ask here.....

The best place to start is http://publib.boulder.ibm.com/infoce...w/v9/index.jsp

Also if you are thinking of copying the database from Windows DB2 to a Linux DB2 or AIX DB2 then let me just tell you that is not possible..... same is the case with backing up a db in 8.2 and trying to restore it in 9.5

It would also be great if you let us know which DB2 version you are using,

Edeshi · #3 (**permalink**) 02-18-09, 11:02

Quote:

Originally Posted by nick.ncs

Well I would suggest you TRY TO DO IT YOURSELF first and if you face any issues you can always ask here.....

The best place to start is "DB2 Information Center"

my friend if i am here is because i have already tried to do it myself.
my issue is that i have NO IDEA whats next after i made the Security Backup

thanx pal

Its a Backup From Windows Server 2003 to Windows XP hope that there is no problem on that

nick.ncs · #4 (**permalink**) 02-18-09, 11:07

Quote:

Originally Posted by Edeshi

my friend if i am here is because i have already tried to do it myself.
my issue is that i have NO IDEA whats next after i made the Security Backup

If you could take a backup yourself, restoring the same is equally easier and should have been a non-issue

Search for RESTORE DATABASE Command in the Info Center.

Edeshi · #5 (**permalink**) 02-18-09, 13:22

Quote:

Originally Posted by nick.ncs

If you could take a backup yourself, restoring the same is equally easier and should have been a non-issue

Search for RESTORE DATABASE Command in the Info Center.

THANX a LOT

I have now the database copied but i got a SQL0290N when im trying to see the contents of the tables, it says there is a problem accessing table spaces

i guess that i missed something while i made the backup or something. Any Suggestions ?

thx again in advice, u know, its hard to be a headache newbie that looks like dont know what "raft" means, im working on leaving that status as soon as posible

ARWinner · #6 (**permalink**) 02-18-09, 13:56

Did you user the DB2 BACKUP command, or just copy the files? I ask, because I do not know what you mean by "Security Backup".

Andy

n_i · #7 (**permalink**) 02-18-09, 14:02

Quote:

Originally Posted by Edeshi

u know, its hard to be a headache newbie that looks like dont know what "raft" means, im working on leaving that status as soon as posible

You will do yourself and many others a huge favour by reading this: Must Read before posting - it is made sticky for a reason.

Another hint - some people will not even read to the end a posting made in lolspeak.

Edeshi · #8 (**permalink**) 02-18-09, 15:02

Quote:

Originally Posted by ARWinner

Did you user the DB2 BACKUP command, or just copy the files? I ask, because I do not know what you mean by "Security Backup".

Andy

yes i used the Backup Command

Edeshi · #9 (**permalink**) 02-18-09, 15:14

Quote:

Originally Posted by n_i

You will do yourself and many others a huge favour by reading this: Must Read before posting - it is made sticky for a reason.

Another hint - some people will not even read to the end a posting made in lolspeak.

Is there anything in this post that HAS SOMETHING to be about how to solve the problem?

i am not asking you to solve my problem, im asking for help about stuff that i dont know how to handle right. You can be mean but that will not help solve the problem so... why post something that doesnt help ?

Another hint - a Newbie post doesnt mean "Come here to make this guy looks like a fag"

ARWinner · #10 (**permalink**) 02-18-09, 15:24

Was it an online or offline backup?

Andy

n_i · #11 (**permalink**) 02-18-09, 15:25

Quote:

Originally Posted by Edeshi

Is there anything in this post that HAS SOMETHING to be about how to solve the problem?

Nobody here is obliged to solve your problems. If you want other people's help I think you should do your part too - at least state your problem correctly.

However, you seem to be unwilling to do even that. Good luck, then.