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
Beck Tang replied
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.