Save 
Join IIUG
 for   
 

Informix News
29 July 09 - Wall Street Journal - IBM to Acquire SPSS, Adding to Acquisitions... Read
11 February 09 - InformationWeek - IBM Drifts Slowly Toward Mainstream Cloud Computing... Read
11 February 09 - CNNMoney.com - IBM to Deliver Software via Cloud Computing With Amazon Web Services... Read
07 January 09 - Huliq News - IBM Power Servers Helps Bank of Chengdu Build Up Core Banking System.. Read
04 December 08 - Steeleye - Multicarta achieves 99.997% uptime for its Informix-based Credit Card Authorization Centre... Read
16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read
14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read
29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read
29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read
28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read
28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read
09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read
08 April 08 - IT-Director.com - Informix seeks developers... Read
18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read
17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read
17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read
16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read
16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read
28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read
27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read
14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read
14 June 07 - eChannelLine - IBM expands scope for IDS... Read
14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read
13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read
12 June 07 - IBM - IDS 11 release announcement (pdf)... Read
12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read
12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read
12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read
12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read
12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read
12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read
12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read
12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read
12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read
12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read
12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - golem.de - Informix 11 vorgestellt... Read
12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read
12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - Heise - IBM gibt Informix 11 frei... Read
25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read
18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read
18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read
7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read

End of Support Dates
IDS 7.31 - 30 Sep 2009
IDS 9.40 - 30 Apr 2009
IDS 10.00 - 30 Sep 2010
Subscribe to notifications

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Table compression estimate

Posted By: Peter_Logan@spartanstores.com
Date: Tuesday, 7 July 2009, at 8:51 a.m.

In Response To: Re: Table compression estimate (Nilesh Ozarkar)

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.

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.