Hi,

I am trying to online backup for 8 tablespaces

First I have configured LOGARCHMETH1 using

db2 update db cfg for visilog using LOGARCHMETH1 DISK:/data1/db2inst1/visilog

and issuing command

db2 "backup db visilog tablespace (SYSCATSPACE,TEMPSPACE1,USERSPACE1,SYSTOOLSPACE,TS 32,TS8,TSSTMP32,TSSTMP8) online"

still i am getting error like

[db2inst1@brahmagupta ~]$ db2 "backup db test tablespace (SYSCATSPACE,TEMPSPACE1,USERSPACE1,SYSTOOLSPACE,TS 32,TS8,TSSTMP32,TSSTMP8) online"
SQL2421N Table space level backup is not allowed because roll-forward
recovery is not enabled.

Please suggest me...

u need to force off all application and take a offline backup then only ur configured parameter gets enabled.. chk db2 get db cfg show detail and chk the LOGARCHMETH1 status...

once offline db backup taken it will allow to take the tablespace level online backup

regds
Paul

Yeah thnx alot..

It worked...

One more doubt, is restore procedure is same for both online and offline backups??

Restore is the same; it's rollforward that is different.