Table compression estimate

Posted in 2009

Topics: Platform-Specific Issues, Versions, Editions & End-of-Life

Peter_Logan@spartanstores.com — Thu, 02 Jul 2009 18:45:56 — source: IIUG Forums & Mailing Lists

I am currently on Aix 6.1, IDS 11.50.fc4. I'm running the task 'table estimate_compression' from the sysadmin database. Sometimes it works, and other times I get an error. I'm including the output from a table that worked and one that didn't. I also have included the online log. Anyone have any similar issues, and if so, how did they get around it ... We are trying to analyze what we would gain with compression. thanks for any and all help. Peter Logan Senior Database Administrator Phone: 616/878-8309 Database selected. (expression) est curr change partnum table ----- ----- ------ ---------- ----------------------------------- 73.3% 0.0% +73.3 0x01f005cc hruat90:SHRUAT8.pstreenode Succeeded: table estimate_compression hruat90:SHRUAT8.pstreenode 1 row(s) retrieved. Database closed. Database selected. (expression) est curr change partnum table ----- ----- ------ ---------- ----------------------------------- FAILED: table estimate_compression hruat90:SHRUAT8.ps_leave_accr ual 1 row(s) retrieved. Database closed. IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 4 days 17:35:35 -- 2686608 Kbytes Message Log File: /usr/local/informix/logs/hruat_online.log14:16:45 SCHAPI Estimate Compression for hruat90:SHRUAT8.pstreenode started 14:16:47 SCHAPI table estimate_compression hruat90:SHRUAT8.pstreenode succeeded 14:19:53 SCHAPI Estimate Compression for hruat90:SHRUAT8.ps_leave_accrual started 14:19:53 Compression related operations not allowed on index partition hruat90:SHRUAT8.ps_leave_accrual 14:19:53 ERROR hruat90:SHRUAT8.ps_leave_accrual: rscCommand failed for partnum 19923125 14:19:53 Estimate Compression failed for hruat90:SHRUAT8.ps_leave_accrual, iserrno 0 14:19:53 SCHAPI ERROR: table estimate_compression hruat90:SHRUAT8.ps_leave_accrual failed

↪ replying to Peter_Logan@spartanstores.com

Nilesh Ozarkar — Mon, 06 Jul 2009 15:27:49 — source: IIUG Forums & Mailing Lists

You cannot compress or estimate compression of an index partition. Answer is in the online.log > 14:19:53 Compression related operations not allowed on index partition > hruat90:SHRUAT8.ps_leave_accrual HTH, Nilesh ids-bounces@iiug.org wrote on 07/02/2009 01:45:56 PM: > [image removed] > > Table compression estimate [16221] > > Peter_Logan@spartanstores.com > > to: > > ids > > 07/02/2009 01:47 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I am currently on Aix 6.1, IDS 11.50.fc4. I'm running the task 'table > estimate_compression' from the sysadmin database. Sometimes it works, and > other times I get an error. I'm including the output from a table that > worked and one that didn't. I also have included the online log. Anyone > have any similar issues, and if so, how did they get around it ... We are > trying to analyze what we would gain with compression. > > thanks for any and all help. > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > Database selected. > > (expression) est curr change partnum table > > ----- ----- ------ ---------- ----------------------------------- > > 73.3% 0.0% +73.3 0x01f005cc hruat90:SHRUAT8.pstreenode > > Succeeded: table estimate_compression hruat90:SHRUAT8.pstreenode > > 1 row(s) retrieved. > > Database closed. > > Database selected. > > (expression) est curr change partnum table > > ----- ----- ------ ---------- ----------------------------------- > > FAILED: table estimate_compression hruat90:SHRUAT8.ps_leave_accr > > ual > > 1 row(s) retrieved. > > Database closed. > > IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 4 > days 17:35:35 > -- 2686608 Kbytes > > Message Log File: /usr/local/informix/logs/hruat_online.log> 14:16:45 SCHAPI Estimate Compression for hruat90:SHRUAT8.pstreenode started > 14:16:47 SCHAPI table estimate_compression hruat90:SHRUAT8.pstreenode > succeeded > 14:19:53 SCHAPI Estimate Compression for hruat90:SHRUAT8.ps_leave_accrual > started > 14:19:53 Compression related operations not allowed on index partition > hruat90:SHRUAT8.ps_leave_accrual > 14:19:53 ERROR hruat90:SHRUAT8.ps_leave_accrual: rscCommand failed > for partnum > 19923125 > 14:19:53 Estimate Compression failed for hruat90:SHRUAT8.ps_leave_accrual, > iserrno 0 > 14:19:53 SCHAPI ERROR: table estimate_compression > hruat90:SHRUAT8.ps_leave_accrual failed > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Nilesh Ozarkar

Peter_Logan@spartanstores.com — Tue, 07 Jul 2009 12:51:16 — source: IIUG Forums & Mailing Lists

I understand that .. Table and indexes are in different dbspaces ... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Nilesh Ozarkar" <nilesho@us.ibm.com> To: ids@iiug.org Date: 07/06/2009 11:29 AM Subject: Re: Table compression estimate [16240] Sent by: ids-bounces@iiug.org You cannot compress or estimate compression of an index partition. Answer is in the online.log > 14:19:53 Compression related operations not allowed on index partition > hruat90:SHRUAT8.ps_leave_accrual HTH, Nilesh ids-bounces@iiug.org wrote on 07/02/2009 01:45:56 PM: > [image removed] > > Table compression estimate [16221] > > Peter_Logan@spartanstores.com > > to: > > ids > > 07/02/2009 01:47 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I am currently on Aix 6.1, IDS 11.50.fc4. I'm running the task 'table > estimate_compression' from the sysadmin database. Sometimes it works, and > other times I get an error. I'm including the output from a table that > worked and one that didn't. I also have included the online log. Anyone > have any similar issues, and if so, how did they get around it ... We are > trying to analyze what we would gain with compression. > > thanks for any and all help. > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > Database selected. > > (expression) est curr change partnum table > > ----- ----- ------ ---------- ----------------------------------- > > 73.3% 0.0% +73.3 0x01f005cc hruat90:SHRUAT8.pstreenode > > Succeeded: table estimate_compression hruat90:SHRUAT8.pstreenode > > 1 row(s) retrieved. > > Database closed. > > Database selected. > > (expression) est curr change partnum table > > ----- ----- ------ ---------- ----------------------------------- > > FAILED: table estimate_compression hruat90:SHRUAT8.ps_leave_accr > > ual > > 1 row(s) retrieved. > > Database closed. > > IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 4 > days 17:35:35 > -- 2686608 Kbytes > > Message Log File: /usr/local/informix/logs/hruat_online.log> 14:16:45 SCHAPI Estimate Compression for hruat90:SHRUAT8.pstreenode started > 14:16:47 SCHAPI table estimate_compression hruat90:SHRUAT8.pstreenode > succeeded > 14:19:53 SCHAPI Estimate Compression for hruat90:SHRUAT8.ps_leave_accrual > started > 14:19:53 Compression related operations not allowed on index partition > hruat90:SHRUAT8.ps_leave_accrual > 14:19:53 ERROR hruat90:SHRUAT8.ps_leave_accrual: rscCommand failed > for partnum > 19923125 > 14:19:53 Estimate Compression failed for hruat90:SHRUAT8.ps_leave_accrual, > iserrno 0 > 14:19:53 SCHAPI ERROR: table estimate_compression > hruat90:SHRUAT8.ps_leave_accrual failed > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

IDS (Informix Dynamic Server)