Re: extents on online 5.0

Posted in 1996

Bill Ennis — 20 May 1996 14:18:20 -0400 — source: Informix-list mailing list archive (1991-1998)

SQL: select tabname, fextsize, nextsize from systables where tabid >= 100 and tabtype = "T" note: This will only show the current setting of the next extent size which can be updated via SQL or by the database itself in an effort to reduce extent allocations. -Bill > Besides using the tbcheck program how is it > possible to get the table extents. > > Is it possible to use SQL or a 4gl program? > > Thanks, > > Ronald A. Huizar > rhuizar@dcci.com > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com