| BC R/3 Database Guide: Informix |
| Getting Started with Informix and R/3 |
| 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 |
| 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 |
| What is Data Recovery? |
| What is an Archive? |
| What are Whole-System and Storage-Space Backups? |
| What is a Logical-Log Backup? |
| What is a Restore? |
| Comparison of ON-Bar, ON-Archive, and ontape for D |
| ON-Bar for Data Recovery |
| Configuring ON-Bar |
| 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 Script |
| Volume Sets and Volumes for ON-Archive |
| Setting Up Volume Sets and Volumes for ON-Archive |
| Setting Up Volume Sets and Volumes for ON-Archive |
| ontape for Data Recovery |
| Configuring ontape |
| Database Backup (ON-Bar) |
| Approach to Database Backup (ON-Bar) |
| Guidelines for Database Backup (ON-Bar) |
| Levels and Frequency of Database Backup (ON-Bar) |
| CCMS for Scheduling Archives and Backups (ON-Bar a |
| Requirements for a Database Backup (ON-Bar) |
| 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 Ac |
| Checking Result of Database Backup or Archive with |
| Completing a Database Backup (ON-Bar) |
| Archive (ON-Archive and ontape) |
| Approach to Archive (ON-Archive) |
| Guidelines for Archive (ON-Archive and ontape) |
| Archive Levels and Frequency (ON-Archive and ontap |
| CCMS for Scheduling Archives and Backups (ON-Bar a |
| SAPDBA Recovery Report with Archives and Logical-L |
| Parallel Archive Approach (ON-Archive) |
| Requirements for an Archive (ON-Archive) |
| Tape Devices for Archive (ON-Archive) |
| Volume Sets and Volumes for Archive (ON-Archive) |
| Number of Tape Volumes for Archive (ON-Archive and |
| Parallel Archive Requirements (ON-Archive) |
| Unattended Archives: APART Qualifier (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-Arch |
| Checking Result of Database Backup or Archive with |
| Checking Tapes After an Archive (ON-Archive and on |
| Completing an Archive (ON-Archive) |
| Approach to Archive (ontape) |
| Guidelines for Archive (ON-Archive and ontape) |
| Archive Levels and Frequency (ON-Archive and ontap |
| Requirements for an Archive (ontape) |
| Number of Tape Volumes for Archive (ON-Archive and |
| Creation of an Archive (ontape) |
| Performing an Archive (ontape) |
| Checking Result of Database Backup or Archive with |
| Checking Tapes After an Archive (ON-Archive and on |
| Logical-Log Backup |
| Approach to Logical-Log Backup (ON-Bar) |
| Guidelines for Logical-Log Backup |
| Continuous or Manual Logical-Log Backup (ON-Bar) |
| CCMS for Scheduling Archives and Backups (ON-Bar a |
| Requirements for a Logical-Log Backup (ON-Bar) |
| 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 L |
| Checking Logical-Log Backup Result with Message Lo |
| Completing Logical-Log Backup (ON-Bar) |
| Approach to Logical-Log Backup (ON-Archive) |
| Guidelines for Logical-Log Backup |
| Automatic Logical-Log Backup (ON-Archive) |
| Continuous Logical-Log Backup (ON-Archive) |
| CCMS for Scheduling Archives and Backups (ON-Bar a |
| SAPDBA Recovery Report with Archives and Logical-L |
| Requirements for a Logical-Log Backup (ON-Archive) |
| Tape Devices for Logical-Log Backup (ON-Archive) |
| Volume Sets and Volumes for Logical-Log Backup (ON |
| Additional Logical-Log Backup Requirements (ON-Arc |
| Creation of a Logical-Log Backup (ON-Archive) |
| Performing Automatic Logical-Log Backup (ON-Archiv |
| Performing Continuous Logical-Log Backup to Tape ( |
| Performing Continuous Logical-Log Backup to Disk ( |
| Checking Logical-Log Backup Status (ON-Archive) |
| Checking Logical-Log Backup Result with Activity L |
| Checking Logical-Log Backup Result with Message Lo |
| Checking Tapes After a Logical-Log Backup (ON-Arch |
| Completing Logical-Log Backup (ON-Archive) |
| Approach to Logical-Log Backup (ontape) |
| Guidelines for Logical-Log Backup |
| Automatic or Continuous Logical-Log Backup (ontape |
| Requirements for a Logical-Log Backup (ontape) |
| 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 Lo |
| Checking Tapes After a Logical-Log Backup (ON-Arch |
| Completing Logical-Log Backup (ontape) |
| Emergency Logical-Log Backup |
| Performing Emergency Logical-Log Backup (ON-Bar) |
| Emergency Logical-Log Backup Using SAP Scripts (O |
| Preparing for Emergency Logical-Log Backup Using S |
| Performing Emergency Logical-Log Backup Using SAP |
| Checking Result of Emergency Logical-Log Backup wi |
| Emergency Logical-Log Backup Without SAP Scripts ( |
| Backing up Logical-Log Files Using ondatartr (ON-A |
| Checking Result of Emergency Logical-Log Backup wi |
| 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 Rest |
| 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 |
| 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 |
| 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 |
| Extending a Dbspace with SAPDBA |
| Adding a Dbspace with SAPDBA |
| Dropping a Dbspace 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 wit |
| 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 |
| 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 |
| Reorganizing a Dbspace and Its Tables with SAPDBA |
| Reorganization Troubleshooting with SAPDBA |
| Reorganization Log with SAPDBA |
| Restarting Uncompleted Reorganization Requests wit |
| Deleting Uncompleted Reorganization Requests with |
| Finishing a Table or Dbspace Reorganization with S |
| Data Consistency with SAPDBA |
| Type and Frequency of Data Consistency Checks with |
| Checking a Single Table for Data Consistency with |
| Checking Tables of a Dbspace for Data Consistency |
| Checking Tables with Blob Fields for Data Consiste |
| Checking All Tables of R/3 Database for Data Consi |
| Checking Indexes of Tables with ‘Blob’ Fields Usin |
| Checking Tables with ‘Blob’ Fields Using ONCHECK - |
| 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 |
| Updating Statistics for One Table with SAPDBA |
| Updating Statistics for All Tables with SAPDBA |
| Updating Statistics for All System Tables with SAP |
| Updating Statistics from the Command Line with SAP |
| 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 |