Unix Technical Forum

RE: ids10.force to drop a chunk

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 ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 10:38 AM
Tsutomu Ogiwara
 
Posts: n/a
Default RE: ids10.force to drop a chunk


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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:39 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com