waiting on archive

[richard.crosh]

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.

[Norm]

On Aug 31, 2:13 pm, [e-mail] 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

[richard.crosh]

Norm wrote:

On Aug 31, 2:13 pm, [e-mail] 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.