Re: How to generate Alter Table modify next entent size?

> The table's current next extent size is stored in systables in the > database that 'owns' the table it is the column 'nextsize' or in > sysmaster in the table sysptnhdr as column 'nextsiz' (no 'e'). Both > columns are maintained live so they reflect the latest extent doubling > value. nextsize in systables is ONLY modified when the table is created or an ALTER TABLE is issued. Unless this has changed in the last few months, it's NOT maintained live. systables is used for tracking the schema of a table, not for reporting. I opened case #707799 in February about this when I was trying to use it for reporting purposes. --Chuck Renaud