International Informix Users Group

	Informix News

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 Previous news items

Home Member Area About IIUG

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

Informix Forum

Re: SQLCODE: -271 ISAM: -136 errors.

Posted By: ART KAGEL, BLOOMBERG/ 731 LEXIN
Date: Wednesday, 15 March 2006, at 11:24 a.m.

In Response To: SQLCODE: -271 ISAM: -136 errors. (NIGEL THORNE)

The maximum number of pages in a partition (a table/index fragment or
unfragmented table/index) is 16777216 (2^24). You have to fragment the table
into two or more fragments to allow it to continue to grow.
Art S. Kagel
----- Original Message -----
From: Nigel Thorne <informix-forum@iiug.org>
At: 3/15 11:00
Hi,
I have expereinced the following errors when adding new data to my table of
approx 150 m rows.
SQLCODE: -271 ISAM: -136
-271 Could not insert new row into the table.
-136 ISAM error: no more extents.
We seem to have plenty of extents available as we have only used 35 as per the
oncheck below (not worked out theoretical limit but 35 is well below the ~220
IMO):
oncheck -pt snss_live:sc_manitem
TBLspace Report for snss_live:snssadmn.sc_manitem
Physical Address 5:1038285
Creation date 08/21/2000 21:49:45
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 122
Number of special columns 0
Number of keys 4
Number of extents 35
Current serial value 146285814
First extent size 1024000
Next extent size 1024000
Number of pages allocated 16777215
Number of pages used 16777215
Number of data pages 9055807
Number of rows 144892910
Partition partnum 5243008
Partition lockid 5243008
Extents
Logical Page Physical Page Size
0 5:1607 1024000
1024000 42:3 1024000
2048000 43:3 1024000
3072000 44:3 256000
3328000 44:321539 256000
3584000 44:643075 256000
3840000 45:3 1024000
4864000 46:3 256000
5120000 46:321539 512000
5632000 47:3 768000
6400000 48:3 1024000
7424000 49:3 768000
8192000 50:3 1024000
9216000 51:3 768000
9984000 52:3 1024000
11008000 53:3 768000
11776000 54:3 1024000
12800000 55:3 1024000
13824000 45:1024003 24572
13848572 48:1024003 24572
13873144 52:1024003 24572
13897716 54:1024003 24572
13922288 55:1024003 24572
13946860 44:1030147 18428
13965288 46:1030147 18428
13983716 47:1030147 18428
14002144 49:1030147 18428
14020572 51:1030147 18428
14039000 42:1034243 14332
14053332 41:1048382 193
14053525 41:1045644 186
14053711 82:3 512000
14565711 83:3 1024000
15589711 84:3 1024000
16613711 82:855291 163504
There is more than 4Gb worth of chunk space free for that dbspace currently (2
x 2Gb chunks). I haven't been able to find anything relevant on the forum
pertaining to this before but does anyone know why we get the errors stated
and how easiest to resolve this?
We are running Informix 9.40 HC4.
Thanks,
Nigel
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

SQLCODE: -271 ISAM: -136 errors.
NIGEL THORNE -- Wednesday, 15 March 2006, at 8:37 a.m.
- Re: SQLCODE: -271 ISAM: -136 errors.
  ART KAGEL, BLOOMBERG/ 731 LEXIN -- Wednesday, 15 March 2006, at 11:24 a.m.
  - Re: SQLCODE: -271 ISAM: -136 errors.
    NIGEL THORNE -- Wednesday, 15 March 2006, at 11:53 a.m.

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

Informix Forum is maintained by Administrator with WebBBS 5.12.