Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    4

    Unanswered: DB2 BAckup & Restoration script

    Hi

    I am very much new to DB2 area.I want a shell script for backing and restoring DB2 in AIX environment.Could you people please help me in that?

    Thanks in Advance
    Shanker

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would use the DB2 Command Center to generate the DB2 commands. You can use SHOW SQL before executing it to copy the commands to a UNIX shell script.

    There is going to be a difference between an online and offline backup. If you have archive logging enabled, you will have specify the rollforward parms that want executed after the restore.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2006
    Posts
    4
    Thanks for the suggestion.I tried to do this but got error

    SQL4414N The DB2 Administration Server is not active.


    Explanation:

    The request cannot be processed unless the DB2 Administration
    Server is active.

    User Response:

    Start the DB2 Administration Server by issuing the command
    DB2ADMIN START, and reissue the request.



    I have stopped and start db2admin but still got the same error all the time.Please help

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    the error above describes you don't have DB2 Administration server started. Login into AIX as db2admin user and execute command: db2admin start

    Ask system administrator (or the person which installed DB2 on AIX) what is userid/password for DB2 Administration server.
    Hope this helps,
    Grofaty

  5. #5
    Join Date
    Aug 2006
    Posts
    4
    I did start but whenever I am going to execute backup thropugh Control Center, I am getting this error.

    Thanks Grofaty.

Posting Permissions

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