The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

System Administration Certification exam 919 for Informix 11.70 prep, Part 2: Informix space management

Edgar Sanchez (edgarsan@us.ibm.com), Advanced Support Engineer, IBM

Edgar D. Sanchez is a software engineer from the IBM Latin American Support Call Center in Coral Gables, FL with more than 20 years of experience. He works primarily as a database support engineer with both IBM Informix Dynamic Server and DB2. He also worked as a premium support engineer, regional advanced support, and educator (trainer) for RDBMS customers.

Carolina Leme (caroleme@us.ibm.com), Technical Support Engineer, IBM

Carolina Leme is a technical support engineer for IBM Informix. She has been in this position supporting Informix since 2006 has worked on porting the IBM Informix product on various platforms. At IBM, Carolina has provided IBM Informix database support for Informix users for versions 7, 9, 10, 11.50 and 11.70.

Summary: In this tutorial, you'll learn how to configure and manage storage spaces on IBM Informix® database, the utilities to create those storage spaces, and how to use fragmentation and features to optimize the storage in the database. This tutorial prepares you for Part 2 of the System Administration Certification exam 919 for Informix v11.70.

View more content in this series

Date: 10 May 2012
Level: Intermediate
PDF: A4 and Letter (726 KB | 60 pages)Get Adobe® Reader®

Activity: 16777 views
Comments:

Before you start

About this series

Thinking about seeking certification on System Administration for IBM Informix version 11.70 (Exam 919)? If so, you've landed in the right spot to get started. This series of IBM Informix certification preparation tutorials covers all the topics you'll need to understand before you read that first exam question. Even if you're not seeking certification right away, this set of tutorials is a great place to start learning what's new in IBM Informix 11.70.

About this tutorial

In this tutorial, you'll learn about how to use the IBM Informix tools to create dbspaces, sbspaces, and temporal dbspaces. You'll learn to create and manage table fragmentation and to use storage-optimization features, such as compression. The material provided here primarily covers the objectives in Section 2 of the exam, entitled Space Management.

Objectives

After completing this tutorial, you should be able to:

Create dbspaces and sbspaces
Add chunks to a dbspace or sbspace
Rename dbspaces
Mirror a dbspace or sbspace in chunks
Use table fragmentation
Use attach or detach to add or remove fragments to a fragmented table
Use data compression to optimize storage

Prerequisites

To understand the material presented in this tutorial, you must be familiar with the following:

The IBM Informix environment (configuration file and parameters, installation, and administration)
Database server commands (onstat, onmode, oncheck, dbschema)
IBM Informix concepts and terminology (dbspaces, chunks, physical log, logical logs, checkpoint, and so on)

System requirements

You do not need a copy of IBM Informix to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of Informix Innovator-C Edition (see Resources) to work along with this tutorial.

Comments