Home | Previous Page | Next Page Disk, Memory, and Process Management >

Managing Disk Space

In This Chapter

Allocating Disk Space

Specifying an Offset

Specifying an Offset for the Initial Chunk of Root Dbspace

Specifying an Offset for Additional Chunks

Using Offsets to Create Multiple Chunks

Allocating Cooked File Spaces on UNIX

Allocating Raw Disk Space on UNIX

Creating Symbolic Links to Raw Devices (UNIX)

Allocating NTFS File Space on Windows

Allocating Raw Disk Space on Windows

Specifying Names for Storage Spaces and Chunks

Specifying the Maximum Size of Chunks

Specifying the Maximum Number of Chunks and Storage Spaces

Backing Up After You Change the Physical Schema

Managing Dbspaces

Creating a Dbspace that Uses the Default Page Size

Specifying the First and Next Extent Sizes for the tblspace tblspace

Creating a Dbspace with a Non-Default Page Size

Creating a Buffer Pool for the Non-Default Page Size

Defining the Page Size

Creating a Temporary Dbspace

What to Do If You Run Out of Disk Space

Adding a Chunk to a Dbspace or Blobspace

Adding a Chunk with ON-Monitor (UNIX)

Renaming Dbspaces

Additional Actions You might Need to Take After Renaming a Dbspace

Managing Dbspace Partitions

Managing Blobspaces

Creating a Blobspace

Preparing Blobspaces to Store TEXT and BYTE Data

Determining Blobpage Size

Determining Database Server Page Size

Obtaining Blobspace Storage Statistics

Managing Sbspaces

Creating an Sbspace

Sizing Sbspace Metadata

Adding a Chunk to an Sbspace

Altering Storage Characteristics of Smart Large Objects

Creating a Temporary Sbspace

Dropping a Chunk

Verifying Whether a Chunk Is Empty

Dropping a Chunk from a Dbspace with onspaces

Dropping a Chunk from a Blobspace

Dropping a Chunk from an Sbspace with onspaces

Using the -f (Force) Option

Deleting Smart Large Objects Without any Pointers

Dropping a Storage Space

Preparing to Drop a Storage Space

Dropping a Mirrored Storage Space

Dropping a Storage Space with onspaces

Dropping a Dbspace or Blobspace with ON-Monitor (UNIX)

Backing Up After Dropping a Storage Space

Managing Extspaces

Creating an Extspace

Dropping an Extspace

Skipping Inaccessible Fragments

Using the DATASKIP Configuration Parameter

Using the Dataskip Feature of onspaces

Using onstat to Check Dataskip Status

Using the SQL Statement SET DATASKIP

Effect of the Dataskip Feature on Transactions

Determining When to Use Dataskip

Determining When to Skip Selected Fragments

Determining When to Skip All Fragments

Monitoring Fragmentation Use

Displaying Databases

Using SMI Tables

Using ON-Monitor (UNIX)

Monitoring Disk Usage

Monitoring Chunks

onstat -d update

Using IBM Informix Server Administrator

Using ON-Monitor (UNIX)

Using SMI Tables

Monitoring Tblspaces and Extents

Using SMI Tables

Monitoring Simple Large Objects in a Blobspace

Determining Blobpage Fullness with oncheck -pB

Monitoring Blobspace Usage with oncheck -pe

Monitoring Simple Large Objects in a Dbspace with oncheck -pT

Monitoring Sbspaces

Using onstat -d

Using oncheck -ce and oncheck -pe

Using oncheck -cs

Using oncheck -ps

Monitoring the Metadata and User-Data Areas

Using onstat -g smb c

Loading Data Into a Table

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]