Kbase P87757: How to know the size of a transaction?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to know the size of a transaction?
FIX:
The "size" of a transaction can be measured with the amount of BI notes generated for it.
There is no way to read a BI file but as the AI notes, within an AI extent, are the equivalent to the BI notes you can measure a transaction if you have After-Image enabled.
While having the AI extent where was recorded the transaction, you could for example extract the number of AI notes registered for that transaction.
Suppose your database is called life and you have life.a2 corresponding to the time of the begin transaction and life.a3 the current AI extent. You have earlier run a "prodb dummyDB sports" to have a database copy within your current directory.
rfutil dummyDB -C aimage scan verbose -a life.a2 > AIscan
rfutil dummyDB -C aimage scan verbose -a life.a3 >> AIscan
You identify the transaction number with the time of the begin transaction and the AI notes RL_TBGN.
For example transaction 3815 started on Mon May 3 11:33:38 2004.
code = RL_TBGN (1637)
transaction index = 3185 (1638)
dbkey = 0 update counter = 0 (1639)
Trid: 3185 Mon May 3 11:33:36 2004. (2598)
User Id: sgr. (2599)
You count the AI notes for transaction 3815 with the command
cat AIscan | grep "3185 (1638)" | wc -l