Storage Optimization

Aix 7.1 IDS 12.10.fc1 I have been tasked with doing some testing with compression to determine the benefits we would receive on our data. I have a test system where we have moved one of our production databases and I am working to compress some of are larger tables. In doing so I am also repacking and shrinking in the same command. My question is, I'm seeing very long times for some of these tables on the repack part of the command: onstat -g sdk I've seen times as high as 30 hrs. My question is ... Are there any suggestions as to ways to increase the performance of this ... I am the only thing on the box, and really don't want to have to process this for days to see the end results. Thanks for any help.... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309

Hello, Peter. If you just want to estimate your compression, you could use a windows tool named "Informix compression estimator". It should not impact your box performance, since it´s running externally, in a good average basis. But I don´t think it will predict your index compression, unless it has support for it (new feature in your 12.10 version). The only way to speed up repack tasks, it is using the OFFLINE method. Always have in mind that this is a separated licensed option, so make sure you can use it. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: Peter_Logan@spartanstores.com > Subject: Storage Optimization [31018] > Date: Mon, 29 Jul 2013 11:30:02 -0400 > > Aix 7.1 > IDS 12.10.fc1 > > I have been tasked with doing some testing with compression to determine > the benefits we would receive on our data. I have a test system where we > have moved one of our production databases and I am working to compress > some of are larger tables. In doing so I am also repacking and shrinking > in the same command. > > My question is, I'm seeing very long times for some of these tables on the > repack part of the command: > > onstat -g sdk> > I've seen times as high as 30 hrs. My question is ... Are there any > suggestions as to ways to increase the performance of this ... I am the > only thing on the box, and really don't want to have to process this for > days to see the end results. > > Thanks for any help.... > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >