Wednesday 6 July 2011

Configuring Logarchmeth1 in DB2 & TAKING OFFLINE BACKUP

O/S:- AIX 6.1 1.  Login as db2<sid>(ex db2qas)
2.  Start db2 with "db2start" command, if its not started.
3.  Connect to respective system via "db2 CONNECT to QAS".
4.  Give command "db2 UPDATE DB CFG FOR QAS USING LOGARCHMETH1 DISK:/DBbackup/QASbackup/LogBackup".
5.  It will now show the Confirmation message Like "DB2 Configuration Has been updated".
6.  Now its must to take offline backup of the database( db2 forces it as it will give message db backup pending).
7.  Now issue command "db2 connect reset".
8.  Stop db2 by "db2stop". -- not mandatory I am writing it because I did it this way
9.  Start db2 by "db2start".  -- not mandatory I am writing it because I did it that way
10. Issue offline backup command "db2 BACKUP DATABASE QAS TO "/DBbackup/QASbackup". --for backup to disk
      or
11. Issue offline backup command "db2 BACKUP DATABASE QAS TO "/dev/rmt0". --for backup to tape
After taking the offline backup you can work with your database normally.
ENJOY POWERPLAY!!!!!!!

Any quries , please contact sathyarthiss ...
satyarthivarun@gmail.com