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

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.