2007-04-11 18:26:38 8720 8707 Unable to get storage space backup data from the database server: ISAM error: no free disk space.
2007-04-11 18:26:38 8720 8707 SQL -229 Could not open or create a temporary file.
2007-04-11 18:26:38 8720 8707 ISAM -131 ISAM error: no free disk space
2007-04-11 18:26:38 8720 8707 Process 8720 8707 completed.
2007-04-11 18:26:38 8707 8704 (-43246) The ON-Bar process 8720 exited with a problem (exit code 131 (0x83),signal 0).
查看错误:
informix@tonykorn97:~> finderr 229
-229 Could not open or create a temporary file.
The database server cannot create a temporary disk file. The file
should be created in the directory that the DBTEMP environment variable
specifies (or /tmp by default on UNIX systems). Check the accompanying
ISAM error code and look for operating-system error messages that
might give more information. Possibly your account does not have write
permission in that directory, or the disk is full. Since Version 5.01,
the IBM Informix SE database server uses the DBTEMP environment variable,
but IBM Informix Dynamic Server and IBM Informix OnLine Dynamic Server do not.
On a UNIX system, try increasing the maximum number of open files
(NFILES parameter on some systems) to approximately 400.
informix@tonykorn97:~> finderr 131
-131 ISAM error: no free disk space.
Not enough contiguous free disk space is available to complete the
current operation. For C-ISAM programs, if transaction logging is in
use, roll back the current transaction. Make some disk space available,
and run the program again. For SQL products, roll back the current
transaction, if possible. Contact the system administrator about
acquiring more disk space for databases.
查看数据空间
informix@tonykorn97:~> onstat -d
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 106 days 10:20:23 -- 1588168 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
51c1c7e8 1 0x40001 1 2 2048 N B informix rootdbs
524fbd30 2 0x40001 2 1 2048 N B informix plogdbs
524fbe90 3 0x40001 3 1 2048 N B informix llogdbs
52553018 6 0x44001 8 1 2048 N B informix datadbs1
52553178 7 0x40001 9 1 2048 N B informix datadbs2
525532d8 8 0x44001 10 2 2048 N B informix datadbs3
52553438 9 0x40001 11 1 2048 N B informix datadbs4
52553598 10 0x44001 12 1 2048 N B informix indexdbs1
525536f8 11 0x40001 13 1 2048 N B informix indexdbs2
9 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
51c1c948 1 1 0 64000 307 PO-B /informix.links/rootdbs
应该是rootdbs空间不足造成的。添加一个rootdbs chunk后备份正常。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/312079/viewspace-245642/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/312079/viewspace-245642/