Library /sys$common/syshlp/HELPLIB.HLB  —  RMU72  Server After Journal, Start
    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)0RMU/Server After_Journal Start root-file-spec

  Command Qualifier  x Default
                     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
Close Help