By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

waiting on archive

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a

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.