Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    1

    Unanswered: Informix DBS space full

    Hi all

    I'm having a problem with Informix in Solaris9, the space in the disk is full:


    Filesystem kbytes used avail capacity Mounted on
    /dev/dsk/c0t0d0s0 4133838 1847688 2244812 46% /
    /proc 0 0 0 0% /proc
    mnttab 0 0 0 0% /etc/mnttab
    fd 0 0 0 0% /dev/fd
    /dev/dsk/c0t0d0s3 2058319 308133 1688437 16% /var
    swap 4772128 48 4772080 1% /var/run
    swap 4772352 272 4772080 1% /tmp
    /dev/dsk/c0t0d0s6 4133838 4121 4088379 1% /dbtemp0
    /dev/dsk/c0t0d0s7 56065118 55504467 0 100% /data

    and in directory /data/Informix94/spaces:

    informix@CtServer:~/spaces> ls -lah
    total 88783556
    drwxrwxr-x 2 informix informix 512 May 25 2009 .
    drwxr-xr-x 20 informix informix 1.0K May 29 2009 ..
    -rw-rw---- 1 informix informix 29G Dec 23 17:52 datadbs.000
    -rw-rw---- 1 informix informix 195M Oct 26 2010 indexdbs.000
    -rw-rw---- 1 informix informix 5.4G Dec 23 17:52 logicallog.999
    -rw-rw---- 1 informix informix 391M Aug 3 2009 logicallog.dbs
    -rw-rw---- 1 informix informix 391M Dec 23 17:52 rootdbs.000
    -rw-rw---- 1 informix informix 488M May 25 2009 sbspace.000
    -rw-rw---- 1 informix informix 1.1G May 25 2009 screendbs.000
    -rw-rw---- 1 informix informix 5.7G Dec 23 17:52 tempdbs.000

    and Informix doesn't run

    informix@CtServer:~/bin> ./onstat
    shared memory not initialized for INFORMIXSERVER 'celltick_soc

    Can anyone help me?

    Thanks

  2. #2
    Join Date
    Sep 2004
    Posts
    51

    Informix DBS space full

    Run onstat -m to run the message file which may give a better indication of why informix will not come online. When a dbspace is created it will use the entire size on disk.

    Also the following message shows soc, Solaris will only support tli connections. Can you please post the sqlhosts file contents.

    shared memory not initialized for INFORMIXSERVER 'celltick_soc

    In order to determine if the Informix DBS spaces is full the server would need to be online to run onstat -d.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •