Progress
Database Administration
Guide and Reference


Recovering From a Crash

If the broker dies or is killed by some means other than the database shutdown command, it does not release attached shared-memory segments. Use PROUTIL -C DBIPCS to verify shared memory has not been released; use the UNIX command ipcrm -m to free it.

Use the DBIPCS qualifier on PROUTIL to display the status of shared-memory segments attached by all Progress databases on the system:

PROUTIL -C DBIPCS 

You do not have to include a database name. Here is an example of the status output:

Progress SHARED MEMORY STATUS 
 ID  ShMemVer  Seg#  InUse   Database  
 68      -      -     -      (not Progress) 
100      3      0     Yes    /db/work5/sports 
101      3      1     -      /db/work5/sports 
120      3      0     No     /db/work5/test 
150      2      -     -      (unsupported shared memory version) 

Table 8–6 describes the display fields in the output.

Table 8–6: Shared-memory Segment Status Fields 
Field
Description
ID
Indicates the shared-memory ID.
ShMemVer
Specifies the shared-memory version.
Seg#
Indicates the shared-memory segment number. One database can own more than one segment.
InUse
Specifies whether the segment is in use. Yes or No values are displayed only if the segment is number 0. All other segments show a dash (-). To determine whether a set of segments is in use, check the InUse value of segment 0 for the relevant database.
Database
Represents the full path name of the database.


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