Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Join Date
    Feb 2009
    Posts
    9

    Unanswered: Backups in DB2 for a Newbie

    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.

  2. #2
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    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,
    Last edited by nick.ncs; 02-18-09 at 12:02.
    IBM Certified Database Associate, DB2 9 for LUW

  3. #3
    Join Date
    Feb 2009
    Posts
    9
    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

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    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.
    IBM Certified Database Associate, DB2 9 for LUW

  5. #5
    Join Date
    Feb 2009
    Posts
    9
    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

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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: http://www.dbforums.com/db2/854783-m...e-posting.html - it is made sticky for a reason.

    Another hint - some people will not even read to the end a posting made in lolspeak.
    ---
    "It does not work" is not a valid problem statement.

  8. #8
    Join Date
    Feb 2009
    Posts
    9
    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

  9. #9
    Join Date
    Feb 2009
    Posts
    9
    Quote Originally Posted by n_i
    You will do yourself and many others a huge favour by reading this: http://www.dbforums.com/db2/854783-m...e-posting.html - 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"

  10. #10
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Was it an online or offline backup?

    Andy

  11. #11
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.
    ---
    "It does not work" is not a valid problem statement.

  12. #12
    Join Date
    Feb 2009
    Posts
    9
    Quote Originally Posted by ARWinner
    Was it an online or offline backup?

    Andy
    it was an online backup

  13. #13
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Did you rollforward the DB after the RESTORE?

    Andy

  14. #14
    Join Date
    Feb 2009
    Posts
    9
    Quote Originally Posted by ARWinner
    Did you rollforward the DB after the RESTORE?

    Andy

    it doesnt let me do that

    MESSAGE : Rollforward failed to connect to database. sqlcode -980.

  15. #15
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version on each server and which OS on each server are you using?

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •