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.