INFORMIX数据库问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

INFORMIX数据库问题

INFORMIX数据库问题# Database - 数据库

y*g2002-12-08 08:12

1 楼

数据库本身已经没有多少SHARED　MEMORY:
apnstat2% onstat -d
Informix Dynamic Server 2000 Version 9.20.UC3 -- On-Line -- Up 13 days
02:46:00 -- 261120 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
1dbd17d0 1 1 1 3 N informix rootdbs
1 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
1dbd1918 1 1 0 950000 6 PO- /dev/rdsk/c0t1d0s7
1dc0f320 2 1 0 10000

l*o2002-12-08 08:12

2 楼

I think there are three possible problems:
1. maybe the table is corrupt, so you should unload the table and drop it,
then rebuild it and delete from this table;
2. maybe you use the timestamp system didn't recognize, could you use any
other where condition to delete?
3. maybe the sysmaster database is not right, so you could only dbexport your
database and then rebuild it.
hope I write something useful to you.

/dev/rdsk/c0t1d0s7
/dev/rdsk/c0t1d0s6
/dev/rdsk/c0t1d0s5

【在 y*****g 的大作中提到】

: 数据库本身已经没有多少SHARED　MEMORY:
: apnstat2% onstat -d
: Informix Dynamic Server 2000 Version 9.20.UC3 -- On-Line -- Up 13 days
: 02:46:00 -- 261120 Kbytes
: Dbspaces
: address number flags fchunk nchunks flags owner name
: 1dbd17d0 1 1 1 3 N informix rootdbs
: 1 active, 2047 maximum
: Chunks
: address chk/dbs offset size free bpages flags pathname