Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROMON Shared Resources option

> Displays a variety of system resource usage statistics and startup parameter settings. Broker status information appears only when a broker process is active. Figure 19–7 shows this option’s output. See Chapter 18, "Database Startup Parameters," for more information on these startup parameters.

> Figure 19–7: Sample Output for PROMON Shared Resources option

> Because most of the Shared Resources options output is self-explanatory, this list describes only two items:

> `Shared memory version number`

> The version number of the shared-memory data structure. This structure varies slightly between some releases of the database. Since broker, server, and client processes all access the same shared-memory pool, their shared-memory version numbers must agree. If an error message states that shared-memory version numbers do not match, make sure that the broker and clients are running the same OpenEdge release.

> `Number of semaphores used (UNIX only)`

> On UNIX systems, shows the number of semaphores preallocated for this database. Because each process requires one semaphore, semaphores are preallocated based on the number of processes expected to access the database. For a particular database, the number of semaphores used (#SEM) is as follows:

> #SEM = `Max-possible-users` (-`n`) + `Max-possible-servers` (-`Mn`) + 4

> The maximum number of semaphores you can use on your system is set with a kernel configuration parameter (`SEMMNS`). If the number of database users grows large, you can exceed this value. You must reconfigure the system’s kernel to increase the semaphore limit. (See Chapter 13, " Managing Performance.") You can only reduce semaphore use by lowering the values of the Number of Users (-`n`) or Maximum Servers (-`Mn`) startup parameters. (When you start the broker process, a message specifies the number of semaphores still available.)

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