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

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.

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

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

I did start but whenever I am going to execute backup thropugh Control Center, I am getting this error.

Thanks Grofaty.