Tablespace in rollforward pending state following a crash recovery

Technote (FAQ)


Question

Why sometimes some tablespaces are put into rollforward pending state following a crash recovery

Answer

During a crash recovery procedure, if the tablespace containers for a certain tablespace becomes inaccessible, no logs are replayed against that tablespace, rendering it out of synchronization with the other tablespaces in the database. This results in, that particular tablespace state of, 'offline' and 'rollforward pending'.

Once the containers are accessible again, and database restarted, the tablespace switches its state from offline to online, but continues to remain in the rollforward pending state. A rollforward against the tablespace to 'end of logs and complete' would bring it out of the 'rollforward pending' state.


Related information

ROLLFORWARD DATABASE

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows
Recovery - Crash Recovery

Software version:

9.1, 9.5, 9.7, 10.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1644505

Modified date:

2013-08-23

Translate my page

Machine Translation

Content navigation