Kbase P166257: How to start an aiarchiver enabled database in on-demand mode ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2010 |
|
Status: Verified
GOAL:
How to start an aiarchiver enabled database in on-demand mode ?
GOAL:
Why can the -aiarcinterval database startup parameter requires an argument greater than 0. (1404)
GOAL:
How to change the archiver daemon from Timed to On-Demand mode
GOAL:
Can the archiver daemon timed interval be queried ?
GOAL:
Is the database archiver daemon using On-Demand or Timed mode to manage ai files ?
FACT(s) (Environment):
OpenEdge 10.1x
OpenEdge 10.2x
All Supported Operating Systems
FIX:
The database startup argument processor does not allow values of 0. If an "on demand" aiarchive interval is required, simply do not specify the -aiarcinterval database startup parameter and a 0 value is implied. The archiver daemon sets On-Demand mode as the default mode unless otherwise specified.
The setting can be confirmed in the database lg file startup parameters:
(13871) After-image Management Archival Method : On Demand.
NOTE: no (13872) message is posted in the database startup parameters when on-demand ai archiving is active.
When the archiver deamon timed-mode is activated, a valid aiarchive interval must specified as a startup parameter, ie: the value needs to be {120 .. 86400} seconds.
(13871) After-image Management Archival Method : Timed.
(13872) After-image Management Archival Interval (-aiarcinterval) : 14400
The "rfutil -C aiarchiver setinterval" functionality can be used to change the aiarchiver daemon mode or the aiarchiver interval online after the database is started.
For example: Should the database broker already be started in Timed mode, with any valid value for -aiarcinterval (120-86400), Timed mode can be changed to On-Demand mode by using the command:
$ rfutil dbname -C aiarchiver setinterval 0
(7129) Usr 7 set name to Aiarchiver setinterval.
(13211) The after-image management daemon has been notified about the new archive interval.
(453) Logout by Aiarchiver setinterval on CON:.
AIMGT 7: (13213) A new archive interval 0 has been set.
Similarily, On-Demand mode can be changed to Timed-mode, or the current Timed-mode can be changed to some other timed interval with the same "rfutil -C aiarchiver setinterval" functionality:
$ rfutil dbname -C aiarchiver setinterval 14400
(7129) Usr 13 set name to Aiarchiver setinterval.
(13211) The after-image management daemon has been notified about the new archive interval.
(453) Logout by Aiarchiver setinterval on CON:.
AIMGT 13: (13213) A new archive interval 14400 has been set.
NOTE1: Prior to OpenEdge 10.1A01, the interval was not properly validated and would change the interval to an improper setting. Since OE 10.1A01, an invalid value will error with "The specified archive interval is invalid. (13646)"
NOTE2: Apart from parsing the database lg file, neither the -aiarcinterval nor the after-image Management Archival Method can be queried in the current implementation of the product.