Posted on 2011-02-15
I have got an error 'SQL0964C The transaction log for database is full. SQLSTATE=57011' on my DB2 v9.7 HP-UX.
Now, in order to resolve this issue I increased my primary and secondary log files to 50 each. Also, I set my
ARCHMETHOD1 to DISK:<Path> where <Path> is equal to 20GB in size.
Now, can you tell me if take my online backup after every week and then after 3rd week, can I delete the 1st week archived log files along with the history and backup in order to claim the space back.
Kindly do remember that we could only take an offline backup after 3-4 months as this is not possible for us.