Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Shared Resources

> Displays status information about shared database resources. Figure 19–28 shows a sample Shared Resources Status display.

>     09/25/03          Status: Shared Resources
>     16:24
>     Active transactions:                       1
>     Lock table entries in use:                 8 of 8192
>     Lock table high water mark:                9
>     Number of servers:                         0 (5 allocated)
>     Total users:                               1 (20 allocated)
>        Self service:                           1
>        Remote:                                 0
>        Batch:                                  0
>     Watchdog status:                           *** Not executing ***
>     BIW status:                                Executing
>     AIW status:                                *** Not executing ***
>     Number of page writers:                    1
>     Number of monitors:                        1
>     Number of semaphores allocated:            29
>     Shared memory allocated:                   1408 K (1 segments. The last
>     segment was not locked in memory)

> Figure 19–28: PROMON Shared Resources Status display

> The display contains the following fields:

> - Active transactions — The number of currently active transactions.

> - Lock table entries in use — The number of lock table entries that are currently being used, and the total number of entries available.

> - Lock table high water mark — The maximum number of lock table entries that were in use simultaneously.

> - Number of servers — The number of servers running.

> - Total users — The number of users, broken down by the following types: Self service, Remote, and Batch.

> - Watchdog status — Executing, if the Watchdog process is executing; Not executing, if the Watchdog is not executing.

> - BIW status — Executing, if the BIW is executing; Not executing, if the BIW is not executing.

> - AIW status — Executing, if the AIW is executing; Not executing, if the AIW is not executing.

> - Number of page writers — The number of APWs running.

> - Number of monitors — The number of Monitor processes running.

> - Number of semaphores allocated — The number of UNIX semaphores allocated.

> - Shared memory allocated — The amount of shared memory allocated, in kilobytes and in segments. For more information an shared-memory allocation, see Chapter 13, " Managing Performance."

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095