Kbase P14503: Rollforward AI and changes in the database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Rollforward AI and changes in the database
GOAL:
Rollforward AI after a dump/load of the database
GOAL:
Rollforward AI after having started a DB server or access the DB in single user mode
FIX:
It is not possible to rollforward an AI extent on a database after any change made within that database.
A dump/load of the database has not changed the data in the database, but it has changed the location (RECID) of that data.
An access to the database, either start of a DB server or a single user connection, might result in the UNDO of transaction(s) during crash recovery. This UNDO phase will change many values within the database, on data and index for example.
A "note" written within a AI extent can be replayed only if the database is exactly as it was at the time this note was written.