IDS Forum

RE: Maximum amount number of pages reached

Posted By: John Miller
Date: Thursday, 11 January 2018, at 2:29 p.m.

In Response To: Maximum amount number of pages reached (JORGE GALAN)

=0A=0AI would do a few things,=0A=0A1. Set the onconfig MAX_FILL_DATA_PAGE=
S because you have varchars=0Athis will spend more time finding free spac=
e. You can run an oncheck=0A-pT dbs:table to see how much free space is n=
ow used.=0A=0A2. Because this is pages you can double or more the storage =
space by=0Agoing to a larger page size for this table. =0A=0ADoing a littl=
e math Num Pages Used / Number of Rows =3D 15407009 /=0A1766611 =3D 87 P=
ages/ Row=0A=0ABy moving to a large page size you can reduce the I/O GREATL=
Y beside=0Aallowing more rows. Currently you are doing 44 IO per insert, y=
ou can=0Adrop that to less than 6 by increasing your page size to 16KB=0A=
=0A=0AHope it helps,=0AJohn=0A=0A=0A=0A-------- Original Message --------=
=0ASubject: Maximum amount number of pages reached [40487]=0AFrom: "JORGE G=
ALAN" <jorge.galan@efectivale.com.mx>=0ADate: Thu, January 11, 2018 9:06 am=
=0ATo: ids@iiug.org=0A=0AHello every body? =0A=0AI have reached the limit o=
f pages to table in informix, and my=0Aapplication =0Astops. =0A=0AI unload=
data from the table and so delete it. =0A=0ASo, my application works again=
. =0A=0AI appreciate any help =0A=0Aoncheck output: =0A=0ATBLspace Report f=
or efectivalefe:summalogin.venmovimientosfd =0A=0APhysical Address 3:670195=
8 =0A=0ACreation date 11/21/2017 17:25:28 =0A=0ATBLspace Flags d01 Page Loc=
king =0A=0ATBLspace contains VARCHARS =0A=0ATBLspace contains TBLspace BLOB=
s =0A=0ATBLspace use 4 bit bit-maps =0A=0AMaximum row size 1065 =0A=0ANumbe=
r of special columns 6 =0A=0ANumber of keys 0 =0A=0ANumber of extents 7 =0A=
=0ACurrent serial value 1 =0A=0ACurrent SERIAL8 value 1 =0A=0ACurrent BIGSE=
RIAL value 1 =0A=0ACurrent REFID value 1 =0A=0APagesize (k) 2 =0A=0AFirst e=
xtent size 1024 =0A=0ANext extent size 2097152 =0A=0ANumber of pages alloca=
ted 16220159 <------------------ =0A=0ANumber of pages used 15407009 ><----=
-------------- =0A=0ANumber of data pages 750995 =0A=0ANumber of rows 17666=
11 =0A=0APartition partnum 3155669 =0A=0APartition lockid 3155669 =0A=0A[in=
formix@usatlinfo1 ~]$ onstat - =0A=0AIBM Informix Dynamic Server Version 11=
.70.FC7GE -- On-Line -- Up 169=0Adays =0A04:30:30 -- 2764472 Kbytes =0A=0A=
=0A************************************************************************=
*******=0A=0A Forum Note: Use "Reply" to post a response in the discussion =
forum. =0A=0A>

Messages In This Thread

• Maximum amount number of pages reached
  JORGE GALAN -- Thursday, 11 January 2018, at 12:06 p.m.
  • AW: Maximum amount number of pages reached
    Habichtsberg, Reinhard -- Thursday, 11 January 2018, at 12:37 p.m.
    • RE: Maximum amount number of pages reached
      Alexandre Marini -- Thursday, 11 January 2018, at 1:19 p.m.
  • RE: Maximum amount number of pages reached
    John Miller -- Thursday, 11 January 2018, at 2:29 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.