Kbase P113788: Error 1404 when starting the database with -aiarcinterval 0
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/05/2010 |
|
Status: Verified
SYMPTOM(s):
Error 1404 when starting the database with -aiarcinterval 0
The -aiarcinterval parameter requires an argument greater than 0. (1404)
Cannot specify on-demand aiarchive interval when starting an ai archive enabled database
The database broker startup terminates when -aiarcinterval startup parameter is set to 0
FACT(s) (Environment):
OpenEdge 10.1x
OpenEdge 10.2x
All Supported Operating Systems
OpenEdge Category: Database
CAUSE:
The database startup argument processor does not allow values of 0.
FIX:
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.
NOTE: 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)"