Displaying database server states

Use the ccmsrv status command to display the database server status.

This topic contains steps for both Windows® and UNIX®.

Read Pre-installation, which is located in the Installing and upgrading section of the Rational® Synergy Information center. Ensure that you have completed the requirements before attempting to use a command.

For more information see:

ccmsrv status

ccmsrv status

ccmsrv status

Windows

Procedure

  1. On the machine where the database server resides, run the ccmsrv statuscommand.
  2. Request the status. For example, request the status of all options on the database server named joe.
    > ccmsrv status /all
    
       *** database server joe ***
       server number:         0
       state:                 online mode
       maximum users allowed: 100
       number of users:       4
       archive device:        NUL
       network service:       turbo
    
       --- logical logs ---
    
       log size:             1024 KBytes
       maximum logs allowed: 38
       total number of logs: 34
       number of free logs:  0
    
       --- dbspace rootdbs ---
    
       chunk files:
       h:\ifmxdata\rootdbs.000  102400 Kbytes total,  89744 Kbytes 
    free.
       total free space:       89744 Kbytes
    
       --- dbspace log ---
    
       chunk files:
       h:\ifmxdata\log.000  51200 Kbytes total,  16172 Kbytes free.
       total free space:       16172 Kbytes
    
       --- dbspace ccm ---
    
       chunk files:
       h:\ifmxdata\ccm.000  819200 Kbytes total,  624540 Kbytes free.
       total free space:       624540 Kbytes
    
       --- dbspace temp ---
    
       chunk files:
       h:\ifmxdata\tempdbs.000  102400 Kbytes total,  102188 Kbytes 
    free.
       total free space:       102188 Kbytes
    
       Database List:
       Informix Dbname      Version    Database Path
       ==================== ========== =======================
       agincourt@irvine5    7.1         \\irvine5\devccmdb\agincourt
       ccm_nt@irvine5       7.1         \\irvine5\devccmdb\ccm_nt
    
       There is a total of 2 databases.

UNIX

Procedure

  1. On the machine where the database server resides, run the ccmsrv status command.
  2. Request the status.

    For example, request the status of the logical log and dbspace of the hydra1 server as follows:

    $ ccmsrv status -log -dbspace -s hydra1


Feedback