Kbase P54762: Test after image or backup with active transactions
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Test after image or backup with an active transaction
GOAL:
Verify your Backup and After-Image strategy
GOAL:
Program test for having one active transaction
FIX:
While testing the after image or backup strategy, it is key to have an active transaction on the database as they are potential problems there. For example missing the option "-norecover" on probkup (off-line) can be fatal for the roll forward.
Find below a program on sports database for having an active transaction running when you have either the message "Before commit transaction 2" or the message "Before commit transaction 1" (but not for the first time!) on the screen.
To stop the program, you can type CTRL-C or kill the user from promon.
<>
repeat:
do transaction:
for each customer:
name = " " + name.
end.
pause message "Before commit transaction 1".
end.
do transaction:
for each customer:
name = trim(name).
end.
pause message "Before commit transaction 2".
end.
end.
<>