Итак при откритии базы в ServerStudio и попытке просмотреть список процедур получаю ошибку Cannot Write Sorted Rows.

Смотрю на наличие свободного места на сервере (onstat -d):
авторInformix Dynamic Server Version 9.30.TC1 -- On-Line -- Up 00:27:42 -- 25472 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
c9e27d0 1 0x2 1 1 M informix rootdbs
c9e2d88 2 0x1 2 1 N informix logdbs
c9e2ed0 3 0x1 3 4 N informix dbs1
3 active, 2047 maximum

Chunks
address chk/dbs offset size free bpages flags pathname
c9e2918 1 1 0 12800 7812 PO- C:\IFMXDATA\AOPServer\rootdbs_dat.000
c9e2a80 1 1 0 12800 0 MO- D:\IFMXDATA\AOPServer\rootdbs_mirr.000
ca37b08 2 2 0 25000 17947 PO- c:\ifmxdata\aopserver\logdbs
ca37c70 3 3 0 25000 29 PO- c:\ifmxdata\aopserver\dbs1
ca37dd8 4 3 0 250000 48015 PO- c:\ifmxdata\aopserver\dbs1_2
ca28e30 5 3 0 62500 62497 PO- c:\IFMXDATA\AOPSERVER\dbs1_3
c9e2c20 6 3 0 500000 499897 PO- d:\informix\dbs1
6 active, 2047 maximum


По DB.log вижу вот что:

авторMon Aug 25 11:16:00 2008

11:16:00 Booting Language <c> from module <>
11:16:00 Loading Module <CNULL>
11:16:00 Booting Language <builtin> from module <>
11:16:00 Loading Module <BUILTINNULL>
11:16:04 Informix Dynamic Server Version 9.30.TC1 Software Serial Number AAC#J837981
11:16:06 Informix Dynamic Server Initialized -- Shared Memory Initialized.

11:16:06 Physical Recovery Started at Page(1:476).
11:16:21 Physical Recovery Complete: 0 Pages Examined 0 Pages Restored.

11:16:21 Logical Recovery Started.
11:16:21 10 recovery worker threads will be started.
11:16:21 Dynamically allocated new virtual shared memory segment (size 8192KB)
11:16:24 Logical Recovery has reached the transaction cleanup phase.
11:16:24 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

11:16:25 Dataskip is now OFF for all dbspaces
11:16:25 Checkpoint Completed: duration was 0 seconds.
11:16:25 Checkpoint loguniq 2068, logpos 0x133018

11:16:25 Maximum server connections 0
11:16:26 Init operation complete - Mode Online
11:16:26 On-Line Mode
11:16:33 Booting Language <spl> from module <>
11:16:33 Loading Module <SPLNULL>
11:21:55 Checkpoint Completed: duration was 0 seconds.
11:21:55 Checkpoint loguniq 2068, logpos 0x134018

11:21:55 Maximum server connections 1
11:41:56 Checkpoint Completed: duration was 0 seconds.
11:41:56 Checkpoint loguniq 2068, logpos 0x136018

11:41:56 Maximum server connections 3

Как побороть?

Добавил - все равно то же самое.

авторInformix Dynamic Server Version 9.30.TC1 -- On-Line -- Up 05:18:03 -- 66624 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
c9e27d0 1 0x2 1 1 M informix rootdbs
c9e2d88 2 0x1 2 1 N informix logdbs
c9e2ed0 3 0x1 3 4 N informix dbs1
100e3cb0 4 0x2001 7 1 N T informix tempdbs
4 active, 2047 maximum

Chunks
address chk/dbs offset size free bpages flags pathname
c9e2918 1 1 0 12800 7812 PO- C:\IFMXDATA\AOPServer\rootdbs_dat.000
c9e2a80 1 1 0 12800 0 MO- D:\IFMXDATA\AOPServer\rootdbs_mirr.000
ca37b08 2 2 0 25000 17947 PO- c:\ifmxdata\aopserver\logdbs
ca37c70 3 3 0 25000 29 PO- c:\ifmxdata\aopserver\dbs1
ca37dd8 4 3 0 250000 46863 PO- c:\ifmxdata\aopserver\dbs1_2
ca28e30 5 3 0 62500 62497 PO- c:\IFMXDATA\AOPSERVER\dbs1_3
c9e2c20 6 3 0 500000 499897 PO- d:\informix\dbs1
100e3df8 7 4 0 12500 12447 PO- d:\informix\tempdbs
7 active, 2047 maximum

Спасибо - проблема решилась :-)