Drop or resize fragment
User couldn't drop an empty future fragment from an expression-fragmented table because dbspace was full. The ALTER FRAGMENT DROP PARTITION command was attempted but failed. Solution: Use the table/fragment shrink function to remove free space, optionally after altering the first extent size. Execute either execute function task("fragment shrink", partnum) or execute function task("table shrink", tabname, dbsname).
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We've created a table with multiple fragments. It's fragmented by expression
so each fragment holds a month's data and is about 4g in size.
Now one of the dbspaces is full! I'd like to drop some of the *future*
fragments that don't have anything in them yet, say the one for 2013_06, or
even better resize it much smaller.
I can't see the syntax for reducing the first extent size of a fragment.
When I tried:
ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06
I got dbs02 is full. Which is true. But what was it trying to do? Perhaps if
I added just a tiny chunk to dbs02 I'd be OK?
What I really do NOT want is for the whole table, all 1 billion rows, to be
processed. This fragment is empty and the operation should, I hope, be
instantaneous?
Thanks
N
the table shrink function will remove all free space at the end of the
table to the
first extent size. You can first alter the table adjusting the first
extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> From: "NEIL TRUBY" <neil.truby@ardenta.com>
> To: ids@iiug.org,
> Date: 03/22/2013 10:48 AM
> Subject: Drop or resize fragment [29880]
> Sent by: ids-bounces@iiug.org
>
> We've created a table with multiple fragments. It's fragmented by
expression
> so each fragment holds a month's data and is about 4g in size.
>
> Now one of the dbspaces is full! I'd like to drop some of the *future*
> fragments that don't have anything in them yet, say the one for 2013_06,
or
> even better resize it much smaller.
>
> I can't see the syntax for reducing the first extent size of a fragment.
>
> When I tried:
> ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06>
> I got “dbs02 is full”. Which is true. But what was it trying to do?
> Perhaps if
> I added just a tiny chunk to dbs02 I'd be OK?
>
> What I really do NOT want is for the whole table, all 1 billion rows, to
be
> processed. This fragment is empty and the operation should, I hope, be
> instantaneous?
>
> Thanks
> N
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
John:
While I do speak a rough Klingon, my computer won't handle the character
set. Please repost in English.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Fri, Mar 22, 2013 at 2:31 PM, John Miller iii <miller3@us.ibm.com> wrote:
>
> the table shrink function will remove all free space at the end of the
> table to the
> first extent size. You can first alter the table adjusting the first
> extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
>
> execute function task("table shrink", "tabname","dbsname")>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbspaces is full! I'd like to drop some of the *future*
> > fragments that don't have anything in them yet, say the one for 2013_06,
> or
> > even better resize it much smaller.
> >
> > I can't see the syntax for reducing the first extent size of a fragment.
> >
> > When I tried:
> > ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06> >
> > I got “dbs02 is full”. Which is true. But what was it trying to do?
> > Perhaps if
> > I added just a tiny chunk to dbs02 I'd be OK?
> >
> > What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f46d04016b49eab96804d887c0bf
The table/fragment shrink function will remove all free space at the end of
the table/fragment
to the first extent size. You can first alter the table adjusting the
first extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> From: "NEIL TRUBY" <neil.truby@ardenta.com>
> To: ids@iiug.org,
> Date: 03/22/2013 10:48 AM
> Subject: Drop or resize fragment [29880]
> Sent by: ids-bounces@iiug.org
>
> We've created a table with multiple fragments. It's fragmented by
expression
> so each fragment holds a month's data and is about 4g in size.
>
> Now one of the dbspaces is full! I'd like to drop some of the *future*
> fragments that don't have anything in them yet, say the one for 2013_06,
or
> even better resize it much smaller.
>
> I can't see the syntax for reducing the first extent size of a fragment.
>
> When I tried:
> ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06>
> I got “dbs02 is full”. Which is true. But what was it trying to do?
> Perhaps if
> I added just a tiny chunk to dbs02 I'd be OK?
>
> What I really do NOT want is for the whole table, all 1 billion rows, to
be
> processed. This fragment is empty and the operation should, I hope, be
> instantaneous?
>
> Thanks
> N
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Well - that explains it....
From: John Miller iii/Menlo Park/IBM@IBMUS
To: ids@iiug.org,
Date: 03/22/2013 02:45 PM
Subject: Re: Drop or resize fragment [29883]
Sent by: ids-bounces@iiug.org
The table/fragment shrink function will remove all free space at the end of
the table/fragment
to the first extent size. You can first alter the table adjusting the
first extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> From: "NEIL TRUBY" <neil.truby@ardenta.com>
+
IFRvOiBpZHNAaWl1Zy5vcmcsDQo
Date: 03/22/2013 10:48 AM
> Subject: Drop or resize fragment [29880]
> Sent by: ids-bounces@iiug.org
>
> We've created a table with multiple fragments. It's fragmented by
expression
> so each fragment holds a month's data and is about 4g in size.
>
> Now one of the dbspaces is full! I'd like to drop some of the *future*
> fragments that don't have anything in them yet, say the one for 2013_06,
or
> even better resize it much smaller.
>
> I can't see the syntax for reducing the first extent size of a fragment.
>
> When I tried:
> ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06>
> I got “dbs02 is full”. Which is true. But what was it trying to do?
> Perhaps if
> I added just a tiny chunk to dbs02 I'd be OK?
>
> What I really do NOT want is for the whole table, all 1 billion rows, to
be
> processed. This fragment is empty and the operation should, I hope, be
> instantaneous?
>
> Thanks
> N
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Hmmmm.... I think John Miller would be more useful if he is able to
re-connect with us. It looks like he's connected to the new telescope
located somewhere in Mexico... :)
Anyway... Don't "DROP". Dropping will affect the expression, not the data
(and yes, I know you apparently have no data...)
I can't tell what it's trying to do... Do you have a REMAINDER partition?
In any case, try to DETACH and then drop the new table.
After that you probably can change the FIRST EXTENT SIZE (it only affects
the definition) and then recreate the partition (it should be smaller)
Regards.
On Fri, Mar 22, 2013 at 5:47 PM, NEIL TRUBY <neil.truby@ardenta.com> wrote:
> We've created a table with multiple fragments. It's fragmented by
> expression
> so each fragment holds a month's data and is about 4g in size.
>
> Now one of the dbspaces is full! I'd like to drop some of the *future*
> fragments that don't have anything in them yet, say the one for 2013_06, or
> even better resize it much smaller.
>
> I can't see the syntax for reducing the first extent size of a fragment.
>
> When I tried:
> ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06>
> I got dbs02 is full. Which is true. But what was it trying to do?
> Perhaps if
> I added just a tiny chunk to dbs02 I'd be OK?
>
> What I really do NOT want is for the whole table, all 1 billion rows, to be
> processed. This fragment is empty and the operation should, I hope, be
> instantaneous?
>
> Thanks
> N
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--20cf307813fc6a0dfa04d88ac191
Is there a translator program out there for these types of accidental
emails, so we can read the writer's true intentions?
Take care.
Clifton
On Fri, Mar 22, 2013 at 7:47 PM, Madison Pruet <mpruet@us.ibm.com> wrote:
> Well - that explains it....
>
> From: John Miller iii/Menlo Park/IBM@IBMUS
> To: ids@iiug.org,
> Date: 03/22/2013 02:45 PM
> Subject: Re: Drop or resize fragment [29883]
> Sent by: ids-bounces@iiug.org
>
> The table/fragment shrink function will remove all free space at the end of
> the table/fragment
> to the first extent size. You can first alter the table adjusting the
> first extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
> execute function task("table shrink", "tabname","dbsname")>
>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbspaces is full! I'd like to drop some of the *future*
> > fragments that don't have anything in them yet, say the one for 2013_06,
> or
> > even better resize it much smaller.
> >
> > I can't see the syntax for reducing the first extent size of a fragment.
> >
> > When I tried:
> > ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06> >
> > I got “dbs02 is full”. Which is true. But what was it trying to do?
> > Perhaps if
> > I added just a tiny chunk to dbs02 I'd be OK?
> >
> > What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> ***********************************************************************=
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
> This communication may contain privileged or other confidential
> information. If you have received it in error, please advise the sender by
> reply email and immediately delete the message and any attachments without
> copying or disclosing the contents. Thank you.
Consider the environment. Please don't print this e-mail unless you need to.
--f46d043c7d24cd51a404d88e411f
On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii <miller3@us.ibm.com>wrote:
>
> the table shrink function will remove all free space at the end of the
> table to the
> first extent size. You can first alter the table adjusting the first
> extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
>
> execute function task("table shrink", "tabname","dbsname")>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbspaces is full! I'd like to drop some of the *future*
> > fragments that don't have anything in them yet, say the one for 2013_06,
> or
> > even better resize it much smaller.
> >
> > I can't see the syntax for reducing the first extent size of a fragment.
> >
> > When I tried:
> > ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06> >
> > I got “dbs02 is full”. Which is true. But what was it trying to do?
> > Perhaps if
> > I added just a tiny chunk to dbs02 I'd be OK?
> >
> > What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
Which, being translated and truncated (removing much of the email to which
it reponds), says:
the table shrink function will remove all free space at the end of the
table to the
first extent size. You can first alter the table adjusting the first
extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> From: "NEIL TRUBY" <neil.truby@ardenta.com>
> To: ids@iiug.org,
> Date: 03/22/2013 10:48 AM
> Subject: Drop or resize fragment [29880]
> Sent by: ids-bounces@iiug.org
>
> We've created a table with multiple fragments.
John's second attempt said (with most of the email being responded to
included):
The table/fragment shrink function will remove all free space at the end of
the table/fragment
to the first extent size. You can first alter the table adjusting the
first extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> From: "NEIL TRUBY" <neil.truby@ardenta.com>
> To: ids@iiug.org,
> Date: 03/22/2013 10:48 AM
> Subject: Drop or resize fragment [29880]
> Sent by: ids-bounces@iiug.org
>
> We've created a table with multiple fragments. It's fragmented by
expression
> so each fragment holds a month's data and is about 4g in size.
>
> Now one of the dbspaces is full! I'd like to drop some of the *future*
> fragments that don't have anything in them yet, say the one for 2013_06,
or
> even better resize it much smaller.
>
> I can't see the syntax for reducing the first extent size of a fragment.
>
> When I tried:
> ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06>
> I got “dbs02 is full”. Which is true. But what was it trying to do?
> Perhaps if
> I added just a tiny chunk to dbs02 I'd be OK?
>
> What I really do NOT want is for the whole table, all 1 billion rows, to
be
> processed. This fragment is empty and the operation should, I hope, be
> instantaneous?
>
> Thanks
> N
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Which, being translated (and marginally truncated and cleaned up), is:
The table/fragment shrink function will remove all free space at the end of
> the table/fragment
> to the first extent size. You can first alter the table adjusting the
> first extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
> execute function task("table shrink", "tabname","dbsname")>
>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbspaces is full! I'd like to drop some of the *future*
> > fragments t
Aha... So there is a translator! :)
On Sat, Mar 23, 2013 at 11:31 AM, Jonathan Leffler <
jonathan.leffler@gmail.com> wrote:
> On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii <miller3@us.ibm.com
> >wrote:
>
> >
> >
> the table shrink function will remove all free space at the end of the
> table to the
> first extent size. You can first alter the table adjusting the first
> extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
>
> execute function task("table shrink", "tabname","dbsname")>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbspaces is full! I'd like to drop some of the *future*
> > fragments that don't have anything in them yet, say the one for 2013_06,
> or
> > even better resize it much smaller.
> >
> > I can't see the syntax for reducing the first extent size of a fragment.
> >
> > When I tried:
> > ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06> >
> > I got “dbs02 is full”. Which is true. But what was it trying to do?
> > Perhaps if
> > I added just a tiny chunk to dbs02 I'd be OK?
> >
> > What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a re
> > c3BvbnNlIGluIHRoZSBkaXNjdXNzaW9uIGZvcnVtLg0KPg==
> >
>
> Which, being translated and truncated (removing much of the email to which
> it reponds), says:
>
> the table shrink function will remove all free space at the end of the
> table to the
> first extent size. You can first alter the table adjusting the first
> extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
> execute function task("table shrink", "tabname","dbsname")>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments.
>
> John's second attempt said (with most of the email being responded to
> included):
>
> The table/fragment shrink function will remove all free space at the end of
> the table/fragment
> to the first extent size. You can first alter the table adjusting the
> first extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
> execute function task("table shrink", "tabname","dbsname")>
>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbspaces is full! I'd like to drop some of the *future*
> > fragments that don't have anything in them yet, say the one for 2013_06,
> or
> > even better resize it much smaller.
> >
> > I can't see the syntax for reducing the first extent size of a fragment.
> >
> > When I tried:
> > ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06> >
> > I got “dbs02 is full”. Which is true. But what was it trying to do?
> > Perhaps if
> > I added just a tiny chunk to dbs02 I'd be OK?
> >
> > What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> Which, being translated (and marginally truncated and cleaned up), is:
>
> The table/fragment shrink function will remove all free space at the end of
> > the table/fragment
> > to the first extent size. You can first alter the table adjusting the
> > first extent size, then remove
> > all the free space at the end of each fragment by using the shrink
> command.
> >
> > execute function task("fragment shrink", partnum)> >@@NL@
And all this time, I thought that John was now speaking encryption... ;-)
From: "Fernando Nunes" <domusonline@gmail.com>
To: ids@iiug.org,
Date: 03/23/2013 06:42 AM
Subject: Re: Drop or resize fragment [29891]
Sent by: ids-bounces@iiug.org
Aha... So there is a translator! :)
On Sat, Mar 23, 2013 at 11:31 AM, Jonathan Leffler <
jonathan.leffler@gmail.com> wrote:
> On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii <miller3@us.ibm.com
> >wrote:
>
> >
> >
>
the table shrink function will remove all free space at the end of the
table to the
first extent size. You can first alter the table adjusting the first
extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bou
> >
> >
> bmNlc0BpaXVnLm9yZyB3cm90ZSBvbiAwMy8yMi8yMDEzIDEwOjQ3OjI0IEFNOg0KDQo
+IEZyb206
> >
> >
>
"NEIL TRUBY" <neil.truby@ardenta.com>
> To: ids@iiug.org,
> Date: 03/22/2013 10:48 AM
> Subject: Drop or resize fragment [29880]
> Sent by: ids-bounces@iiug.org
>
> We've created a table with multiple fragments. It's fragmented by
expression
> so each fragment holds a month's data and is about 4g in size.
>
> Now one of the dbsp
> >
> >
> YWNlcyBpcyBmdWxsISBJJ2QgbGlrZSB0byBkcm9wIHNvbWUgb2YgdGhlICpmdXR1cmUqDQo
+IGZy
> >
> >
>
YWdtZW50cyB0aGF0IGRvbid0IGhhdmUgYW55dGhpbmcgaW4gdGhlbSB5ZXQsIHNheSB0aGUgb25l
> >
> >
>
IGZvciAyMDEzXzA2LA0Kb3INCj4gZXZlbiBiZXR0ZXIgcmVzaXplIGl0IG11Y2ggc21hbGxlci4N
> >
> >
>
Cj4NCj4gSSBjYW4ndCBzZWUgdGhlIHN5bnRheCBmb3IgcmVkdWNpbmcgdGhlIGZpcnN0IGV4dGVu
> >
> >
> dCBzaXplIG9mIGEgZnJhZ21lbnQuDQo+DQo
+IFdoZW4gSSB0cmllZDoNCj4gQUxURVIgRlJBR01F
> >
> >
> TlQgT04gVEFCTEUgdGFibGVuYW1lIERST1AgUEFSVElUSU9OIHAyMDEzXzA2DQo+DQo
+IEkgZ290
> >
> >
>
IOKAnGRiczAyIGlzIGZ1bGzigJ0uIFdoaWNoIGlzIHRydWUuIEJ1dCB3aGF0IHdhcyBpdCB0cnlp
> >
> >
> bmcgdG8gZG8/DQo
+IFBlcmhhcHMgaWYNCj4gSSBhZGRlZCBqdXN0IGEgdGlueSBjaHVuayB0byBk
> >
> >
> YnMwMiBJJ2QgYmUgT0s/DQo+DQo
What I really do NOT want is for the whole table, all 1 billion rows, to
be
> processed. This fragment is empty and the operation should, I hope, be
> instantaneous?
>
> Thanks
> N
>
>
>
******************************************************************
> >
> >
> KioqKioqKioqKioqKg0KDQo
+ICAgRm9ydW0gTm90ZTogVXNlICJSZXBseSIgdG8gcG9zdCBhIHJl
> > c3BvbnNlIGluIHRoZSBkaXNjdXNzaW9uIGZvcnVtLg0KPg==
> >
>
> Which, being translated and truncated (removing much of the email to
which
> it reponds), says:
>
> the table shrink function will remove all free space at the end of the
> table to the
> first extent size. You can first alter the table adjusting the first
> extent size, then remove
> all the free space at the end of each fragment by using the shrink
command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
> execute function task("table shrink", "tabname","dbsname")>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments.
>
> John's second attempt said (with most of the email being responded to
> included):
>
> VGhlIHRhYmxlL2ZyYWdtZW50IHNocm
> luayBmdW5jdGlvbiB3aWxsIHJlbW92ZSBhbGwgZnJlZSBz
>
>
pace at the end of
the table/fragment
to the first extent size. You can first alter the table adjusting the
first extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2013 10:47:2
>
> NCBBTToNCg0KPiBGcm9tOiAiTkVJTCBUUlVCWSIgPG5laWwudHJ1YnlAYXJkZW50YS5jb20
+DQo+
>
> IFRvOiBpZHNAaWl1Zy5vcmcsDQo
+IERhdGU6IDAzLzIyLzIwMTMgMTA6NDggQU0NCj4gU3ViamVj
>
>
dDogRHJvcCBvciByZXNpemUgZnJhZ21lbnQgIFsyOTg4MF0NCj4gU2VudCBieTogaWRzLWJvdW5j
>
>
ZXNAaWl1Zy5vcmcNCj4NCj4g
What Madison said was: And all this time, I thought that John was now speaking encryption... ;-) > > > > > From: "Fernando Nunes" <domusonline@gmail.com> > To: ids@iiug.org, > Date: 03/23/2013 06:42 AM > Subject: Re: Drop or resize fragment [29891] > Sent by: ids-bounces@iiug.org > > > > Aha... So there is a translator! :) > > On Sat, Mar 23, 2013 at 11:31 AM, Jonathan Leffler < > jonathan.leffler@gmail.com> wrote: > > > On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii <miller3@us.ibm.comwrote: > > >dGhlIHRhYmxlIHNocmluayBmdW5jdGlvbiB3aWxsIHJlbW92ZSBhbGwgZnJlZS [...] > Lotus Notes is an interesting product... 2013/3/23 Madison Pruet <mpruet@us.ibm.com> > > And all this time, I thought that John was now speaking encryption... ;-) > > > > > From: "Fernando Nunes" <domusonline@gmail.com> > To: ids@iiug.org, > Date: 03/23/2013 06:42 AM > Subject: Re: Drop or resize fragment [29891] > Sent by: ids-bounces@iiug.org > > > > Aha... So there is a translator! :) > > On Sat, Mar 23, 2013 at 11:31 AM, Jonathan Leffler < > jonathan.leffler@gmail.com> wrote: > > > On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii <miller3@us.ibm.com > > >wrote: > > > > > > > > > > > dGhlIHRhYmxlIHNocmluayBmdW5jdGlvbiB3aWxsIHJlbW92ZSBhbGwgZnJlZSBzcGFjZSBhdCB0 > > > > > > > > > > aGUgZW5kIG9mIHRoZQ0KdGFibGUgdG8gdGhlDQpmaXJzdCBleHRlbnQgc2l6ZS4gICBZb3UgY2Fu > > > > > > > > > > IGZpcnN0IGFsdGVyIHRoZSB0YWJsZSBhZGp1c3RpbmcgdGhlIGZpcnN0DQpleHRlbnQgc2l6ZSwg > > > > > > > > > > dGhlbiByZW1vdmUNCmFsbCB0aGU > [...snip...] > I'm assuming that those who want to read it can do so, if forced to. The material is Base-64 text. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2013.0118 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --047d7b343b1cca5bf604d89a9372
And I thought he was connect to the SETI databases... ;) On Mar 23, 2013 5:05 PM, "Jonathan Leffler" <jonathan.leffler@gmail.com> wrote: > What Madison said was: > > And all this time, I thought that John was now speaking encryption... ;-) > > > > > > > > > > From: "Fernando Nunes" <domusonline@gmail.com> > > To: ids@iiug.org, > > Date: 03/23/2013 06:42 AM > > Subject: Re: Drop or resize fragment [29891] > > Sent by: ids-bounces@iiug.org > > > > > > > > Aha... So there is a translator! :) > > > > On Sat, Mar 23, 2013 at 11:31 AM, Jonathan Leffler < > > jonathan.leffler@gmail.com> wrote: > > > > > On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii > <miller3@us.ibm.comwrote: > > > >dGhlIHRhYmxlIHNocmluayBmdW5jdGlvbiB3aWxsIHJlbW92ZSBhbGwgZnJlZS [...] > > > > Lotus Notes is an interesting product... > > 2013/3/23 Madison Pruet <mpruet@us.ibm.com> > > > > > > And all this time, I thought that John was now speaking encryption... ;-) > > > > > From: "Fernando Nunes" <domusonline@gmail.com> > To: ids@iiug.org, > Date: 03/23/2013 06:42 AM > Subject: Re: Drop or resize fragment [29891] > Sent by: ids-bounces@iiug.org > > > > Aha... So there is a translator! :) > > On Sat, Mar 23, 2013 at 11:31 AM, Jonathan Leffler < > jonathan.leffler@gmail.com> wrote: > > > On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii <miller3@us.ibm.com > > >wrote: > > > > > > > > > > > dGhlIHRhYmxlIHNocmluayBmdW5jdGlvbiB3aWxsIHJlbW92ZSBhbGwgZnJlZSBzcGFjZSBhdCB0 > > > > > > > > > > aGUgZW5kIG9mIHRoZQ0KdGFibGUgdG8gdGhlDQpmaXJzdCBleHRlbnQgc2l6ZS4gICBZb3UgY2Fu > > > > > > > > > > IGZpcnN0IGFsdGVyIHRoZSB0YWJsZSBhZGp1c3RpbmcgdGhlIGZpcnN0DQpleHRlbnQgc2l6ZSwg > > > > > > > > > > dGhlbiByZW1vdmUNCmFsbCB0aGU > > [...snip...] > > > > I'm assuming that those who want to read it can do so, if forced to. The > material is Base-64 text. > > -- > Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> > Guardian of DBD::Informix - v2013.0118 - http://dbi.perl.org > "Blessed are we who can laugh at ourselves, for we shall never cease to be > amused." > > --047d7b343b1cca5bf604d89a9372 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf3079ba56550e2904d89b18f6
I beleive John is trying to say this:
the table shrink function will remove all free space at the end of the
table to the
first extent size. You can first alter the table adjusting the first
extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> From: "NEIL TRUBY" <neil.truby@ardenta.com>
> To: ids@iiug.org,
> Date: 03/22/2013 10:48 AM
> Subject: Drop or resize fragment [29880]
> Sent by: ids-bounces@iiug.org
>
> We've created a table with multiple fragments. It's fragmented by
expression
> so each fragment holds a month's data and is about 4g in size.
>
> Now one of the dbspaces is full! I'd like to drop some of the *future*
> fragments that don't have anything in them yet, say the one for 2013_06,
or
> even better resize it much smaller.
>
> I can't see the syntax for reducing the first extent size of a fragment.
>
> When I tried:
> ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06>
> I got dbs02 is full. Which is true. But what was it trying to do?
> Perhaps if
> I added just a tiny chunk to dbs02 I'd be OK?
>
> What I really do NOT want is for the whole table, all 1 billion rows, to
be
> processed. This fragment is empty and the operation should, I hope, be
> instantaneous?
>
> Thanks
> N
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
On 22.3.2013. 19:31, John Miller iii wrote:
> the table shrink function will remove all free space at the end of the
> table to the
> first extent size. You can first alter the table adjusting the first
> extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
>
> execute function task("table shrink", "tabname","dbsname")>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbspaces is full! I'd like to drop some of the *future*
> > fragments that don't have anything in them yet, say the one for 2013_06,
> or
> > even better resize it much smaller.
> >
> > I can't see the syntax for reducing the first extent size of a fragment.
> >
> > When I tried:
> > ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06> >
> > I got “dbs02 is full”. Which is true. But what was it trying to do?
> > Perhaps if
> > I added just a tiny chunk to dbs02 I'd be OK?
> >
> > What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
And this time John said:
The table/fragment shrink function will remove all free space at the end of
the table/fragment
to the first extent size. You can first alter the table adjusting the
first extent size, then remove
all the free space at the end of each fragment by using the shrink command.
execute function task("fragment shrink", partnum)
OR
execute function task("table shrink", "tabname","dbsname")
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> From: "NEIL TRUBY" <neil.truby@ardenta.com>
> To: ids@iiug.org,
> Date: 03/22/2013 10:48 AM
> Subject: Drop or resize fragment [29880]
> Sent by: ids-bounces@iiug.org
>
> We've created a table with multiple fragments. It's fragmented by
expression
> so each fragment holds a month's data and is about 4g in size.
>
> Now one of the dbspaces is full! I'd like to drop some of the *future*
> fragments that don't have anything in them yet, say the one for 2013_06,
or
> even better resize it much smaller.
>
> I can't see the syntax for reducing the first extent size of a fragment.
>
> When I tried:
> ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06>
> I got dbs02 is full. Which is true. But what was it trying to do?
> Perhaps if
> I added just a tiny chunk to dbs02 I'd be OK?
>
> What I really do NOT want is for the whole table, all 1 billion rows, to
be
> processed. This fragment is empty and the operation should, I hope, be
> instantaneous?
>
> Thanks
> N
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
On 22.3.2013. 20:23, John Miller iii wrote:
> The table/fragment shrink function will remove all free space at the end of
> the table/fragment
> to the first extent size. You can first alter the table adjusting the
> first extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
> execute function task("table shrink", "tabname","dbsname")>
>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
> ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
>
> > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbspaces is full! I'd like to drop some of the *future*
> > fragments that don't have anything in them yet, say the one for 2013_06,
> or
> > even better resize it much smaller.
> >
> > I can't see the syntax for reducing the first extent size of a fragment.
> >
> > When I tried:
> > ALTER FRAGMENT ON TABLE tablename DROP PARTITION p2013_06> >
> > I got “dbs02 is full”. Which is true. But what was it trying to do?
> > Perhaps if
> > I added just a tiny chunk to dbs02 I'd be OK?
> >
> > What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
Okay ... now my gmail thinks the following is Chinese ... but last time I
talked to Madison, he didn't know the language.
Is there any methodology by which people who accidentally post this format
could have their "real" reply listed instead of the following?
Take care.
Clifton
2013/3/23 Madison Pruet <mpruet@us.ibm.com>
>
> And all this time, I thought that John was now speaking encryption... ;-)
>
>
>
>
> From: "Fernando Nunes" <domusonline@gmail.com>
> To: ids@iiug.org,
> Date: 03/23/2013 06:42 AM
> Subject: Re: Drop or resize fragment [29891]
> Sent by: ids-bounces@iiug.org
>
>
>
> Aha... So there is a translator! :)
>
> On Sat, Mar 23, 2013 at 11:31 AM, Jonathan Leffler <
> jonathan.leffler@gmail.com> wrote:
>
> > On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii <miller3@us.ibm.com
> > >wrote:
> >
> > >
> > >
> >
> the table shrink function will remove all free space at the end of the
> table to the
> first extent size. You can first alter the table adjusting the first
> extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
>
> execute function task("table shrink", "tabname","dbsname")>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
>
> ids-bou
>
> > >
> > >
> > bmNlc0BpaXVnLm9yZyB3cm90ZSBvbiAwMy8yMi8yMDEzIDEwOjQ3OjI0IEFNOg0KDQo
> +IEZyb206
> > >
> > >
> >
> "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbsp
>
> > >
> > >
> > YWNlcyBpcyBmdWxsISBJJ2QgbGlrZSB0byBkcm9wIHNvbWUgb2YgdGhlICpmdXR1cmUqDQo
> +IGZy
> > >
> > >
> >
> YWdtZW50cyB0aGF0IGRvbid0IGhhdmUgYW55dGhpbmcgaW4gdGhlbSB5ZXQsIHNheSB0aGUgb25l
>
> > >
> > >
> >
> IGZvciAyMDEzXzA2LA0Kb3INCj4gZXZlbiBiZXR0ZXIgcmVzaXplIGl0IG11Y2ggc21hbGxlci4N
>
> > >
> > >
> >
> Cj4NCj4gSSBjYW4ndCBzZWUgdGhlIHN5bnRheCBmb3IgcmVkdWNpbmcgdGhlIGZpcnN0IGV4dGVu
>
> > >
> > >
> > dCBzaXplIG9mIGEgZnJhZ21lbnQuDQo+DQo
> +IFdoZW4gSSB0cmllZDoNCj4gQUxURVIgRlJBR01F
> > >
> > >
> > TlQgT04gVEFCTEUgdGFibGVuYW1lIERST1AgUEFSVElUSU9OIHAyMDEzXzA2DQo+DQo
> +IEkgZ290
> > >
> > >
> >
> IOKAnGRiczAyIGlzIGZ1bGzigJ0uIFdoaWNoIGlzIHRydWUuIEJ1dCB3aGF0IHdhcyBpdCB0cnlp
>
> > >
> > >
> > bmcgdG8gZG8/DQo
> +IFBlcmhhcHMgaWYNCj4gSSBhZGRlZCBqdXN0IGEgdGlueSBjaHVuayB0byBk
> > >
> > >
> > YnMwMiBJJ2QgYmUgT0s/DQo+DQo
> What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> ******************************************************************
>
> > >
> > >
> > KioqKioqKioqKioqKg0KDQo
> +ICAgRm9ydW0gTm90ZTogVXNlICJSZXBseSIgdG8gcG9zdCBhIHJl
> > > c3BvbnNlIGluIHRoZSBkaXNjdXNzaW9uIGZvcnVtLg0KPg==
> > >
> >
> > Which, being translated and truncated (removing much of the email to
> which
> > it reponds), says:
> >
> > the table shrink function will remove all free space at the end of the
> > table to the
> > first extent size. You can first alter the table adjusting the first
> > extent size, then remove
> > all the free space at the end of each fragment by using the shrink
> command.
> >
> > execute function task("fragment shrink", partnum)> >
> > OR
> >
> > execute function task("table shrink", "tabname","dbsname")> >
> > John F. Miller III
> > STSM, Lead Architect
> > miller3@us.ibm.com
> > 503-747-1366
> > IBM Informix Dynamic Server (IDS)
> >
> > ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> >
> > > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > > To: ids@iiug.org,
> > > Date: 03/22/2013 10:48 AM
> > > Subject: Drop or resize fragment [29880]
> > > Sent by: ids-bounces@iiug.org
> > >
> > > We've created a table with multiple fragments.
> >
> > John's second attempt said (with most of the email being responded to
> > included):
> >
> > VGhlIHRhYmxlL2ZyYWdtZW50IHNocm
> > luayBmdW5jdGlvbiB3aWxsIHJlbW92ZSBhbGwgZnJlZSBz
> >
> >
> cGFjZSBhdCB0aGUgZW5kIG9mDQp0aGUgdGFibGUvZnJhZ21lbnQNCnRvIHRoZSBmaXJzdCBleHRl
>
> >
> >
> bnQgc2l6ZS4gICBZb3UgY2FuIGZpcnN0IGFsdGVyIHRoZSB0YWJsZSBhZGp1c3RpbmcgdGhlDQpm
>
> >
> >
> aXJzdCBleHRlbnQgc2l6ZSwgdGhlbiByZW1vdmUNCmFsbCB0aGUgZnJlZSBzcGFjZSBhdCB0aGUg
>
> >
> >
> ZW5k
Google thinks this message is in Chinese.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
2013/3/23 Madison Pruet <mpruet@us.ibm.com>
>
> And all this time, I thought that John was now speaking encryption... ;-)
>
>
>
>
> From: "Fernando Nunes" <domusonline@gmail.com>
> To: ids@iiug.org,
> Date: 03/23/2013 06:42 AM
> Subject: Re: Drop or resize fragment [29891]
> Sent by: ids-bounces@iiug.org
>
>
>
> Aha... So there is a translator! :)
>
> On Sat, Mar 23, 2013 at 11:31 AM, Jonathan Leffler <
> jonathan.leffler@gmail.com> wrote:
>
> > On Fri, Mar 22, 2013 at 11:31 AM, John Miller iii <miller3@us.ibm.com
> > >wrote:
> >
> > >
> > >
> >
> the table shrink function will remove all free space at the end of the
> table to the
> first extent size. You can first alter the table adjusting the first
> extent size, then remove
> all the free space at the end of each fragment by using the shrink command.
>
> execute function task("fragment shrink", partnum)>
> OR
>
>
> execute function task("table shrink", "tabname","dbsname")>
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
>
>
> ids-bou
>
> > >
> > >
> > bmNlc0BpaXVnLm9yZyB3cm90ZSBvbiAwMy8yMi8yMDEzIDEwOjQ3OjI0IEFNOg0KDQo
> +IEZyb206
> > >
> > >
> >
> "NEIL TRUBY" <neil.truby@ardenta.com>
> > To: ids@iiug.org,
> > Date: 03/22/2013 10:48 AM
> > Subject: Drop or resize fragment [29880]
> > Sent by: ids-bounces@iiug.org
> >
> > We've created a table with multiple fragments. It's fragmented by
> expression
> > so each fragment holds a month's data and is about 4g in size.
> >
> > Now one of the dbsp
>
> > >
> > >
> > YWNlcyBpcyBmdWxsISBJJ2QgbGlrZSB0byBkcm9wIHNvbWUgb2YgdGhlICpmdXR1cmUqDQo
> +IGZy
> > >
> > >
> >
> YWdtZW50cyB0aGF0IGRvbid0IGhhdmUgYW55dGhpbmcgaW4gdGhlbSB5ZXQsIHNheSB0aGUgb25l
>
> > >
> > >
> >
> IGZvciAyMDEzXzA2LA0Kb3INCj4gZXZlbiBiZXR0ZXIgcmVzaXplIGl0IG11Y2ggc21hbGxlci4N
>
> > >
> > >
> >
> Cj4NCj4gSSBjYW4ndCBzZWUgdGhlIHN5bnRheCBmb3IgcmVkdWNpbmcgdGhlIGZpcnN0IGV4dGVu
>
> > >
> > >
> > dCBzaXplIG9mIGEgZnJhZ21lbnQuDQo+DQo
> +IFdoZW4gSSB0cmllZDoNCj4gQUxURVIgRlJBR01F
> > >
> > >
> > TlQgT04gVEFCTEUgdGFibGVuYW1lIERST1AgUEFSVElUSU9OIHAyMDEzXzA2DQo+DQo
> +IEkgZ290
> > >
> > >
> >
> IOKAnGRiczAyIGlzIGZ1bGzigJ0uIFdoaWNoIGlzIHRydWUuIEJ1dCB3aGF0IHdhcyBpdCB0cnlp
>
> > >
> > >
> > bmcgdG8gZG8/DQo
> +IFBlcmhhcHMgaWYNCj4gSSBhZGRlZCBqdXN0IGEgdGlueSBjaHVuayB0byBk
> > >
> > >
> > YnMwMiBJJ2QgYmUgT0s/DQo+DQo
> What I really do NOT want is for the whole table, all 1 billion rows, to
> be
> > processed. This fragment is empty and the operation should, I hope, be
> > instantaneous?
> >
> > Thanks
> > N
> >
> >
> >
> ******************************************************************
>
> > >
> > >
> > KioqKioqKioqKioqKg0KDQo
> +ICAgRm9ydW0gTm90ZTogVXNlICJSZXBseSIgdG8gcG9zdCBhIHJl
> > > c3BvbnNlIGluIHRoZSBkaXNjdXNzaW9uIGZvcnVtLg0KPg==
> > >
> >
> > Which, being translated and truncated (removing much of the email to
> which
> > it reponds), says:
> >
> > the table shrink function will remove all free space at the end of the
> > table to the
> > first extent size. You can first alter the table adjusting the first
> > extent size, then remove
> > all the free space at the end of each fragment by using the shrink
> command.
> >
> > execute function task("fragment shrink", partnum)> >
> > OR
> >
> > execute function task("table shrink", "tabname","dbsname")> >
> > John F. Miller III
> > STSM, Lead Architect
> > miller3@us.ibm.com
> > 503-747-1366
> > IBM Informix Dynamic Server (IDS)
> >
> > ids-bounces@iiug.org wrote on 03/22/2013 10:47:24 AM:
> >
> > > From: "NEIL TRUBY" <neil.truby@ardenta.com>
> > > To: ids@iiug.org,
> > > Date: 03/22/2013 10:48 AM
> > > Subject: Drop or resize fragment [29880]
> > > Sent by: ids-bounces@iiug.org
> > >
> > > We've created a table with multiple fragments.
> >
> > John's second attempt said (with most of the email being responded to
> > included):
> >
> > VGhlIHRhYmxlL2ZyYWdtZW50IHNocm
> > luayBmdW5jdGlvbiB3aWxsIHJlbW92ZSBhbGwgZnJlZSBz
> >
> >
> cGFjZSBhdCB0aGUgZW5kIG9mDQp0aGUgdGFibGUvZnJhZ21lbnQNCnRvIHRoZSBmaXJzdCBleHRl
>
> >
> >