Page count and extent count limits

Hello all, Thank you for all your help on my recent questions. I got exactly what I needed in the end thanks to all your help :) I am now looking into writing a stored procedure to check page limits. We had a customer’s production database crash when one of the fragmented tables' fragments page count hit the page limit. IDS apparently has a page limit of 16,777,215 pages per 'table fragment'/'table (no fragments)'. Is this correct and what else does this limit apply to? Can anyone provide any advice on how I can query sysmaster etc, to find page counts for tables/table fragments etc which are getting close to this limit? Secondly, What is the maximum number of extents per table supported by IDS? I have this so far; Max_Extents_For_A_Table <= (table pagesize - ((4 * number of columns in a table) + (8 * number of BLOB and VARCHAR columns + 136) + (12 * number of indices) + (4 * number of columns in the indices) + 84)) Is there a more elegant or simple way of changing the 'extent' and 'next extent' declarations for a table and apply those new sizes without having to create a copy of the new table, copy the data across from original to new, drop the original table, and finally rename the new table to the original tables name? Are there any other limits that we should be warned of? Our customer databases are starting to grow quite considerably and as such we are feeling a learning curve for managing very large IDS databases. Thank you very much for your kind help and advice. Regards, Andy.