Kbase P26587: How to tell how much free shared memory is available for a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/02/2009 |
|
Status: Verified
GOAL:
How to tell how much free shared memory is available for a database
GOAL:
How to monitor my system to avoid "Out of free shared memory. Use -Mxs to increase. (6495)" error messages.
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
If when connected remotely a client has requested a very large or very complex query more from the server, more RAM may be needed by the remote client server than was allocated by default upon server startup.
The server process itself will try and allocate more RAM so long as we do not exceed the total number of segments allocated at startup.
If we attempt to exceed the allocated shared memory then the (6495) error will be generated.
If you wish to monitor the amount of shared memory used by your database, connect through promon to your database in shared memory.
Here is an example:
PROGRESS MONITOR Version 9
Database: E:\progtemp\prog91d
1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
T. Transactions Control
L. Resolve Limbo Transactions
C. Coordinator Information
M. Modify Defaults
Q. Quit
Enter your selection: R&D
Type R&D to enter the R&D menu system
Progress Version 9 Monitor (R&D)
Main (Top) Menu
1. Status Displays ...
2. Activity Displays ...
3. Other Displays ...
4. Administrative Functions ...
5. Adjust Monitor Options
Enter a number, <return>, P, T, or X (? for help): 1
Select option 1
Progress Version 9 Monitor (R&D)
Status Displays Menu
1. Database
2. Backup
3. Servers
4. Processes/Clients ...
5. Files
6. Lock Table
7. Buffer Cache
8. Logging Summary
9. BI Log
10. AI Log
11. Two-Phase Commit
12. Startup Parameters
13. Shared Resources
14. Shared Memory Segments
Enter a number, <return>, P, T, or X (? for help): 14
Select option 14
Status: Shared Memory Segments
Seg Id Size Used Free
1 11534336 1375272 1306436 68836
Here you will see the total number of segments and which segments have any available space.
Usually only the last segment will have any appreciable space free.
You may also use the VST tables to review this same information:
For each _segments.
display _segments except _segment-misc.