Re-create a Table with the Same Parameters as the Original
As mentioned above, the Informix dbschema program has some noted limitations. While it will create all of the SQL statements necessary to rebuild the table in its most basic form, some very valuable information is lost. This is the information regarding the extent sizes and the locking mode of the table.
As the DBA continues to tune the database, it becomes very important to keep the tables within the minimum number of extents. It is often necessary to adjust the extent sizes of a table to make sure that it uses its space most effectively and to make sure that its access speed is maximized. When rebuilding the table, much accumulated tuning work would be lost if the latest EXTENT SIZE ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
