Kbase P38916: promon Activity sampling using incorrect elapsed time
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  06/04/2004 |
|
Status: Unverified
FACT(s) (Environment):
AIX 4.3.3
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
promon Activity sampling using incorrect elapsed time
Initial promon Activity display returns incorrect elapsed time for sample
promon Activity sample always shows 1 sec as initial value
CAUSE:
The database was started while the system date was set forward to a future date and then was reset backwards. When the system time is reset backwards, this isn't reflected in the database.
The initial promon Activity display should calculate the elapsed sample time using the database startup time as its starting point. If the last start up time is a date and time later than the current time, promon returns (incorrectly) a 1 second value for the elapsed time.
Subsequent calculations of elapsed time take the date and time of the last sample as their starting point, and return correct values.
The following example was tested with 9.1D06 on AIX 4.3.3
1. prodb sports sports
2. proserve sports; promon sports
3. 5. Activity:
Activity - Sampled at 08/26/03 08:54 for 0:01:03.
Or under promon > R&D > 2. Activity > 1. Summary
08/26/03 Activity: Summary
09:02:39 08/26/03 08:53 to 08/26/03 09:02 (8 min 20 sec)
4. proshut sports -by
5. As root user, change the system date forward using the DATE command. Before carrying this out, check man date on your system for details and ensure to back up any files that might be affected. In this example the date was set to 17 Feb 14:25:00 2012:
date 0217142512
6. proserve sports; promon sports
7. 5. Activity shows:
Activity - Sampled at 02/17/12 14:26 for 0:00:10. This is of correct.
8. proshut sports -by
9. Change the date back: date 0826092503
10. proserve sports; promon sports
7. 5. Activity always returns 1 second for the initial reporting interval
Activity - Sampled at 08/26/03 09:26 for 0:00:01.
Subsequent samples are ok, however.
promon > R&D > 2. Activity > 1. Summary shows the same behaviour, i.e. the initial sampling value is incorrect, the subsequent ones correct.
FIX:
Dump and load the database.