Ibm 000 8697 Users Manual Informix OnLine Database Server Administrator's Guide, Version 5.x
000-8697 to the manual d64eda7c-5f30-498e-91c7-80e21a9f0c47
2015-02-02
: Ibm Ibm-000-8697-Users-Manual-431831 ibm-000-8697-users-manual-431831 ibm pdf
Open the PDF directly: View PDF
Page Count: 702 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Informix Online Documentation
- Table of Contents
- Introduction
- Installation and Initial Configuration
- In This Chapter
- Define Your Starting Point
- Overview of OnLine Initial Configuration Tasks
- Set Up Your Initial Configuration
- Root Dbspace Configuration Guidelines
- Mirroring Configuration Guidelines
- Physical Log Configuration Guidelines
- Logical Log Configuration Guidelines
- Message File Guidelines
- Archive Tape Device Guidelines
- Logical Log Tape Device Guidelines
- Identification Parameter Guidelines
- Shared-Memory Parameter Guidelines
- Machine- and Product-Specific Parameter Guidelines
- OnLine Disk Space Allocation
- Configuration Checklist
- Enter Your Configuration and Initialize OnLine
- Errors During Initialization
- System Architecture
- In This Chapter
- Initialization
- Initialization Commands
- What Happens During Shared-Memory Initialization
- Shared-Memory Initialization Procedure
- Step 1: Calculate Configuration Values
- Step 2: Create Shared Memory
- Step 3: Attach to Shared Memory
- Step 4: Initialize Shared Memory Structure
- Step 5: Wake Parent Process
- Steps 6 and 7: Initiate Fast Recovery and First Checkpoint
- Step 8: Drop Temporary Tables (Optional)
- Step 9: Document Configuration Changes
- Step 10: Check for Forced Residency
- Step 11: Begin Looping as Master Daemon
- What Happens During Disk-Space Initialization
- Step 1: Calculate Configuration Values
- Step 2: Create OnLine Shared Memory
- Step 3: Attach to Shared Memory
- Step 4: Initialize Shared-Memory Structures
- Step 5: Initialize Disk Space
- Step 6: Wake Parent tbinit Process
- Step 7: Initiate First Checkpoint
- Step 8: Change to Quiescent Mode
- Step 9: Set Forced Residency
- Step 10: Loop as Master Daemon
- UNIX Kernel and Semaphore-Allocation Parameters
- OnLine User Processes
- OnLine Daemon Processes
- Shared Memory and Process Communication
- Shared Memory and Buffer Locks
- Managing Shared-Memory Resources
- Shared-Memory Header
- Shared-Memory Internal Tables
- Shared-Memory Buffer Pool
- OnLine LRU Queues
- LRU Queues and Buffer Pool Management
- How a User Process Acquires a Buffer
- Physical Log Buffer
- Logical Log Buffer
- OnLine Checkpoints
- What Happens During a Checkpoint
- When the Daemons Flush the Buffer Pool
- How OnLine Synchronizes Buffer Flushing
- Write Types Describe Flushing Activity
- Writing Data to a Blobspace
- Disk Data Structures
- OnLine Disk Space Terms and Definitions
- Structure of the Root Dbspace
- Structure of a Regular Dbspace
- Structure of an Additional Dbspace Chunk
- Structure of a Blobspace
- Structure of a Blobspace or Dbspace Mirror Chunk
- OnLine Limits for Chunks
- Reserved Pages
- Chunk Free-List Page
- tblspace Tblspace
- Database Tblspace
- Create a Database: What Happens on Disk
- OnLine Limits for Databases
- Create a Table: What Happens on Disk
- Create a Temporary Table: What Happens on Disk
- Structure of an Extent
- Next Extent Allocation
- Structure of a Dbspace Page
- Data Row Format and Rowid
- Data Pages and Data Row Storage
- Structure of an Index Page
- Structure of a Dbspace Bit-Map Page
- Blob Storage and the Blob Descriptor
- Structure of a Dbspace Blob Page
- Blobspace Page Types
- Structure of a Blobspace Blobpage
- Physical Log
- Logical Log Files
- Operating OnLine
- In This Chapter
- Changing Modes
- Logical Log Administration
- Examine Your Logical Log Configuration
- Change Pathname of Logical Log Tape Device
- Change Block Size of Logical Log Tape Device
- Change Tape Size of Logical Log Tape Device
- Change Maximum Number of Logical Log Files
- Change Size of Logical Log Files
- Logical Log File Status
- Logical Log File ID Numbers
- Add a Logical Log File
- Drop a Logical Log File
- Move a Logical Log File to Another Dbspace
- Change the Logging Status of a Database
- Back Up a Logical Log File
- Start Continuous Logical Log Backup
- End Continuous Logical Log Backup
- Switch to the Next Logical Log File
- Free a Logical Log File
- If the Logical Log Backup Cannot Complete
- Archive Administration
- Archive Types
- How Long Will an Archive Take?
- Plan the Archive Schedule
- Examine Your Archive Configuration
- Change Pathname of Archive Tape Device
- Change Block Size of Archive Tape Device
- Change Tape Size of Archive Tape Device
- Create an Archive, Any Type
- If the Logical Log Files Fill During an Archive
- If an Archive Terminates Prematurely
- Monitor OnLine Activity
- Monitor Archive History
- Monitor Blobs in a Blobspace
- Monitor Blobs in a Dbspace
- Monitor Buffers
- Monitor Buffer-Pool Activity
- Monitor Checkpoints
- Monitor Chunks
- Monitor Configuration Information
- Monitor Databases
- Monitor Dbspaces
- Monitor Disk Pages
- Monitor Extents
- Monitor Index Information
- Monitor Logging Activity
- Monitor the Message Log
- Monitor OnLine Profile
- Monitor Shared Memory and Latches
- Monitor Tblspaces
- Monitor Users and Transactions
- Modify OnLine Configuration
- Create a Blobspace
- Drop a Blobspace
- Change the Number of Buffers in the Pool
- Change the Size of Either Log Buffer
- Add a Chunk
- Change the Maximum Number of Chunks
- Create a Dbspace
- Drop a Dbspace
- Enforce/Turn Off Residency for This Session
- Enforce/Turn Off Residency
- Change the Status of a Mirrored Chunk
- Enable Mirroring
- Start/End Mirroring in a Blobspace or Dbspace
- Change Physical Log Location or Size
- Change the Checkpoint Interval
- Change the Destination of Console Messages
- Change the Maximum Number of Dbspaces
- Change the Maximum Number of Locks
- Change the Maximum Number of Tblspaces
- Change the Maximum Number of Users
- Change the Number of Page Cleaners
- Things to Avoid
- Data Consistency, Recovery, and Migration
- In This Chapter
- Consistency Checking
- Mirroring
- OnLine Logging Overview
- What Happens During Logical Log Backup
- What Happens During an Archive
- Read Archive History Information
- Mount a Tape on TAPEDEV
- Verify the Archive Level
- Check Free Space in the Logical Log
- Force a Checkpoint
- Synchronize tbtape and tbinit Activities
- Write Tape Header Page
- Archive Reserved Pages
- Determine Archive Criteria
- Archive Disk Pages That Meet Criteria
- Monitor and Archive Physical Log Pages
- Write a Trailer Page
- Update the Reserved Pages
- Fast Recovery
- Data Restore: When Should You Do It?
- Steps That Occur During a Data Restore
- Gather All Tapes Needed for Restore
- Verify OnLine Configuration
- Initiate Data Restore from Offline Mode
- Mount Level-0 Archive Tape
- Verify Current Configuration
- Prompt for Logical Log Backup
- Write Each Archive Page to Disk
- Initialize Shared Memory
- Roll Forward Logical Logs
- OnLine Is Quiescent
- Database and Table Migration
- How to Improve Performance
- DB-Monitor Screens
- Utilities
- In This Chapter
- dbexport: Unload a Database and Schema File
- dbimport: Create a Database
- dbload: Load Data from a Command File
- dbschema: Output SQL Statements
- tbcheck: Check, Repair, or Display
- tbinit: Initialize OnLine
- tbload: Create a Database or Table
- tblog: Display Logical Log Contents
- tbmode: Mode and Shared-Memory Changes
- tbparams: Modify Log Configuration Parameters
- tbspaces: Modify Blobspaces or Dbspaces
- tbstat: Monitor OnLine Operation
- tbtape: Logging, Archives, and Restore
- tbunload: Transfer Binary Data in Page Units
- OnLine Message Log
- Product Environment
- In This Chapter
- The OnLine Environment
- What Is Multiple Residency?
- OnLine Administration with IBM Informix STAR
- Sharing Data by Using IBM Informix STAR
- IBM Informix STAR and Two-Phase Commit Protocol
- Two-Phase Commit and Automatic Recovery
- Independent Action and Manual Recovery
- Heuristic Decisions: What and Why
- Heuristic Rollback
- Heuristic End-Transaction
- Two-Phase Commit Protocol Errors
- Two-Phase Commit and Logical Log Records
- Determining Database Consistency
- IBM Informix STAR Configuration Parameters
- Track a Transaction with tbstat Output
- Notices
- Index