Kbase P33822: How to generate partially readable output from an After Imag
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/30/2004 |
|
Status: Unverified
GOAL:
How to generate partially readable output from an After Image file.
FACT(s) (Environment):
Progress 6.x
FACT(s) (Environment):
Progress 7.x
FACT(s) (Environment):
Progress 8.x
FACT(s) (Environment):
Progress 9.x
FIX:
In some situations it might be beneficial to read the information contained within an After Image file. Some situations which might require such an operation are: Identifying when a transaction posted in a database, and determining when a user performed operations against specific blocks within the database for security purposes it is useful to run.
If you have after imaging enabled and the AI have recorded the period of time you wish to review you may give the following command against any database (empty, sports, etc) to review the notes contained with the AI file:
rfutil <dbname> -C aimage scan verbose -a <ai file name>
This will output Progress specific reference notes which contain user ID; times;area number; transaction ID and the compressed notes which denote the types of actions performed against the block within the database.
Example of output from rfutil <dbname> -C aimage scan verbose -a <aifilename>:
After-image dates for this after-image file: (1633)
Last AIMAGE BEGIN Fri Jul 25 13:44:57 2003 (1640)
This file was last opened for output on Fri Jul 25 13:58:33 2003. (1643)
code = RL_INMEM (1637)
transaction index = 0 (1638)
dbkey = 0 update counter = 0 (1639)
code = RL_LSTMOD (1637)
transaction index = 0 (1638)
area = 6 dbkey = 32 update counter = 10 (9016)
code = RL_TBGN (1637)
transaction index = 1484 (1638)
dbkey = 0 update counter = 0 (1639)
Trid: 1484 Fri Jul 25 13:58:20 2003. (2598)
User Id: username. (2599)
code = RL_CXREM (1637)
transaction index = 1484 (1638)
area = 10 dbkey = 2176 update counter = 4 (9016)
code = RL_CXINS (1637)
transaction index = 1484 (1638)
area = 10 dbkey = 2176 update counter = 5 (9016)
code = RL_RMCHG (1637)
transaction index = 1484 (1638)
area = 9 dbkey = 96 update counter = 11 (9016)
code = RL_TEND (1637)
transaction index = 1484 (1638)
dbkey = 0 update counter = 0 (1639)
Trid: 1484 Fri Jul 25 13:58:20 2003. (2598)
7 notes were processed. (1634)
0 in-flight transactions. (3785)
1 transactions were started. (1635)
At the end of the .ai file, 0 transactions were still active. (1636)