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