Kbase P91873: How to identify shared memory segments associated with a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/25/2010 |
|
Status: Verified
GOAL:
How to identify what shared memory segments are associated with a database
GOAL:
How to determine which shared memory segments are associated with a specific database
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
There are two ways of determining which shared memory segments are associated with a database.
The first way is via the proutil command. The dbipcs option to this command will allow you to identify all shared memory segments associated with any databases running on this machine.
Command Syntax: proutil dbname -C dbipcs
Sample output:
PROGRESS SHARED MEMORY STATUS
ID ShMemVer Seg# InUse Database
0 - - - (not PROGRESS)
1 - - - (not PROGRESS)
2 - - - (not PROGRESS)
29187 9129 - - (unsupported shared memory version)
4 - - - (not PROGRESS)
5 - - - (not PROGRESS)
16902 64009129 0 Yes /tmp/dbname.db
The second way to see shared memory segment information is using promon. Promon will allow you to display shared memory segments and the shared memory segment ids for a specific database.
Command Syntax: promon dbname
1. In promon type R&D <return> to get to the R&D Menu
2. Select 1 for Status Displays
3. Select 14 for Shared Memory Segments
Sample output:
Status: Shared Memory Segments
Seg Id Size Used Free
1 16902 1044480 872496 171984
Enter <return>, R, P, T, or X (? for help):