SAP Database Guide: Informix (BC-DB-INF-DBA)

Getting Started with Informix and the SAP System

Checklist: Configuration and Setup

Checklist: Regular Activities

Checklist: Occasional Activities

SAPDBA for Informix

Informix Tools

Computing Center Management System (CCMS)

Informix Dynamic Server

Operating System for the Informix Database

Informix Database Storage Parameters in the ABAP Dictionary

Management of Informix Database Growth

Database Setup for Production

Database Growth Monitoring

Recognition of Space Problems and Errors

Extension of a Dbspace

Extending a Dbspace Without SAPDBA

Creation of a New Dbspace

Data Recovery for Informix

Getting Started with Data Recovery for Informix

Informix Data Recovery

Informix Archive

Informix Whole-System and Storage-Space Backups

Informix Logical-Log Backup

Informix Restore

Comparison of ON-Bar, ON-Archive, and ontape for Data Recovery

ON-Bar for Data Recovery

Configuring ON-Bar

onsmsync with ON-Bar

ON-Bar Activity Log

ON-Archive for Data Recovery

Getting Started with ON-Archive

Entering ON-Archive Commands Manually

Configuration of ON-Archive

SAP Scripts for ON-Archive

Preparing SAP Scripts for ON-Archive

Configuration Files for ON-Archive

Editing the ONCONFIG File for ON-Archive

Editing the oper_deflt.arc File for ON-Archive

Editing the config.arc File for ON-Archive

Defining Devices for ON-Archive with SAP Scripts

Defining Devices for ON-Archive Without SAP Scripts

Volume Sets and Volumes for ON-Archive

Setting Up Volume Sets and Volumes for ON-Archive with SAP Scrip

Setting Up Volume Sets and Volumes for ON-Archive Without SAP Sc

ontape for Data Recovery

Configuring ontape

Database Backup (ON-Bar)

Approach to Database Backup (ON-Bar)

Developing Good Practice for Database Backup (ON-Bar)

Choosing Levels and Frequency of Database Backup (ON-Bar)

Scheduling Backups and Archives with CCMS (ON-Bar and ON-Archive

Requirements for a Database Backup (ON-Bar)

Setting Up Storage Media for Database Backup (ON-Bar)

Creation of a Database Backup (ON-Bar)

Performing a Manual Database Backup (ON-Bar)

Checking Database Backup Status and Result with Activity Log (ON

Checking Result of Database Backup or Archive with Message Log

Completing a Database Backup (ON-Bar)

Archive (ON-Archive and ontape)

Approach to Archive (ON-Archive)

Developing Good Practice for Archive (ON-Archive and ontape)

Choosing Archive Levels and Frequency (ON-Archive and ontape)

Scheduling Backups and Archives with CCMS (ON-Bar and ON-Archive

Using the SAPDBA Recovery Report with Archives and Logical-Log B

Using Parallel Archive (ON-Archive)

Requirements for an Archive (ON-Archive)

Setting Up Storage Devices for Archive (ON-Archive)

Setting Up Volume Sets and Volumes for Archive (ON-Archive)

Setting Up Tape Volumes for Archive (ON-Archive and ontape)

Setting Up Parallel Archive (ON-Archive)

Setting Up Unattended Archive (ON-Archive)

Creation of an Archive (ON-Archive)

Determining the Volume Required (ON-Archive)

Performing an Archive (ON-Archive)

Checking Archive Status (ON-Archive)

Checking Archive Result with Activity Log (ON-Archive)

Checking Result of Database Backup or Archive with Message Log

Checking Tapes After an Archive (ON-Archive and ontape)

Completing an Archive (ON-Archive)

Approach to Archive (ontape)

Developing Good Practice for Archive (ON-Archive and ontape)

Choosing Archive Levels and Frequency (ON-Archive and ontape)

Requirements for an Archive (ontape)

Setting Up Tape Volumes for Archive (ON-Archive and ontape)

Creation of an Archive (ontape)

Performing an Archive (ontape)

Checking Result of Database Backup or Archive with Message Log

Checking Tapes After an Archive (ON-Archive and ontape)

Logical-Log Backup

Approach to Logical-Log Backup (ON-Bar)

Developing Good Practice for Logical-Log Backup

Choosing Continuous or Manual Logical-Log Backup (ON-Bar)

Scheduling Backups and Archives with CCMS (ON-Bar and ON-Archive

Requirements for a Logical-Log Backup (ON-Bar)

Setting Up Storage Devices for Logical-Log Backup (ON-Bar)

Setting Parameters for Logical-Log Backup (ON-Bar)

Creation of a Logical-Log Backup (ON-Bar)

Performing a Continuous Logical-Log Backup (ON-Bar)

Performing a Manual Logical-Log Backup (ON-Bar)

Checking Logical-Log Backup Result with Activity Log (ON-Bar)

Checking Logical-Log Backup Result with Message Log

Completing Logical-Log Backup (ON-Bar)

Approach to Logical-Log Backup (ON-Archive)

Developing Good Practice for Logical-Log Backup

Choosing Automatic Logical-Log Backup (ON-Archive)

Choosing Continuous Logical-Log Backup (ON-Archive)

Scheduling Backups and Archives with CCMS (ON-Bar and ON-Archive

Using the SAPDBA Recovery Report with Archives and Logical-Log B

Requirements for a Logical-Log Backup (ON-Archive)

Setting Up Storage Devices for Logical-Log Backup (ON-Archive)

Setting Up Volume Sets and Volumes for Logical-Log Backup (ON-Ar

Meeting Additional Logical-Log Backup Requirements (ON-Archive)

Creation of a Logical-Log Backup (ON-Archive)

Performing Automatic Logical-Log Backup (ON-Archive)

Performing Continuous Logical-Log Backup to Tape (ON-Archive)

Performing Continuous Logical-Log Backup to Disk (ON-Archive)

Checking Logical-Log Backup Status (ON-Archive)

Checking Logical-Log Backup Result with Activity Log (ON-Archive

Checking Logical-Log Backup Result with Message Log

Checking Tapes After a Logical-Log Backup (ON-Archive and ontape

Completing Logical-Log Backup (ON-Archive)

Approach to Logical-Log Backup (ontape)

Developing Good Practice for Logical-Log Backup

Choosing Automatic or Continuous Logical-Log Backup (ontape)

Requirements for a Logical-Log Backup (ontape)

Setting Up Tape Devices for Logical-Log Backup (ontape)

Creation of a Logical-Log Backup (ontape)

Performing an Automatic Logical-Log Backup (ontape)

Performing a Continuous Logical-Log Backup (ontape)

Checking Logical-Log Backup Result with Message Log

Checking Tapes After a Logical-Log Backup (ON-Archive and ontape

Completing Logical-Log Backup (ontape)

Emergency Logical-Log Backup

Performing Emergency Logical-Log Backup (ON-Bar)

Emergency Logical-Log Backup Using SAP Scripts (ON-Archive)

Preparing for Emergency Logical-Log Backup Using SAP Scripts (ON

Performing Emergency Logical-Log Backup Using SAP Scripts (ON-Ar

Checking Result of Emergency Logical-Log Backup with Activity Lo

Emergency Logical-Log Backup Without SAP Scripts (ON-Archive)

Backing up Logical-Log Files Using ondatartr (ON-A

Checking Result of Emergency Logical-Log Backup with Activity Lo

Cataloging the Emergency Save Set (ON-Archive)

Copying Backed-Up Logs to Regular Volume Set (ON-A

Copying Emergency Save Set to Regular Volume Set (

Deleting the Emergency Save Set (ON-Archive)

Performing Emergency Logical-Log Backup (ontape)

Preventing Emergency Logical-Log Backup

Restore

Getting Started with Restore

Identifying the Problem Requiring a Restore

Choosing the Correct Kind of Restore

Preparing for a Restore with the SAPDBA Recovery R

Full-System Cold Restore (ON-Bar)

Preparing for a Full-System Cold Restore (ON-Bar)

Salvaging Logical Logs for a Full-System Cold Restore (ON-Bar)

Performing Physical Restore for a Full-System Cold

Performing Logical Restore for a Full-System Cold

Partial-System Warm Restore (ON-Bar)

Preparing for a Partial-System Warm Restore (ON-Ba

Performing Physical Restore for a Partial-System W

Performing Logical Restore for a Partial-System Wa

Full-System Cold Restore (ON-Archive)

Preparing for a Full-System Cold Restore (ON-Archi

Salvaging Logical Logs for a Full-System Cold Rest

Performing Physical Restore for a Full-System Cold

Performing Logical Restore for a Full-System Cold Restore (ON-Ar

Partial-System Warm Restore (ON-Archive)

Preparing for a Partial-System Warm Restore (ON-Ar

Performing Physical Restore for a Partial-System W

Performing Logical Restore for a Partial-System Wa

Full-System Cold Restore (ontape)

Preparing for a Full-System Cold Restore (ontape)

Performing a Full-System Cold Restore (ontape)

Partial-System Warm Restore (ontape)

Preparing for a Partial-System Warm Restore (ontap

Performing a Partial-System Warm Restore (ontape)

Recovery of a Lost Mirrored Chunk

Identifying a Lost Mirrored Chunk

Creating a New Link for a Lost Mirrored Chunk

Recovering a Lost Mirrored Chunk Online

SAPDBA for Informix

Getting Started with SAPDBA

SAPDBA Setup

Setting Up SAPDBA Users

Setting Up SAPDBA Environment Variables

Setting Up SAPDBA Screen Handling

Setting Up SAPDBA Working Directories

Starting SAPDBA

SAPDBA Heading Lines

Use of SAPDBA with UNIX and NT

Printing a SAPDBA Report

SAPDBA Housekeeping

SAPDBA Files, Directories, and Reports

Server Mode with SAPDBA

Changing Server Mode with SAPDBA

Dbspaces with SAPDBA

Listing Chunks with SAPDBA

Listing Dbspaces with SAPDBA

Listing Devices with SAPDBA

Listing Chunk Paths with SAPDBA

Adding a Chunk with SAPDBA

Dropping a Chunk with SAPDBA

Adding a Dbspace with SAPDBA

Dropping a Dbspace with SAPDBA

Renaming Chunk Paths with SAPDBA

Reorganization with SAPDBA

Storage Analysis of Tables and Indexes with SAPDBA

Analyzing Tables by Fill Level, Size, and Extents

Analyzing Table Information with SAPDBA

Analyzing Tables for Critical Next Extent Size with SAPDBA

Analyzing Indexes by Fill Level, Leaves, and Level

Analyzing Indexes of a Table with SAPDBA

Analyzing Index Information with SAPDBA

Analyzing a Tablespace with SAPDBA

Reorganization of Tables, Indexes, and Dbspaces wi

Reorganizing a Single Index with SAPDBA

Reorganizing All Indexes of One Table with SADPBA

Preparing for Table or Dbspace Reorganization with SAPDBA

Reorganizing a Single Table with SAPDBA

Reorganization of a Group of Tables or Dbspace wit

Reorganizing a Group of Tables with SAPDBA

Input File for Reorganizing Groups of Tables with SAPDBA

Reorganizing a Dbspace and Its Tables with SAPDBA

Reorganization Troubleshooting with SAPDBA

Reorganization Log with SAPDBA

Fixing Difficult Reorganization Problems with SAPDBA

Restarting Uncompleted Reorganization Requests with SAPDBA

Deleting Uncompleted Reorganization Requests with SAPDBA

Finishing a Table or Dbspace Reorganization with S

Data Consistency with SAPDBA

How to Run Data Consistency Checks with SAPDBA

Checking a Single Table for Data Consistency with SAPDBA

Checking Tables of a Dbspace for Data Consistency with SAPDBA

Checking Tables with Blob Fields for Data Consistency with SAPDB

Checking All Tables of R/3 Database for Data Consistency with SA

Checking Indexes of Tables with ‘Blob’ Fields Using ONCHECK -cI

Checking Tables with ‘Blob’ Fields Using ONCHECK -cD with SAPDBA

Deleting Uncompleted Consistency Requests with SAP

Restarting Uncompleted Consistency Requests with S

Log for Data Consistency with SAPDBA

Update Statistics with SAPDBA

How SAPDBA Performs Update Statistics

Listing Tables with Deviation with SAPDBA

Listing Tables with Non-Updated Indexes with SAPDB

Listing Update Statistics Log File with SAPDBA

Updating Statistics for One Table with SAPDBA

Updating Statistics for All Tables with SAPDBA

Updating Statistics for All System Tables with SAPDBA

Updating Statistics from the Command Line with SAPDBA

Customizing Update Statistics with SAPDBA

Log Table for Update Statistics with SAPDBA

Logging Mode with SAPDBA

Switching to "No Logging Mode" with SAPDBA

Switching to "Unbuffered Logging Mode" with SAPDBA

Recovery Report with SAPDBA

Preparing for Recovery Reports with SAPDBA

Listing Recovery Report with SAPDBA

Creation of Recovery Report with SAPDBA (Informix

Preparing for Recovery Reports with SAPDBA (Inform

Creating the Recovery Report with SAPDBA (Informix

DB System Checks with SAPDBA

Checking the DB System with SAPDBA

System Information with SAPDBA

Listing System Information with SAPDBA

Emergency Logical-Log Backup with SAPDBA (Informix

Preparing for Emergency Logical-Log Backup with SA

Performing Emergency Logical-Log Backup with SAPDB

Solutions for Top Informix Problems

Solving Database Startup Problems

Solving Problems with 32-Bit SAPDBA Access to 64-Bit Software

Solving Problems with Memory Allocation on HP-UX

Solving Problems with Corruption

Solving Assert Problems

Solving Error Message INF-271 Without ISAM Error Code

Solving Performance Problems with a SELECT Statement

Solving Problems with Out-of-Date Optimizer Access Paths

Solving Problems with In-Place Alter Table

Examples for In-Place Alter Table