Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

log archive partition is full

In windows 2003 + db2 combination, archive log partition is full now so can anybody tell me how to archive the logs and delete it from DB2 system level.

I would appreciate the procedure with steps and prerequisite.

Thanks in advance

Former Member replied

Hello Daniel,

I am not sure about your current situation. So, I can only guess.

I supposed the drive that hold your log_archive directory becomes full at a certain point. When that happens, DB2 will keep on trying to archive the logs to the log_archive directory. And when it fails, the logs will stay in log_dir and thus your log_dir and gradually fill up log_dir until it is full as well.

Now that your log_archive has more space, DB2 will try to archive the logs from log_dir to log_archive again and in the end, all the archive logs that are supposed to be in log_archive should be in log_archive.

Once the logs are moved to log_archive. You can save them to a safe location (TSM or tape drives) OR "prune" them once you have determined that you don't need them any more.

Regards,

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question