Server-Specific Information

The -ss option generates server-specific information. In all Informix database servers except SE, 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 -x option expands dbslice names into dbspace name lists in -ss output.

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.