467,189 Members | 1,280 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

waiting on archive

Receive this message in db2diag.log:
MESSAGE : DB2 is waiting for log files to be archived.
Database hangs. Using DB2 8.2.2 on Solaris with Veritas backup
software.

Does anyone else experience this? Have you solved the hang problem?

Thanks.

Aug 31 '07 #1
  • viewed: 2809
Share:
2 Replies
On Aug 31, 2:13 pm, richard.cr...@ama-assn.org wrote:
Receive this message in db2diag.log:
MESSAGE : DB2 is waiting for log files to be archived.
Database hangs. Using DB2 8.2.2 on Solaris with Veritas backup
software.

Does anyone else experience this? Have you solved the hang problem?

Thanks.
Have you run out of active log space? DB2 cannot function if there is
no active log space to keep track of transaction updates. It will
appear to hang if there is no space. When you get a successful
archive, space is made available and your "hang" goes away.

If this is the case, you need to add more disk to your active log path
or move your active log to a file system with more space.

Norm

Sep 4 '07 #2

Norm wrote:
On Aug 31, 2:13 pm, richard.cr...@ama-assn.org wrote:
Receive this message in db2diag.log:
MESSAGE : DB2 is waiting for log files to be archived.
Database hangs. Using DB2 8.2.2 on Solaris with Veritas backup
software.

Does anyone else experience this? Have you solved the hang problem?

Thanks.

Have you run out of active log space? DB2 cannot function if there is
no active log space to keep track of transaction updates. It will
appear to hang if there is no space. When you get a successful
archive, space is made available and your "hang" goes away.

If this is the case, you need to add more disk to your active log path
or move your active log to a file system with more space.

Norm
How do I know if I am out of active log space? Wouldn't there be a
message in db2diag.log? The hang does go away once the archive
completes. I will increase log space and see what happens.

Sep 5 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by labrach | last post: by
1 post views Thread by DB2 Convert | last post: by
7 posts views Thread by William | last post: by
7 posts views Thread by Enigma Curry | last post: by
2 posts views Thread by mkvenkit.vc@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.