ITPub博客

首页 > 应用开发 > IT综合 > Invalid dbspace listed in DBSPACETEMP

Invalid dbspace listed in DBSPACETEMP

原创 IT综合 作者:tonykorn97 时间:2008-12-30 11:36:17 0 删除 编辑
启动数据库的时候报:
01:47:04 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs'[@more@]


查看dbs状态::
[informix@tonykorn97 ~]$ onstat -d

IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line (Prim) -- Up 00:04:52 -- 474904 Kbytes

Dbspaces
address number flags fchunk nchunks pgsize flags owner name
5f1ae7e8 1 0x40001 1 1 2048 N B informix rootdbs
5f9bdb18 2 0x40001 2 1 2048 N B informix plogdbs
5f9bdc78 3 0x40001 3 1 2048 N B informix llogdbs
5f9bddd8 4 0x42001 4 1 2048 N TB informix tempdbs1
5fae6018 5 0x40001 5 3 2048 N B informix datadbs01
5fae6178 6 0x40001 7 1 2048 N B informix datadbs
6 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages flags pathname
5f1ae948 1 1 8 64000 51090 PO-B /informix.links/back/rootdbs
5f9bd060 2 2 5 256000 447 PO-B /informix.links/back/plogdbs
5f9bd1e8 3 3 5 512000 11947 PO-B /informix.links/back/llogdbs
5f9bd370 4 4 5 512000 511947 PO-B /informix.links/back/tempdbs
5f9bd4f8 5 5 5 8313600 2452 PO-B /informix.links/back/datadbs01
5f9bd680 6 5 0 1024000 745 PO-B /informix.links/back/datadbs01_chunk_01
5f9bd808 7 6 0 1778650 1747556 PO-B /informix.links/back/datadbs
5f9bd990 8 5 0 10000000 8664753 PO-B /informix.links/back/datadbs01_chunk_02
8 active, 32766 maximum

NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.

Expanded chunk capacity mode: always

[informix@tonykorn97 ~]$

查看参数文件中的DBSPACETEMP参数,发现DBSPACETEMP的名字为:tempdbs。
[informix@tonykorn97 ~]$ cat etc/tonykorn97.cfg | grep DBSPACETEMP
# DBSPACETEMP:
DBSPACETEMP tempdbs # Default temp dbspaces
[informix@tonykorn97 ~]$


而数据库dbs中创建的名字是 tempdbs1 .估计原因是这个。等有机会需要修改配置文件,重启数据库。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/312079/viewspace-1015473/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-05

  • 博文量
    1854
  • 访问量
    2088287