dbschema server-specific information

The dbschema -ss option generates server-specific information. The -ss option always generates the lock mode, extent sizes, and the dbspace name if the dbspace name is different from the database dbspace. In addition, if tables are fragmented, the -ss option displays information about the fragmentation strategy.

When you specify the dbschema -ss option, the output also displays any GRANT FRAGMENT statements that are issued for a particular user or in the entire schema.

The -si option, which is available only with the -ss option, excludes the generation of index storage clauses for non-fragmented tables.

If the dbspace contains multiple partitions, dbspace partition names appear in the output.

For information about fragment-level authority, see the GRANT FRAGMENT and REVOKE FRAGMENT statements in the IBM® Informix® Guide to SQL: Syntax.