This is a discussion on RE: ids10.force to drop a chunk within the Informix forums, part of the Database Server Software category; --> Hi, Here is a snippet of release note of 10.0.UC3. 1.4.2.2.3 Managing the tblspace tblspace You have enhanced flexibility ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, Here is a snippet of release note of 10.0.UC3. 1.4.2.2.3 Managing the tblspace tblspace You have enhanced flexibility in managing the tblspace tblspace. The tblspace tblspace is a set of pages that describe the location and structure of all tblspaces in a given dbspace. Use the onspaces utility to move or drop the chunk containing the tblspace tblspace. You can also specify the size of the first extent and of subsequent extents when dbspaces are created: * Use the TBLTBLFIRST and TBLTBLNEXT configuration parameters to You can also specify the size of the first extent and of subsequent extents when dbspaces are created: * Use the TBLTBLFIRST and TBLTBLNEXT configuration parameters to specify the size of the extents in the root dbspace. You must set these configuration parameters before creating the root dbspace. * Use the onspaces utility to specify the size of non-root dbspaces during creation. This feature allows you to reduce the number of tblspace tblspace extents and reduce the frequency of cases where those extents are placed in non-primary chunks. These features are primarily documented in the IBM Informix Dynamic Server Administrator's Guide and IBM Informix Dynamic Server Administrator's Reference. See IDS Administrator's Reference. -- Tsutomu Ogiwara from Tokyo Japan. >From: vomaringo@yahoo.com >Reply-To: vomaringo@yahoo.com >To: informix-list@iiug.org >Subject: ids10.force to drop a chunk >Date: 21 Nov 2005 07:25:37 -0800 > >hello, >i get a dbspace with 2 chunk: one is used by a database and one is down >and empty. >i thought ids10 could do the following: >drop database mydb; >onspaces -d myspace -f >but onspaces refuse with : Cannot drop a 'dbspace' using the -f flag. >Any idea. >Thanks. sending to informix-list |