DB2 online backup/restore
Posted on 2002-07-26
I'm configuring online backup for my DB2 using Tivoli Storage Manager. Following DB2 and TSM document, I think I got it right.
In my testing the backup(online) and restore, this is what I did.
1. created a test table named TESTB and inserted some data.
2. performed a online backup successfully.
3. cleared table TESTB.
4. performed the resotre. The process finished succefully.
5. query table TESTB. The data should come back. right?
my result is not. The table is still cleared.
Is my procedure proper?
BTW, I enabled the USEREXIT and LOGRETAIN parameter, built the user exit executable for TSM, did whatever need on TSM side.