Displaying database server states

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

This topic contains steps for both Windows and UNIX.

Ensure that you have completed the requirements before attempting to use a command.

For more information see:

Windows: ccmsrv status

UNIX on Informix®: ccmsrv status

UNIX on Oracle: ccmsrv status

Windows

Before you begin

Read Preinstallation on 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.2         \\irvine5\devccmdb\agincourt
    ccm_nt@irvine5       7.2         \\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