Free space and archive compression
I have recently had a couple of tables that grew very large. The tables were
unloaded with reasonable date range data and recreated. My understanding is
that archives contain all binary blocks that include the random portions of
past table entries even after the table is gone.
Question: Is there a way to (safely and) effectively "zero" out unused
instance space in order to improve (ontape) archive compression capability?
IDS 11.5 64bit
Thanks
pjwelsh
Archives ONLY include pages that are part of existing partition's extents.
Dropped extents are NOT included in the archive.
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 18, 2011 at 9:55 AM, PHILLIPPE WELSH <pj@cassens.com> wrote:
> I have recently had a couple of tables that grew very large. The tables
> were
> unloaded with reasonable date range data and recreated. My understanding is
> that archives contain all binary blocks that include the random portions of
> past table entries even after the table is gone.
>
> Question: Is there a way to (safely and) effectively "zero" out unused
> instance space in order to improve (ontape) archive compression capability?
>
> IDS 11.5 64bit
>
> Thanks
> pjwelsh
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec519698b23b5ea049ec23dff
Perfect! Thank you very much for the correction in my understanding. That means less effort now ;) Thank you pjwelsh
IF you are in 11.50.FC4 or above you repack/shrink of Storage Optimization.
This is a feature purchased separately even in Ultimate Edition. But as far as
I know, it can be used repack/shrink just reorg table, contact you IBM
representative.
Another option is unload all remaining data, recreate the table with enough
space (first extent/next extent) and load data again.
Celso Cabral Coimbra
Administrador de Banco de Dados
ClearTech Ltda
"Trust at the heart of Communications"
Tel. (11) 3576-4509
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de PHILLIPPE
WELSH
Enviada em: sexta-feira, 18 de março de 2011 10:56
Para: ids@iiug.org
Assunto: Free space and archive compression [23158]
I have recently had a couple of tables that grew very large. The tables were
unloaded with reasonable date range data and recreated. My understanding is
that archives contain all binary blocks that include the random portions of
past table entries even after the table is gone.
Question: Is there a way to (safely and) effectively "zero" out unused
instance space in order to improve (ontape) archive compression capability?
IDS 11.5 64bit
Thanks
pjwelsh
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Just to clarify an item. Compressing a table is an option which
you must pay for. The use of the repack/shrink options are NOT a
charged option in any version of the Informix server.
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/18/2011 07:20:59 AM:
> From:
>
> "Celso Cabral Coimbra" <ccoimbra@cleartech.com.br>
>
> To:
>
> ids@iiug.org
>
> Date:
>
> 03/18/2011 07:21 AM
>
> Subject:
>
> RES: Free space and archive compression [23161]
>
> Sent by:
>
> ids-bounces@iiug.org
>
> IF you are in 11.50.FC4 or above you repack/shrink of Storage
Optimization.
> This is a feature purchased separately even in Ultimate Edition. Buta=
s
far as
> I know, it can be used repack/shrink just reorg table, contact you IB=
M
> representative.
> Another option is unload all remaining data, recreate the table with
enough
> space (first extent/next extent) and load data again.
>
> Celso Cabral Coimbra
> Administrador de Banco de Dados
> ClearTech Ltda
> "Trust at the heart of Communications"
> Tel. (11) 3576-4509
>
> -----Mensagem original-----
> De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de
PHILLIPPE
> WELSH
> Enviada em: sexta-feira, 18 de mar=E7o de 2011 10:56
> Para: ids@iiug.org
> Assunto: Free space and archive compression [23158]
>
> I have recently had a couple of tables that grew very large. The tabl=
es
were
> unloaded with reasonable date range data and recreated. My understand=
ing
is
> that archives contain all binary blocks that include the random porti=
ons
of
> past table entries even after the table is gone.
>
> Question: Is there a way to (safely and) effectively "zero" out unuse=
d
> instance space in order to improve (ontape) archive compression
capability?
>
> IDS 11.5 64bit
>
> Thanks
> pjwelsh
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.=
>=