Extent size in system tables?

Posted in 1999

Xin Zhou — Sun, 25 Jul 1999 12:49:59 -0400 — source: Informix-list mailing list archive (1991-1998)

Can anybody tell me what the difference between fextsize and nextsize in systables and ti_fextsiz and ti_nextsize in sysmaster:systabinfo? Thanks! Sims

↪ replying to Xin Zhou

Art S. Kagel — Mon, 26 Jul 1999 14:29:47 -0400 — source: Informix-list mailing list archive (1991-1998)

Xin Zhou wrote: > > Can anybody tell me what the difference between fextsize and nextsize in > systables and ti_fextsiz and ti_nextsize in sysmaster:systabinfo? Difference how? If you mean between the database catalog table, systables, values and the SMI table, systabinfo, table then nothing. It is just that the system catalog tables in a particular database only describe tables in that database while the SMI tables describe all databases. If you mean difference between fextsize/ti_fextsize and nextsize/ti_nextsize then the former pair describe the first extent of a table while the latter pair the initial size of any additional extents added to the table over time. Art S. Kagel