Kbase P5497: UNDO TRANSACTION does not work on AS400.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/11/2003 |
|
Status: Unverified
FACT(s) (Environment):
IBM AS/400 (RISC)
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
UNDO TRANSACTION does not work on AS400.
Client/Server connection with default parameters.
CAUSE:
One of the most common reasons is that the physical files of DB2/400 Database are not journaled and the -Dsrv TRANSCTL parameter is set to OPTIONAL (default value). In order to be able to rollback the transaction the previous (historical) notes of the records must be kept.
FIX:
Pull the files (tables) you want to have rollback control over into the journaling mechanism:
1. Create a journal receiver, create a journal, start journaling of the PFs you need. In this case the default TRANSCTL=OPTIONAL parameter can be used as Commitment Control will be in effect for journaled files only and not for the rest, or
2. Start the journaling of all database files and use the parameter TRANSCTL=COMMIT. It will give an error message if any of the db files are not journaled.