互联网服务error
删除库后，表空间无法删除，提示not empty
onspaces -d nmosdbs
WARNING: Dropping a DBspace.
Do you really want to continue? (y/n)y
Cannot drop the Space.
ISAM error: DBspace is not empty
oncheck -pe nmosdbs
DBspace Usage Report: nmosdbs Owner: informix Created: 01/05/2009
Chunk Pathname Size Used Free
17 /opt/informix/chunks/chkcnmos/nmoschk1 1024000 703 1023297
Description Offset Size
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
nmosdbs:'informix'.TBLSpace 3 50
FREE 53 95727
nmosdbs:'informix'.TBLSpace 95780 50
FREE 95830 103462
nmosdbs:'informix'.TBLSpace 199292 50
FREE 199342 2354
nmosdbs:'informix'.TBLSpace 201696 50
FREE 201746 1667
nmosdbs:'informix'.TBLSpace 203413 50
FREE 203463 411
nmosdbs:'informix'.TBLSpace 203874 50
FREE 203924 383
nmosdbs:'informix'.TBLSpace 204307 50
FREE 204357 357
nmosdbs:'informix'.TBLSpace 204714 50
FREE 204764 353
nmosdbs:'informix'.TBLSpace 205117 50
FREE 205167 369
nmosdbs:'informix'.TBLSpace 205536 50
FREE 205586 354
nmosdbs:'informix'.TBLSpace 205940 50
FREE 205990 351
nmosdbs:'informix'.TBLSpace 206341 50
FREE 206391 62468
nmosdbs:'informix'.TBLSpace 268859 50
FREE 268909 371
nmosdbs:'informix'.TBLSpace 269280 50
FREE 269330 754670
Total Used: 703
Total Free: 1023297
Chunk Pathname Size Used Free
18 /opt/informix/chunks/chkcnmos/nmoschk1_a 51200000 319 51199681
Description Offset Size
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
FREE 3 406978
nmosdbs:'informix'.TBLSpace 406981 50
FREE 407031 117887
nmosdbs:'informix'.TBLSpace 524918 50
FREE 524968 1144410
nmosdbs:'informix'.TBLSpace 1669378 100
FREE 1669478 817
nmosdbs:'informix'.TBLSpace 1670295 100
FREE 1670395 218
nmosdb:'informix'.q_tpp_alarm_act 1670613 8
nmosdb:'informix'.q_tpp_event_act 1670621 8
FREE 1670629 49529371
Total Used: 319
Total Free: 51199681
WARNING: Dropping a DBspace.
Do you really want to continue? (y/n)y
Cannot drop the Space.
ISAM error: DBspace is not empty
oncheck -pe nmosdbs
DBspace Usage Report: nmosdbs Owner: informix Created: 01/05/2009
Chunk Pathname Size Used Free
17 /opt/informix/chunks/chkcnmos/nmoschk1 1024000 703 1023297
Description Offset Size
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
nmosdbs:'informix'.TBLSpace 3 50
FREE 53 95727
nmosdbs:'informix'.TBLSpace 95780 50
FREE 95830 103462
nmosdbs:'informix'.TBLSpace 199292 50
FREE 199342 2354
nmosdbs:'informix'.TBLSpace 201696 50
FREE 201746 1667
nmosdbs:'informix'.TBLSpace 203413 50
FREE 203463 411
nmosdbs:'informix'.TBLSpace 203874 50
FREE 203924 383
nmosdbs:'informix'.TBLSpace 204307 50
FREE 204357 357
nmosdbs:'informix'.TBLSpace 204714 50
FREE 204764 353
nmosdbs:'informix'.TBLSpace 205117 50
FREE 205167 369
nmosdbs:'informix'.TBLSpace 205536 50
FREE 205586 354
nmosdbs:'informix'.TBLSpace 205940 50
FREE 205990 351
nmosdbs:'informix'.TBLSpace 206341 50
FREE 206391 62468
nmosdbs:'informix'.TBLSpace 268859 50
FREE 268909 371
nmosdbs:'informix'.TBLSpace 269280 50
FREE 269330 754670
Total Used: 703
Total Free: 1023297
Chunk Pathname Size Used Free
18 /opt/informix/chunks/chkcnmos/nmoschk1_a 51200000 319 51199681
Description Offset Size
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
FREE 3 406978
nmosdbs:'informix'.TBLSpace 406981 50
FREE 407031 117887
nmosdbs:'informix'.TBLSpace 524918 50
FREE 524968 1144410
nmosdbs:'informix'.TBLSpace 1669378 100
FREE 1669478 817
nmosdbs:'informix'.TBLSpace 1670295 100
FREE 1670395 218
nmosdb:'informix'.q_tpp_alarm_act 1670613 8
nmosdb:'informix'.q_tpp_event_act 1670621 8
FREE 1670629 49529371
Total Used: 319
Total Free: 51199681
35同行回答
按照楼主说的，我做了个实验：
有2个dbs 一个 tnmsdbs 一个tangyidbs
2个库 testdb1 in tnmsdbs ; testdb2 in tangyidbs
在testdb1 中创建表testtable
在testdb2中创建同义词，for testdb1：testtable
然后删除testdb1，再删除testdb2
删除表空间，成功
[informix@hdr2 ~]$ dbaccess sysmaster -
Database selected.
> create database testdb1 in tnmsdbs;
Database closed.
Database created.
> create database testdb2 in tangyidbs;
Database closed.
Database created.
> database testdb1
> ;
Database closed.
Database selected.
> create table testtable (id int);
Table created.
> database testdb2;
Database closed.
Database selected.
> create synonym db2test1 for testdb1:testtable;
Synonym created.
> database sysmaster;
Database closed.
Database selected.
> drop database testdb2;
Database dropped.
> [informix@hdr2 ~]$ onstat -d
IBM Informix Dynamic Server Version 11.50.UC7 -- On-Line (Prim) -- Up 00:13:03 -- 286040 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
8d7d6808 1 0x40001 1 1 2048 N B informix rootdbs
8d7d6b88 2 0x40001 2 1 2048 N B informix phydbs
8d7d6ce8 3 0x40001 3 1 2048 N B informix logdbs
8d7d6e48 4 0x42001 4 1 2048 N TB informix tmpdbs
8d8ac430 5 0x40001 5 1 2048 N B informix tnmsdbs
8d8ac590 6 0x40001 6 1 4096 N B informix tangyidbs
6 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
8d7d6968 1 1 0 100000 63245 PO-B- /home/informix/chunk/rootdbs
8d8ac6f0 2 2 0 25000 447 PO-B- /home/informix/chunk/phydbs
8d8ac8c8 3 3 0 50000 447 PO-B- /home/informix/chunk/logdbs
8d8acaa0 4 4 0 50000 49947 PO-B- /home/informix/chunk/tmpdbs
8d8acc78 5 5 0 50000 49647 PO-B- /home/informix/chunk/tnmsdbs
8e19c018 6 6 0 25000 24897 PO-B- /home/informix/chunk/tangyidbs
6 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@hdr2 ~]$ onspaces -d tangyidbs
WARNING: Dropping a DBspace.
Do you really want to continue? (y/n)y
Space successfully dropped.
** WARNING ** A level 0 archive will need to be done before any chunks from
DBspace tangyidbs can be reused (see Dynamic Server Administrator's manual).
[informix@hdr2 ~]$收起
有2个dbs 一个 tnmsdbs 一个tangyidbs
2个库 testdb1 in tnmsdbs ; testdb2 in tangyidbs
在testdb1 中创建表testtable
在testdb2中创建同义词，for testdb1：testtable
然后删除testdb1，再删除testdb2
删除表空间，成功
[informix@hdr2 ~]$ dbaccess sysmaster -
Database selected.
> create database testdb1 in tnmsdbs;
Database closed.
Database created.
> create database testdb2 in tangyidbs;
Database closed.
Database created.
> database testdb1
> ;
Database closed.
Database selected.
> create table testtable (id int);
Table created.
> database testdb2;
Database closed.
Database selected.
> create synonym db2test1 for testdb1:testtable;
Synonym created.
> database sysmaster;
Database closed.
Database selected.
> drop database testdb2;
Database dropped.
> [informix@hdr2 ~]$ onstat -d
IBM Informix Dynamic Server Version 11.50.UC7 -- On-Line (Prim) -- Up 00:13:03 -- 286040 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
8d7d6808 1 0x40001 1 1 2048 N B informix rootdbs
8d7d6b88 2 0x40001 2 1 2048 N B informix phydbs
8d7d6ce8 3 0x40001 3 1 2048 N B informix logdbs
8d7d6e48 4 0x42001 4 1 2048 N TB informix tmpdbs
8d8ac430 5 0x40001 5 1 2048 N B informix tnmsdbs
8d8ac590 6 0x40001 6 1 4096 N B informix tangyidbs
6 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
8d7d6968 1 1 0 100000 63245 PO-B- /home/informix/chunk/rootdbs
8d8ac6f0 2 2 0 25000 447 PO-B- /home/informix/chunk/phydbs
8d8ac8c8 3 3 0 50000 447 PO-B- /home/informix/chunk/logdbs
8d8acaa0 4 4 0 50000 49947 PO-B- /home/informix/chunk/tmpdbs
8d8acc78 5 5 0 50000 49647 PO-B- /home/informix/chunk/tnmsdbs
8e19c018 6 6 0 25000 24897 PO-B- /home/informix/chunk/tangyidbs
6 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@hdr2 ~]$ onspaces -d tangyidbs
WARNING: Dropping a DBspace.
Do you really want to continue? (y/n)y
Space successfully dropped.
** WARNING ** A level 0 archive will need to be done before any chunks from
DBspace tangyidbs can be reused (see Dynamic Server Administrator's manual).
[informix@hdr2 ~]$收起
浏览738