|
|
|
Valid on UNIX.
Permission required: Installation owner.
The csreport utility displays shared memory and semaphore information for your installation.
Verify that the installation owner is the owner of any shared memory segments or semaphores used by your Ingres installation. Running csinstall as root or some other user can cause segments and semaphores to be allocated that are not owned by the installation owner. Cscleanup does not remove these, so they must be removed under the user login of the user who created them. To do this, use the UNIX utility ipcrm in the format: ipcrm -mmid | -ssid , where mid is the ID number of the shared memory segment and sid is the semaphore identifier.
The csreport command has the following format:
csreport
|
|
|
Here is sample output from the csreport command:
!Installation version 610008
!Max number of servers 16
!Description of shared memory for control system:
!Key 0x493D183C: size 16384 attach 00000000
!Description of shared memory for logging & locking system:
!Key 0x493D184E: size 229376 attach C0005000
!Semaphore information for installation:
! sysV semid 38, num sems 21, used sems 19
!0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
!Event system: used space 13268, length space 16384
The following command shows the processes that are currently running. You can use this command to obtain the server connect IDs for iimonitor input.
csreport | grep "inuse 1"
Here is sample output:
!inuse 1, pid 3375, connect id 2217, id_number 0, semid 3900
!inuse 1, pid 3384, connect id 2220, id_number 1, semid 4101
!inuse 1, pid 3389, connect id , id_number 2, semid 0
The Recovery Server is listed first and can be connected to iimonitor with the connect ID 2217. The other server in this listing has the connect ID 2220. Processes (as opposed to servers) do not have a connect ID.
|
|
|
The following command shows the processes that are currently running. You can use this command to obtain the server connect IDs for iimonitor input.
csreport | grep "inuse 1"
Here is sample output:
!inuse 1, pid 3375, connect id 2217, id_number 0, semid 3900
!inuse 1, pid 3384, connect id 2220, id_number 1, semid 4101
!inuse 1, pid 3389, connect id , id_number 2, semid 0
The Recovery Server is listed first and can be connected to iimonitor with the connect ID 2217. The other server in this listing has the connect ID 2220. Processes (as opposed to servers) do not have a connect ID.