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

Managing Disk Space

In This Chapter

Initializing Disk Space

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 a File for Disk Space on UNIX

Allocating Raw Disk Space on UNIX

Configuring Disk Space for Multiple Coservers

Creating Standard Device Names

Setting Up Disk Access Across Nodes

Backing Up After You Change the Physical Schema

Creating a Dbspace

Specifying Pathnames for Dbspaces

Specifying Names and Maximum Number of Storage Spaces

Backing Up the New Dbspace

Creating a Temporary Dbspace

Creating a Dbspace with onutil

Creating Dbslices

Naming Dbslices

Increasing the Number of Dbslices

Backing Up the New Dbslice

Altering a Dbslice

Increasing the Maximum Number of Dbspaces, Chunks, or Dbslices

Recovering from Errors

Adding a Chunk to a Dbspace

Backing Up the New Chunk

Naming Chunks and Storage Spaces

Limiting Chunk Size and Number

Adding a Chunk with onutil

Loading Data Into a Table

Changing the Status of a dbspace

Toggling Between Read-Only and Operational Mode

Toggling Between Online and Offline Mode

Dropping a Chunk

Verifying Whether a Chunk Is Empty

Dropping a Chunk from a Dbspace with onutil

Dropping a Storage Space

Preparing to Drop a Storage Space

Backing Up After Dropping a Storage Space

Dropping a Mirrored Storage Space

Dropping a Dbspace with onutil

Dropping Dbslices

Skipping Inaccessible Fragments

Using the DATASKIP Configuration Parameter

Using onutil to modify DATASKIP

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

Monitoring the Database Server for Disabling I/O Errors

Using the Message Log to Monitor Disabling I/O Errors

Using Event Alarms to Monitor Disabling I/O Errors

Monitoring Disk Usage

Monitoring Chunks

Using Command-Line Utilities

Using SMI Tables

Monitoring Tblspaces and Extents

Using Command-Line Utilities

Using SMI Tables

Using System Catalog Tables

Monitoring Simple Large Objects in a Dbspace

No Compression of TEXT and BYTE Data Types

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