| R/3 Database Guide: Informix (BC-DB-INF-DBA) |
| 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 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 |
| 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 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 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) |
| Developing Good Practice for Archive (ON-Archive and ontape) |
| Choosing Archive Levels and Frequency (ON-Archive |
| 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-Arch |
| Checking Result of Database Backup or Archive with |
| 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 |
| 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 |
| 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 L |
| Checking Logical-Log Backup Result with Message Lo |
| 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 ( |
| Performing Continuous Logical-Log Backup to Disk (ON-Archive) |
| 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-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 Lo |
| 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 |
| 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 |