Hello,
I have a beginner's question regarding db backups, and in particular with db2.
Until now, I was using the arsdb tool to perform offline backups of the db2 database of the CMOD MP instance. Until I noticed that the LOGSTREAM directory of the db which, I believe, contains the transaction logs, was not cleaned as I thought by performing an offline backup.
I contacted IBM support for explanations, and they told me that it was not recommended to use arsdb to make backups, that it relied on a userexit function that was no longer supported since version 9. I am surprised that this important information does not appear clearly somewhere.
In the meantime, I will therefore use the backup function of db2. What do you think of my backup script?
net stop "OnDemand....."
db2 terminate
db2 deactivate db ARCHIVE
db2 backup db ARCHIVE to D:\Backup WHITHOUT PROMPTING
db2 activate db ARCHIVE
net start "OnDemand....."
Last but not least, could you please tell me if I can safely delete the files in the LOGSTREAM folder after doing a full offline backup?
Thanks