Kbase P121045: How to determine the number of transaction over a period of time in a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/11/2006 |
|
Status: Unverified
GOAL:
How to determine the number of transaction over a period of time in a database?
FIX:
To get the count of transactions occurring in a database over a period of time:
Method one:
1. Run promon database name
2. Select number 7 (Database Status)
3. Record the current (Last Transaction number)
4. After the lapsed time take the new reading
5 Take the difference between the two readings.
6. The difference should represent the number of transactions between the two points
Method two:
1. Run After imaging
2. Scan the appropriate after image file(s) that represent the desired time period
3. rfutil <dbname> -C aimage scan -a <after image file>
note: You can use any stopped database name in the scan command to scan the after image files of a running database.