IDS Forum

RE: Urgent:Error No. 136

Posted By:
Date:

Hi,

what Wayne mentions is the correct limit for
number of data pages in a fragment.
If you hit this limit, and you still want your table
to grow, then you have to fragment your table.

Also see these files for this and other documented
limits :

$INFORMIXDIR/release/en_us/0333/SERVERS_7.*
or
$INFORMIXDIR/release/en_us/0333/ids_release_notes.html

if your version has this HTML file and you like reading
it in HTML format more than reading normal text (the
content is the same).

Release Notes ... always worth a try ! :)

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich
Data Management Solutions





"Zablatzky, ...." <wzablatz@ubspw.com>
Sent by: forum.subscriber@iiug.org
14.05.2003 03:54


To: ids@iiug.org
cc:
Subject: RE: Urgent:Error No. 136 [1134]




Vineet,

YES, you did hit a max table size (on 32 bit O/S). Doing an oncheck -pt
will
shows this. If you altered table, i.e. increased row size, you can have
multiple versions of the table.
Solutions:
* Unload/reload table to reclaim (possibly) space
* Delete (archive) records
* Fragment table. NOTE: Each table space will have the 16,777,215
limit.

FYI: 16777215 = FFFFFF hex = internal limit...

Good luck,
Wayne


-----Original Message-----
From: Vineet Mehr.... [mailto:vin_us@yahoo.com]
Sent: Tuesday, May 13, 2003 9:11 PM
To: ids@iiug.org
Subject: Urgent:Error No. 136 [1132]


Environment: Informix Dynamic Server 7.31UD2R1
on HP-UX 11.0

Table definition :

create table "informix".optpgtrx_t
(
n_objid integer,
n_objpg integer,
n_pg_version integer,
n_objabspg integer,
n_clstrid integer,
u_objpg byte in cams60_22,
u_objpg_scnd byte in infx60_03
) in optdbs01 extent size 31457280 next size
10485760 lock mode row;
revoke all on "informix".optpgtrx_t from "public";

create unique index "informix".optpgtrxn_x01 on
"informix".optpgtrx_t
(n_objid,n_objpg,n_pg_version desc);
create index "informix".optpgtrxn_x02 on
"informix".optpgtrx_t
(n_clstrid,n_objid,n_objpg);


Table statistics:
npages--16777215
nused--16777215
ndata- 12749689
nrows-178495641
nextns-17

The dbspace optdbs01 in which the table resides has
around 8GB free space available.
Here is the output from onmonitor for optdbs01
DBspace has total of 20971500 pages, 4194175 of which
are free

Are we hitting some kind of bug in informix for
maximum number of pages in a tablespace.

What could be the possible solution for this kind of
problem.

Thanks,

Vineet








__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

Messages In This Thread

• Urgent:Error No. 136
  Vineet Mehrotra -- Tuesday, 13 May 2003, at 9:11 p.m.
  • RE: Urgent:Error No. 136
    Zablatzky, Wayne -- Tuesday, 13 May 2003, at 9:54 p.m.
    • RE: Urgent:Error No. 136
      Martin Fuerderer -- Wednesday, 14 May 2003, at 3:41 a.m.
  • Re: Urgent:Error No. 136
    Vineet Mehrotra -- Wednesday, 14 May 2003, at 4:00 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.