IDS Forum

Re: Oncheck interpretation problems

Posted By: Clifford Burton
Date: Saturday, 21 April 2012, at 3:30 a.m.

In Response To: Oncheck interpretation problems (RAPHAëL GODART)

16777215 is the maximum pages for a fragment...
Earlier today a number of options were shown for someone encountering the
same limitation.
On Apr 21, 2012 5:26 PM, "RAPHAëL GODART" <raf.godart@gmail.com> wrote:

> Hi,
>
> I inherited a Informix 11.10 IDS and I'm trying to understand the
> configuration. I'm worried about one table and ran an oncheck on it.
>
> The numer of pages used is identical to the number of pages allocated. Is
> the
> table full? (Last week we couldn't insert more data without deleting older
> rows, although I would assume an extent should just be added when the first
> extent is full, as the dbspace has 300GB free).
>
> What about the extent below in the report? It seems unused.
>
> TBLspace Report for abba:abba.logbuch
>
> Physical Address 3:5
>
> Creation date 11/25/2009 13:50:39
>
> TBLspace Flags 902 Row Locking
>
> TBLspace contains VARCHARS
>
> TBLspace use 4 bit bit-maps
>
> Maximum row size 240
>
> Number of special columns 3
>
> Number of keys 5
>
> Number of extents 1
>
> Current serial value 245314179
>
> Current SERIAL8 value 1
>
> Current REFID value 1
>
> Pagesize (k) 2
>
> First extent size 16777215
>
> Next extent size 4404000
>
> Number of pages allocated 16777215
>
> Number of pages used 16777215
>
> Number of data pages 8139695
>
> Number of rows 144052679
>
> Partition partnum 3145730
>
> Partition lockid 3145730
>
> Extents
>
> Logical Page Physical Page Size Physical Pages
>
> 0 3:61368525 16777215 16777215
>
> Index 464_2119 fragment partition dynabbadbs in DBspace dynabbadbs
>
> Physical Address 3:16
>
> Creation date 11/25/2009 13:50:51
>
> TBLspace Flags 802 Row Locking
>
> TBLspace use 4 bit bit-maps
>
> Maximum row size 240
>
> Number of special columns 0
>
> Number of keys 1
>
> Number of extents 2
>
> Current serial value 1
>
> Current SERIAL8 value 1
>
> Current REFID value 1
>
> Pagesize (k) 2
>
> First extent size 908765
>
> Next extent size 238550
>
> Number of pages allocated 1385865
>
> Number of pages used 1241519
>
> Number of data pages 0
>
> Number of rows 0
>
> Partition partnum 3145741
>
> Partition lockid 3145730
>
> Extents
>
> Logical Page Physical Page Size Physical Pages
>
> 0 3:78145740 908765 908765
>
> 908765 3:91268473 477100 477100
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--0016368e1d5b856d3804be2b610a

Messages In This Thread

• Oncheck interpretation problems
  RAPHAëL GODART -- Saturday, 21 April 2012, at 3:25 a.m.
  • Re: Oncheck interpretation problems
    Clifford Burton -- Saturday, 21 April 2012, at 3:30 a.m.
    • Re: Oncheck interpretation problems
      RAPHAëL GODART -- Saturday, 21 April 2012, at 5:01 a.m.
      • Re: Oncheck interpretation problems
        Art Kagel -- Saturday, 21 April 2012, at 11:55 p.m.
        • Re: Oncheck interpretation problems
          RAPHAëL GODART -- Sunday, 22 April 2012, at 1:03 p.m.
          • Re: Oncheck interpretation problems
            Art Kagel -- Sunday, 22 April 2012, at 4:39 p.m.
  • Re: Oncheck interpretation problems
    Art Kagel -- Saturday, 21 April 2012, at 11:49 p.m.
    • Re: Oncheck interpretation problems
      FRANK J. COMPUTER -- Monday, 7 May 2012, at 3:26 a.m.
      • Re: Oncheck interpretation problems
        FRANK J. COMPUTER -- Monday, 7 May 2012, at 5:02 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.