In This Chapter

This chapter provides the instructions on managing effectively the disk spaces and data that the database server controls. It assumes you are familiar with the terms and concepts contained in Data Storage.

You can use the following utilities to manage storage spaces:

• onspaces
• ISA

This chapter covers the following topics:

• Allocating disk space
• Specifying chunk names, and the maximum size and number of chunks and storage spaces
• Backing up after you change the physical schema
• Creating and dropping dbspaces, blobspaces, and sbspaces
• Renaming dbspaces
• Managing dbspace Partitions
• Adding, and dropping chunks from dbspaces, blobspaces, and sbspaces
• Creating and dropping extspaces
• Skipping inaccessible fragments
• Monitoring disk space usage
• Monitoring simple-large-object data and smart-large-object data

Your IBM Informix Dynamic Server Performance Guide also contains information about managing disk space. In particular, it describes how to eliminate interleaved extents, how to reclaim space in an empty extent, and how to improve disk I/O.