- 论坛徽章:
- 11
|
原帖由 wanyaozong 于 2008-1-22 16:40 发表 ![]()
回19楼，昨天就已经试过了，3个chunk都只有TBLSPACE，可是chunk也不能删，报chunk not empty ,dbspace也不能删,报not empty
额.......昨天我做了个测试..在RHEL AS3 + IDS 9.40UC4W4 版本里先dbexport出database,然后就可以删除dbspaces....
但是在dbimport后,第一个chunk里仍然有TBLSpace
============================================================
以下是来自IIUG里的Mark Jamison对这种情况的解释..
The tblspace tblspace entries are not tied to databases, but rather
dbspaces. Any database object, for any database in that dbspaces is
represented in the tblspace tblspace. As you get more datbasee objects, you
get more tblspace tblspace entires, which eventually leads to additional
extents like what you showed us below. Since IDS doesn't allow for users
to drop internal system tables, it means that you have to call IBM
Informix Technical support to remove the chunk or the dbspace,
depending on what you want.
It also appears at the moment, that at least by our documentation you
cannot prune the tblspace tblspace table in any version. The good news
though is that beginning in version 10 you can size the tblspace
tblspace table's first extent and next extent. For dbspacess that
expect to have a lot of tables, or detached indices this can really help. To
reference the
manual
You can specify a non-default size for the first and next extents for a
tblspace tblspace in the following ways:
For the root dbspace, set the TBLTBLFIRST and TBLTBLNEXT configuration
parameters.For non-root dbspaces, use the onspaces utility -ef and -en options
when you create
a dbspace.
But again to your original problem, you need to contact Tech Support.
Hope this Helps,
Mark Jamison |
|
免费注册
楼主: hongmei_01
发表于 2008-01-23 09:48
