question about enable compression
Chuan Lu asked what the task enable compression does when doing online table repack and shrink. Fernando Nunes said it is not needed for shrink or repack, only for compression, which requires a licence. Chuan said shrink interrupted the application without it. John Miller III said it is only required in 11.50, where it converts disk structures.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
HI, I could do online repack and online shrink with below script. 1,running a program to do the insert for the user table; 2,execute function task(enable compression,testab,'userdb',informix); 3,execute function task(table repack',testab,'userdb',informix); 4,execute function task(table shrink,testab,'userdb',informix); my confuse is what the 'enable compression doing? after execute it, do all the user tables will be compressed? that isn't my expection. which document has the description of enable compression? thanks for your time?
You shouldn't need "enable compression" to do a shrink or repack. "enable compression" is required to compress a table for example. Note that in order for one to use "enable compression" he must be licensed to do so. Regards On Mon, Dec 7, 2015 at 11:28 PM, CHUAN LU <luchuan@cn.ibm.com> wrote: > HI, > I could do online repack and online shrink with below script. > > 1,running a program to do the insert for the user table; > > 2,execute function task(enable compression,testab,'userdb',informix); > > 3,execute function task(table repack',testab,'userdb',informix); > > 4,execute function task(table shrink,testab,'userdb',informix); > > my confuse is what the 'enable compression doing? after execute it, do all > the user tables will be compressed? that isn't my expection. > > which document has the description of enable compression? > > thanks for your time? > > > > ******************************************************************************* > 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... --001a113f288c2283f205265756b1
but I found if i don't execute 'enable compression', the 'shrink' could interupt the application. after I execute 'enable compression', the shrink become the online operation.
Enable compression is only required in version 11.50 as i= t does a conversion of disk structures to prepare the system for compressio= n. John F. Miller III STSM, Lead Arch= itect [1]miller3@us.ibm.com 50= 3-747-1366 IBM Informix Dynamic Server (IDS) [2]-----ids-bounces@iiug.org wrote: ----- >To: [3]ids@iiug.org >From: = "CHUAN LU" >Sent by: [4]ids-bounces@iiug.org >Date: 12/07/2015 03:51PM &g= t;Subject: Re: question about enable compression [36186] > >bu= t I found if i don't execute 'enable compression', the 'shrink' >coul= d >interupt the application. after I execute 'enable compression', t= he >shrink >become the online operation. > > &= gt;******************************************************************* ** >********** > Forum Note: Use "Reply" to post a response in the= discussion forum. > > > References 1. 3D"mailto:miller3@us.ibm.com" 2. 3D"mailto:-----ids-bounces@iiug.or= 3. 3D"mailto:ids@iiug.org" 4. 3D"mailto:ids-bounc=