Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
Administrator's GuideThe Informix® Administrator's Guide provides the information required to administer HCL Informix®.
Disk, memory, and process management
Manage disk spaceYou can use several utilities and tools to manage disk spaces and the data that the database server controls.
Skip inaccessible fragments
Determine when to use dataskip
Determine when to skip selected fragments

Determine when to skip selected fragments

In certain circumstances, you might want the database server to skip some fragments, but not others. This usually occurs in the following situations:

Fragments can be skipped because they do not contribute significantly to a query result.
Certain fragments are down, and you decide that skipping these fragments and returning a limited amount of data is preferable to canceling a query.

When you want to skip fragments, use the ON dbspace-list setting to specify a list of dbspaces with the fragments that the database server must skip.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.