Allows you to manually start the AIJ log server (ALS) for the
specified database and specify a file for the AIJ log server
output.
1 – Description
The ALS is an optional process that flushes log data to the
after-image journal (.aij) file. All database servers deposit
transaction log data in a cache located in the database global
section. If the ALS is active, it continuously flushes the log
data to disk. Otherwise, server processes might block temporarily
if the cache in the global section is full. The ALS should be
started only when AIJ processing is a bottleneck. Typically,
multiuser databases with medium to high update activity can
benefit from using the ALS.
You can start the ALS either manually, using the RMU Server
After_Journal Start command, or automatically when the database
is opened (by specifying LOG SERVER IS AUTOMATIC in the SQL ALTER
DATABASE command). By default, the ALS startup is set to manual.
2 – Format
(B)0[mRMU/Server After_Journal Start root-file-spec
[4mCommand[m [4mQualifier[m x [4mDefault[m
x
/Output=file-spec x See description
3 – Parameters
3.1 – root-file-spec
Specifies the database root file for which you want to start the
ALS.
4 – Command Qualifiers
4.1 – Output
Output=file-spec
Specifies the file for the ALS output file. Use this qualifier
in anticipation of issuing an RMU Server After_Journal Reopen_
Output command. By specifying the output file, you will know the
location of, and therefore can view, the ALS output file.
By default, the ALS output file is not available to the user.
5 – Usage Notes
o To use the RMU Server After_Journal Start command for a
database, you must have RMU$OPEN privilege in the root file
access control list (ACL) for the database or the OpenVMS
WORLD privilege.
o The ALS can be started only if the database is open and if
after-image journaling is enabled.
o The RMU Server After_Journal Start command can be issued while
users are attached to the database.
o If the ALS process stops abnormally, regardless of whether the
current setting of the ALS is automatic or manual, the only
way to restart it is to use the RMU Server After_Journal Start
command.
o To determine whether the ALS is running, use the RMU Show
Users command.
o Any errors encountered when you try to start the ALS are
logged in the monitor log file. Use the RMU Show System
command to find the location of the monitor log file.
6 – Examples
Example 1
The following Oracle RMU command starts the log server.
$ RMU/SERVER AFTER_JOURNAL START MF_PERSONNEL