Displays status information about shared database resources.
PROMON Shared Resources Status display
The following shows a sample Shared Resources Status display.
10/08/14 Status: Shared Resources
17:27:37
Active transactions: 0
Lock table entries in use: 0 of 8192
Lock table high water mark: 1
Primary object cache (-omsize): Total: 1024 Used: 237 Pinned: 0
Secondary object cache (-omsize): Total: 1024 Used: 0 Pinned: 0
Primary MT cache (-mtpmsize): Total: 1024 Used: 0 Pinned: 0
Secondary MT cache (-mtpmsize): Total: 1024 Used: 0 Pinned: 0
Number of servers: 3 (5 allocated)
Total users: 0 (20 allocated)
Self-service: 0
Remote: 0
Batch: 0
Watchdog status: *** Not executing ***
BIW status: *** Not executing ***
Number of page writers: 0
Number of monitors: 1
Number of semaphores allocated: 29
Shared memory allocated: 17671K (1 segments. The last segment was not
locked in memory)
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
Primary object cache — The number of entries in the primary storage object cache
Secondary object cache — The number of entries in the secondary storage object cache; This number is identical to the primary unless it has been increased by PROUTIL INCREASETO
Primary MT cache — The number of entries in the primary multi-tenancy partition cache
Secondary MT cache — The number of entries in the secondary multi-tenancy partition cache. storage object cache; This number is identical to the primary unless it has been increased by PROUTIL INCREASETO
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. See Managing Performance for more information on shared-memory allocation.