Re: DB2 offline backups.

2005-02-17 Thread John E. Vincent
Look into the sessions option for the backup: http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0006203.htm Muthyam Reddy wrote: ** High Priority ** Kind men, As I could not find in IBM docs, I am querying these questions to the experts, In my environment

DB2 offline backups.

2005-02-17 Thread Muthyam Reddy
** High Priority ** Kind men, As I could not find in IBM docs, I am querying these questions to the experts, In my environment we have a production database size of 550Gb which takes 3hrs for online backup to tape storage pools which is fine for me. When I tried for offline backup on same databa

AW: DB2 offline backups

2005-02-02 Thread Salak Juraj
L@VM.MARIST.EDU > Betreff: DB2 offline backups > Wichtigkeit: Hoch > > ** High Priority ** > > Hi, > We have DB2 database of size 530GB and it takes 3hrs time for > online backup with 4 tsm drives. When tried with same TSM/DB2 > parameters and drives for offline backup it taki

DB2 offline backups

2005-02-02 Thread Muthyam Reddy
** High Priority ** Hi, We have DB2 database of size 530GB and it takes 3hrs time for online backup with 4 tsm drives. When tried with same TSM/DB2 parameters and drives for offline backup it taking 7hrs. I know it should take far less time for offline backups compare to online. I appreciate if a

DB2 offline backups on WINNT

2004-10-30 Thread Sandra
Dear All, Since we don't have any DB2 Administrator therefore I am not going into taking online backups of DB2. The application that is using DB2 taking DB2 backups by first shutting doen the database and then taking backups using DB2 commands and then starting the database. They keep this backedup