Home | Previous Page | Next Page

Contents

In This Introduction

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

New Features in Database Servers

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set

Compliance with Industry Standards

IBM Welcomes Your Comments

Overview of IBM Informix Migration

Database Server Migration

In This Chapter

IBM Informix Database Server Products

Migration on the Same Operating System

Source and Target Database Servers on UNIX

Source and Target Database Servers on Linux

Source and Target Database Server on Windows XP

Source and Target Database Servers on Windows NT

Source and Target Database Servers on Windows 2000

Source and Target Database Servers on Windows 95

Migration on Different Operating Systems

Database Server Migration Paths

In This Chapter

Migrating a Database or Selected Data

Migrating Between Different Versions of a Database Server

Changing Database Servers, Operating Systems, or GLS Locales

Distributing a Client Application

Importing Non-IBM Informix Data

Setting Environment Variables Before Using Utilities

Choosing Data-Migration Tools

Automatic Data Migration

The onunload and onload Utilities

The dbexport and dbimport Utilities

LOAD, UNLOAD, and dbload

The dbschema Utility

External Tables

The High-Performance Loader

Nonlogging Raw Tables (IDS 9.x or Later)

Movement of TEXT and BYTE Data

Moving Data Between Computers and Dbspaces

Importing Data from a Non-IBM Informix Source

Importing Data with IBM Informix Enterprise Gateway Products

Migration to a Later Version of a Database Server

Preparing for Migration

In This Chapter

Preparing for Migration

Diagnostic Information That You Need Before Upgrading

Migration Guidelines

Changes in Dynamic Server 10.0, 9.40, 9.30, and 9.2x

Storage-Manager Validation and Installation

Migrating Between 32-bit and 64-Bit Database Servers

Migrating to Dynamic Server 10.0 with Enterprise Replication

In This Chapter

Converting to Dynamic Server 10.0 with Enterprise Replication

Converting Replication of 9.2x User-Defined Data Types

Reverting from Dynamic Server 10.0 with Enterprise Replication

Converting to Dynamic Server 10.0

In This Chapter

Converting to Version 10.0

Summary of Conversion Steps

Check and Configure Available Space

Save Copies of the Current Configuration Files

Close All Transactions and Shut Down the Source Database Server

Check for Any Open Transactions

Verify the Integrity of the Data

Verify the Database Server Mode

Disable High-Availability Data Replication

Make a Final Backup of the Source Database Server

Verify That the Source Database Server Is Offline

On UNIX or Linux, Modify Kernel Parameters

Install Dynamic Server 10.0

Set Environment Variables

Customize Configuration Files

Add Any Communications Support Modules (UNIX/Linux)

Install and Configure Any DataBlade Modules

Initialize Dynamic Server 10.0

Monitor the Conversion Complete Status

Upgrade the High-Performance Loader onpload Database

For ON-Bar, Rename the sm_versions.std File

Update Statistics

Verify the Integrity of the Data

Make an Initial Backup of Dynamic Server 10.0

Tune Dynamic Server 10.0 for Performance

Reverting from Dynamic Server 10.0

In This Chapter

Reverting from Dynamic Server 10.0 to Versions 9.40, 9.30, 9.2x, 7.3x, or 7.24

Determine Whether Reversion Is Possible

Recompile Java UDRs That Have Been Compiled Using JDK 1.4.x

Revert an onpload Database to the Previous Version

Check and Configure Available Space

Save Copies of the Current Configuration Files (UNIX/Linux)

Verify the Integrity of the Data

Back Up Dynamic Server 10.0

Remove BladeManager Extensions

Remove Version 10.0 Features

Run the Reversion Utility

Modify Configuration Parameters

Reset Environment Variables

Remove Any Communications Support Module Settings (UNIX/Linux)

Reinstall and Start the Target Database Server

Update Statistics

Verify the Integrity of the Data

Back Up the Target Database Server

Return the Target Database Server to Online Mode

Migration of Data Between Database Servers

Migrating Between Database Servers and Operating Systems

In This Chapter

Choosing a Migration Method

Adjusting Database Tables for File-System Variations

Moving Data to a Database Server on a Different Operating System

Using the Migration Utilities

Adapting Your Programs for UNIX or Windows

Completing Migration

Moving Data Between Dynamic Server and Workgroup Edition on Different Operating Systems

Data Migration Utilities

The dbexport and dbimport Utilities

In This Chapter

Syntax of the dbexport Command

Termination of dbexport

Server-Specific Information

Destination Options

Contents of the Schema File

Syntax of the dbimport Command

Termination of dbimport

Errors and Warnings

Input-File Location Options

Database-Logging Mode

Database Renaming

Simple Large Objects (IDS 9.x or Later)

Database Locale Changes

The dbload Utility

In This Chapter

Syntax of the dbload Command

Guidelines for Using dbload

Command File for dbload

FILE and INSERT Statements: Delimiter Form

FILE and INSERT Statements: Character-Position Form

Command File to Load Complex Data Types (IDS 9.x or Later)

Using dbload with Named Row Types

Using dbload with Unnamed Row Types

Using dbload with Collection Data Types

Using dbload with Other Data Types

The dbschema Utility

In This Chapter

Syntax of the dbschema Command

Database Schema Creation

Server-Specific Information

User-Defined and Complex Data Types (IDS 9.x or Later)

Sequence Creation

Synonym Creation

Granting Privileges

Displaying Privilege Information for a Role

Table, View, or Procedure Creation

Table Information

Distribution Information for Tables

Distribution Description

Distribution Information

Overflow Information

DB-Access Input from dbschema Output

Inserting a Table into a Database Example

Re-Creating the Schema of a Database

The LOAD and UNLOAD Statements

In This Chapter

Syntax of the UNLOAD Statement

Syntax of the LOAD Statement

Using Load and Unload Statements for Locales That Support Multibyte Code Sets

The onmode Utility

In This Chapter

Use of the onmode -b Command for Reversion

Preparation for Reversion

Syntax of the onmode -b Command

The onunload and onload Utilities

In This Chapter

How onunload and onload Work

Syntax of the onunload Command

Destination Parameters

Constraints That Affect onunload

Database or Table Unloading

Locking During Unload Operation

Syntax of the onload Command

Source Parameters

Constraints That Affect onload

Constraints That Affect onload and onunload

Restrictions That Affect onload and onunload

Logging During Loading

Movement of Simple Large Objects to a Blobspace

Ownership and Privileges

Exclusive Locking During Load Operation

Steps for Using onunload and onload

Appendix. Accessibility

Dotted Decimal Syntax Diagrams

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