The need to monitor the AUS Server activities stems from the intent to ensure that the AUS service runs and functions correctly as intended to meet the statistics requirements for a database. Monitoring AUS Server also helps to prevent and address errors pertaining to statistics in time. It is in this sense, OpenEdge SQL ensures that the AUS Server is monitored proactively rather than as an after-thought. You can monitor the AUS Server activities at various levels using the following:

  • PROMON utility - PROMON is an OpenEdge specific database administration utility that you can run from the command line to monitor and view the status of database resource consumption such as number of active connections and the status pertaining to the AUS server and client. PROMON also allows you to control the AUS functions by switching the AUS server status ON/OFF from the Server Options menu as described in this topic..
    Note: For more details, refer the documentation on Manage OpenEdge Databases → PROMON utility.
  • VST (Virtual System Tables) - If you are connected to a SQL client and would like to view the AUS Server activity, consider viewing the information quickly from the VST by executing a SQL query. You can view the status of the AUS database startup parameter -SQLAutoStats in the _DbParams and the status of the AUS server AUTO-AUS in the _Servers VST. You can also control the AUS functions by switching the AUS Server status ON/OFF as shown below.

    Update pub."_dbparams" set "_DbParams-Value"='Off' where "_DbParams-Name"='-SQLAutoStats';

    Update pub."_dbparams" set "_DbParams-Value"='On' where "_DbParams-Name"='-SQLAutoStats';

    Note:
    • For more information on _DbParams, refer Manage OpenEdge Databases → Database startup parameters file status (_DbParams) guide.
    • For more information on _servers, refer Manage OpenEdge Databases → Servers (_Servers) guide.
  • Log file information - You can view the AUS log information from the AUS log and the <database>.lg files.
    • AUS log - The AUS log file captures information pertaining to the AUS service status and errors, if any. The log file essentially captures the DPCA and other configuration related parameters. The AUS service can be controlled using the following SQL commands (like other AUTOUPDATE STATISTICS commands).
      Note: For these commands to execute correctly, a user must ensure that the AUS service is ON otherwise the following error will be encountered.

      [DataDirect][OpenEdge JDBC Driver][OpenEdge] Can not switch AUS logging state while AUS service is disabled. (19379)

      • AUTOUPDATE STATISTICS LOG ON This command enables or switches on the AUS logging feature and will generate the log files for the first time. Once log files are generated they will be written with AUS related information that can be later consumed for debugging purpose.
      • AUTOUPDATE STATISTICS LOG OFF This command disables or switches off the AUS logging feature and any AUS related information will not be written in the log files.

      See Error codes, SQLSTATE values, and messages in the OpenEdge SQL Reference guide.

    • <database>.lg file - Once an AUS server is spawned, you can view its log information in the <database>.lg (OpenEdge database log file) using the AUS PID. The log file holds all the AUS transaction details. It helps you to check for any errors and take corrective action.

Steps to view AUS server activities using the PROMON utility

Perform the following steps to view and monitor the AUS server activities:

  1. Execute the PROMON utility. The main menu appears.
                        OpenEdge MONITOR Release 12

                    Database: /usr/wrk/sports2020

                    1. User Control
                    2. Locking and Waiting Statistics
                    3. Block Access
                    4. Record Locking Table
                    5. Activity
                    6. Shared Resources
                    7. Database Status
                    8. Shut Down Database
                    9. Currently Connected Tenants

                  R&D. Advanced Options
                    T. 2PC Transactions Control
                    L. Resolve 2PC Limbo Transactions
                    C. 2PC Coordinator Information

                    J. Resolve JTA Transactions

                    M. Modify Defaults
                    Q. Quit

                    Enter your selection:
  2. Enter R&D. The R&D Advanced Options menu appears.
                        11/27/18        OpenEdge Release 12 Monitor (R&D)
01:24:54        Main (Top) Menu

                 1. Status Displays ...
                 2. Activity Displays ...
                 3. Other Displays ...
                 4. Administrative Functions ...
                 5. Adjust Monitor Options

Enter a number, <return>, P, T, or X (? for help):
  3. Enter 4. The Administrative Functions Menu appears.
                        11/27/18        OpenEdge Release 12 Monitor (R&D)
01:25:13        Administrative Functions Menu

                 1. Check Active Transaction Status
                 2. Check Two-Phase Transactions
                 3. Resolve Limbo Transactions
                 4. Adjust Latch Options
                 5. Adjust Page Writer Options
                 6. Restricted Options
                 7. Server Options
                 8. Enable/Disable block level consistency check
                 9. Shutdown Database
                10. Disconnect a tenant's users
                11. Adjust Governor options
                12. Toggle redundantlockdiag setting
                13. Caches
                14. Diagnostic Data Collection
                15. Database log file management

Enter a number, <return>, P, T, or X (? for help):
  4. Enter 7. The Server Options menu appears displaying the status of the SQL Autonomous Statistics.
    11/27/18        OpenEdge Release 12 Monitor (R&D)
01:26:05        Server Options

                 1. Server network message wait time:             2 seconds
                 2. Delay first prefetch message:                 Disabled
                 3. Prefetch message fill percentage:             0 %
                 4. Minimum records in prefetch message:          16
                 5. Suspension queue poll priority:               0
                 7. Terminate a server
                 8. User notify time:                             0 seconds
                 9. Limit .lg message payload:                    Disabled
                10. SQL Autonomous Statistics:                   ON

Enter a number, P, T, or X (? for help):
  5. Select 10 to toggle the setting to enable or disable the AUS service.