IBM 000-8697 manual

702

Download on canonical page 702 pages, 4.15 Mb

IBM Informix OnLine

Database Server

Administrator’s Guide

Version 5.x

December 2001

Part No. 000-8697

Models

000-8697

2ii IBM Informix OnLine Database Server Administrators Guide
3Table of Contents
- Table of Contents
  - Introduction
  - 4Chapter 1 Installation and Initial Conguration
  - 5Chapter 2 System Architecture
  - 7Chapter 3 Operating OnLine
  - 9Chapter 4 Data Consistency, Recovery, and Migration
  - 11Chapter 5 How to Improve Performance
  - 12Chapter 6 DB-Monitor Screens
  - Chapter 7 Utilities
  - 14Chapter 8 OnLine Message Log
  - Chapter 9 Product Environment
  - Appendix A Notices Index
- Introduction
15Introduction
- 17In This Introduction
- About This Manual
  - Organization of This Manual
  - 18Organization of This Manual
    - Demonstration Database
  - 19Demonstration Database
    - 20Demonstration Database
    - IBM Informix OnLine
- 21IBM Informix OnLine
  - Product Overview
  - IBM Informix OnLine and Other IBM Informix Products
    - Documentation Conventions
- 22Documentation Conventions
  - Typographical Conventions
    - Icon Conventions
  - 23Icon Conventions
  - Command-Line Conventions
    - 24Command-Line Conventions Elements That Can Appear on the Path
      - You might encounter one or more of the following elements on a path.
    - 25Command-Line Conventions
    - How to Read a Command-Line Diagram
    - Sample Code Conventions
  - 26Sample Code Conventions
    - 27Sample Code Conventions
    - Additional Documentation
- 28Additional Documentation
  - Printed Manuals
  - 29Error Message Files
    - Using the ASCII Error Message File
      - 30The nderr Script
      - 31The rofferr Script
    - Documentation Notes, Release Notes, Machine Notes Using the PostScript Error Message Files
  - 32Documentation Notes, Release Notes, Machine Notes
    - Related Reading
- 33Related Reading
- Compliance with Industry Standards
  - IBM Welcomes Your Comments
- 34IBM Welcomes Your Comments
35Installation and Initial Conguration
- Dene Your Starting Point
- 40Dene Your Starting Point
  - 41Upgrade an Earlier Version of OnLine
    - Compare Your Current Conguration to OnLine 5.x
    - 42Create a Level-0 Archive
    - Load the Software and Execute the install Script
    - Initialize Shared Memory
      - Run tbcheck
    - 43Create a New Level-0 Archive
    - Overview of OnLine Installation Steps
  - Overview of OnLine Installation Steps
- 44Overview of OnLine Initial Conguration Tasks
  - OnLine Conguration Files
  - 45OnLine Conguration Files
    - 46OnLine Conguration Files
  - 47Contents of tbcong.std
    - 521-18 IBM Informix OnLine Database Server Administrators Guide
    - USERS species the maximum number of OnLine user processes that can
    - Figure1-1 The Contents of tbcong.std
    - 53Installation and Initial Configuration 1-19
    - Set Up Your Initial Conguration
- 54Set Up Your Initial Conguration
  - 55Root Dbspace Conguration Guidelines
    - ROOTNAME
    - 56ROOTPATH
    - ROOTOFFSET
    - 57ROOTSIZE
    - Mirroring Conguration Guidelines
  - 58Mirroring Conguration Guidelines
    - MIRROR
    - MIRRORPATH
    - Physical Log Conguration Guidelines MIRROROFFSET
  - 59Physical Log Conguration Guidelines
    - PHYSDBS
    - PHYSFILE
    - Logical Log Conguration Guidelines
  - 60Logical Log Conguration Guidelines
    - 61Logical Log Conguration Guidelines LOGFILES
    - LOGSIZE
    - Message File Guidelines
  - 62Message File Guidelines
    - MSGPATH
    - CONSOLE
  - Archive Tape Device Guidelines
    - TAPEDEV
    - Logical Log Tape Device Guidelines
    - TAPEBLK
    - TAPESIZE
  - 63Logical Log Tape Device Guidelines
    - 64Logical Log Tape Device Guidelines
    - LTAPEDEV
    - LTAPEBLK
    - Identication Parameter Guidelines LTAPESIZE
  - 65Identication Parameter Guidelines
    - SERVERNUM
    - DBSERVERNAME
  - 66Shared-Memory Parameter Guidelines
    - RESIDENT
    - 67USERS
    - TRANSACTIONS
    - LOCKS
    - 68BUFFERS
    - TBLSPACES
    - 69CHUNKS
    - DBSPACES
    - PHYSBUFF
    - LOGBUFF
    - 70LOGSMAX
    - CLEANERS
    - SHMBASE
    - 71CKPTINTVL
    - LRUS
    - LRU_MAX_DIRTY
    - LRU_MIN_DIRTY
    - 72LTXHWM
    - LTXEHWM
    - Machine- and Product-Specic Parameter Guidelines
  - 73Machine- and Product-Specic Parameter Guidelines
    - DYNSHMSZ
    - GTRID_CMP_SZ
    - DEADLOCK_TIMEOUT
    - TXTIMEOUT
    - SPINCNT
  - 74OnLine Disk Space Allocation
    - Allocate Raw Disk Space or Cooked Files?
    - 75How Much Disk Space Do You Need?
      - 76Calculate Root dbspace Size
      - Project Total Space Requirements
    - 77How Should You Apportion Disk Space?
      - 78Space Allocation in a Learning Environment
      - Space Allocation in a Production Environment
    - 81How to Allocate Disk Space
      - Cooked File Space
      - 82Raw File Space
    - 83Evaluate UNIX Kernel Parameters
    - Conguration Checklist
- 84Conguration Checklist
  - Enter Your Conguration and Initialize OnLine
- 85Enter Your Conguration and Initialize OnLine
  - 86Enter Your Conguration and Initialize OnLine
  - Setting Shared Memory Parameters
  - 87Setting Shared Memory Parameters
    - Initialize OnLine
  - 88Initialize OnLine
  - Set Your Environment Variables
    - 89Set Your Environment Variables SQLEXEC
    - TBCONFIG
  - 90Modify UNIX Startup and Shutdown Scripts
    - 91Startup
    - 92Shutdown
    - Create Blobspaces and Dbspaces
  - Create Blobspaces and Dbspaces
- 93Errors During Initialization
  - OnLine Error Message Format
  - 94OnLine Error Message Format
  - UNIX Error Message Format
95System Architecture
- 101Initialization
  - Initialization Commands
  - 102Initialization Commands
    - 103Initialization Commands
    - Shared Memory Commands
    - Disk Space Commands
  - 104What Happens During Shared-Memory Initialization
    - 105Shared-Memory Initialization Procedure
    - Step 1: Calculate Conguration Values
    - 106Step 2: Create Shared Memory
    - Step 3: Attach to Shared Memory
    - Step 4: Initialize Shared Memory Structure
    - 107Step 5: Wake Parent Process
    - Steps 6 and 7: Initiate Fast Recovery and First Checkpoint
    - Step 8: Drop Temporary Tables (Optional)
    - Step 9: Document Conguration Changes
    - Step 10: Check for Forced Residency
    - Step 11: Begin Looping as Master Daemon
  - 108What Happens During Disk-Space Initialization
    - 109Step 1: Calculate Conguration Values
    - 110Step 2: Create OnLine Shared Memory
    - Step 3: Attach to Shared Memory
    - Step 4: Initialize Shared-Memory Structures
    - Step 5: Initialize Disk Space
    - 111Step 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
  - 112UNIX Kernel and Semaphore-Allocation Parameters
    - OnLine User Processes
- 116OnLine User Processes
  - 117OnLine User Processes
  - 118How User Processes Attach to Shared Memory
    - Step 1: Obtain SERVERNUM
    - 119Step 2: Calculate Shared-Memory Key Value
    - Steps 3 and 4: Request Shared-Memory Segment and Attach to SHMBASE
    - 121Step 5: Attach Additional Segments
    - User Processes and Critical Sections
  - 122User Processes and Critical Sections
    - OnLine User Process Status and States
  - 123OnLine User Process Status and States
    - OnLine Database Server Process
  - 124OnLine Database Server Process
    - Orphaned Database Server Processes
  - 125Orphaned Database Server Processes
    - 126Orphaned Database Server Processes
    - OnLine Daemon Processes
- 127OnLine Daemon Processes
  - tbinit Daemon
    - tbundo Daemon
  - 128tbundo Daemon
  - tbpgcl Daemon
    - 129tbpgcl Daemon
    - Shared Memory and Process Communication
- 130Shared Memory and Process Communication
  - 131Shared Memory and Process Communication
  - Shared Memory and Buffer Locks
  - 132Shared Memory and Buffer Locks
    - Buffer Share Lock
    - Buffer Update Lock
    - Buffer Exclusive Lock
  - 133Managing Shared-Memory Resources
    - 135Shared-Memory Latches
      - 136Test-and-Set Institutions
      - Spin and Test Again
      - 137Semaphores
      - Forced Abort
    - 138OnLine Timestamps
    - 140Hash Tables and the Hashing Technique
    - Shared-Memory Header
  - 141Shared-Memory Header
  - 142Shared-Memory Internal Tables
    - OnLine Buffer Table
    - 143OnLine Chunk Table
    - 144OnLine Dbspace Table
    - 145OnLine Latch Table
    - OnLine Lock Table
    - 146OnLine Page-Cleaner Table
    - OnLine Tblspace Table
    - 148OnLine Transaction Table
    - OnLine User Table
    - Shared-Memory Buffer Pool
  - 149Shared-Memory Buffer Pool
    - 150Shared-Memory Buffer Pool Regular Buffers
    - Big Buffers
    - OnLine LRU Queues
  - 151OnLine LRU Queues
    - LRU Queues and Buffer Pool Management
  - 152LRU Queues and Buffer Pool Management
    - 153LRU Queues and Buffer Pool Management LRU_MAX_DIRTY
    - LRU_MIN_DIRTY
  - 154How a User Process Acquires a Buffer
    - 155Step 1: Identify the Data
    - Step 2: Determine Lock-Access Level
    - Step 3: Locate the Page in Memory
    - 156Step 4: Read the Page in from Disk
    - Steps 5-7: Lock Buffer, Release Lock, and Wake Waiting Processes
  - 157Physical Log Buffer
    - 158Double Buffering
    - Causes of Flushing
    - 159Flushing a Full Buffer
  - 160Logical Log Buffer
    - Triple Buffering
    - 162Buffer Contents
    - Causes of Flushing
    - 163Flushing a Full Buffer
    - OnLine Checkpoints
  - 164OnLine Checkpoints
    - Main Events During a Checkpoint
    - Initiating a Checkpoint
    - 165OnLine Checkpoints
    - Fast Recovery
    - Archive Checkpoints
    - What Happens During a Checkpoint
  - 166What Happens During a Checkpoint
    - When the Daemons Flush the Buffer Pool
  - 167When the Daemons Flush the Buffer Pool
    - How OnLine Synchronizes Buffer Flushing
  - 168How OnLine Synchronizes Buffer Flushing
  - 169Write Types Describe Flushing Activity
    - 170Sorted Write
    - Idle Write
    - 171Foreground Write
    - LRU Write
    - Chunk Write
    - Big-Buffer Write
  - 172Writing Data to a Blobspace
    - Disk Data Structures
- 175Disk Data Structures
  - OnLine Disk Space Terms and Denitions
    - 176Chunk
    - Page
    - 178Blobpage
    - Dbspace and Blobspace
    - 179Database
    - Tblspace
    - Extent
    - 180Logical Log
    - Structure of the Root Dbspace
  - 181Structure of the Root Dbspace
    - 182Structure of the Root Dbspace
    - Structure of a Regular Dbspace
  - 183Structure of a Regular Dbspace
    - Structure of an Additional Dbspace Chunk
  - 184Structure of an Additional Dbspace Chunk
    - Structure of a Blobspace
  - 185Structure of a Blobspace
    - Structure of a Blobspace or Dbspace Mirror Chunk
  - 186Structure of a Blobspace or Dbspace Mirror Chunk
    - OnLine Limits for Chunks
  - 187OnLine Limits for Chunks
    - 188OnLine Limits for Chunks
  - 189Reserved Pages
    - 191PAGE_PZERO
    - PAGE_CONFIG
    - PAGE_CKPT
      - 192The following elds display for each OnLine logical log le.
    - 193PAGE_DBSP
    - 194PAGE_PCHUNK
    - 195PAGE_MCHUNK
    - 196PAGE_ARCH
    - Chunk Free-List Page
  - 197Chunk Free-List Page
  - 198tblspace Tblspace
    - 199tblspace Tblspace Entries
    - Tblspace Number
    - 200tblspace Tblspace Size
    - Database Tblspace tblspace Tblspace Bit-Map Page
  - 201Database Tblspace
    - Create a Database: What Happens on Disk
  - 202Create a Database: What Happens on Disk
    - 203Create a Database: What Happens on Disk Allocate Disc Space
    - Track Systems Catalogs
    - OnLine Limits for Databases
  - 204OnLine Limits for Databases
  - Create a Table: What Happens on Disk
    - 205Create a Table: What Happens on Disk
    - Allocate Disc Space
    - Add Entry to tblspace Tblspace
    - Add Entry to System Catalog Tables
    - 206Create a Table: What Happens on Disk
    - Create a Temporary Table: What Happens on Disk
  - 207Create a Temporary Table: What Happens on Disk
    - Placement
    - Tracking
    - Cleanup
  - 208Structure of an Extent
    - Extent Size
    - 209Page Types
  - 211Next Extent Allocation
  - 214Structure of a Dbspace Page
    - 215Page Header
    - Timestamp
    - Slot Table
    - Data Row Format and Rowid
  - 217Data Row Format and Rowid
    - 218Data Row Format and Rowid
  - 219Data Pages and Data Row Storage
    - 220Single-Page Storage
    - 221Multipage Storage
    - 223Storage of Modied Rows
    - Page Compression
  - 227Structure of an Index Page
    - 228The Root Node Page
    - 230Leaf Node Pages
    - 232Index Key Entries
    - Structure of a Dbspace Bit-Map Page
  - 237Structure of a Dbspace Bit-Map Page
    - 2-Bit Bit-Mapped Pages
    - 238Structure of a Dbspace Bit-Map Page
    - 4-Bit Bit-Mapped Pages
    - Blob Storage and the Blob Descriptor
  - 239Blob Storage and the Blob Descriptor
    - Structure of a Dbspace Blob Page
  - 240Structure of a Dbspace Blob Page
    - 241Structure of a Dbspace Blob Page
    - Blobspace Page Types
  - 242Blobspace Page Types
    - Blobspace Free-Map Page
    - Blobspace Bit-Map Page
    - Blobpage
  - 243Structure of a Blobspace Blobpage
- 246Physical Log
  - Logical Log Files
- 248Logical Log Files
  - Fast Recovery and Data Restore
    - File Rotation
  - 249File Rotation
    - File Contents
  - 250File Contents
  - Number and Size
    - 251Number and Size
  - 252Blobspace Logging
  - 253Long Transactions
257Operating OnLine
- Changing Modes
- 262Changing Modes
  - Types of OnLine Modes
    - From Ofine to Quiescent
  - 264From Ofine to Quiescent
  - From Ofine to Online
    - From Quiescent to Online
  - 265From Quiescent to Online
    - Gracefully from Online to Quiescent
  - 266Gracefully from Online to Quiescent
    - Immediately from Online to Quiescent
  - 267Immediately from Online to Quiescent
    - From Any Mode Immediately to Ofine
  - 268From Any Mode Immediately to Ofine
    - Logical Log Administration
- 269Logical Log Administration
  - 270Examine Your Logical Log Conguration
    - Your Conguration File
    - Logical Log File Backups
    - 271Freeing the Logical Log Files
    - Verify the Size and Number of Files
    - 272Conguration Parameters
    - 273LTAPEBLK and LTAPESIZE
    - Location of Logical Log Files
  - 274Change Pathname of Logical Log Tape Device
    - 275Preliminary Consideration
    - Change Block Size of Logical Log Tape Device
  - 277Change Block Size of Logical Log Tape Device
    - Change Tape Size of Logical Log Tape Device
  - 278Change Tape Size of Logical Log Tape Device
    - Change Maximum Number of Logical Log Files
  - 279Change Maximum Number of Logical Log Files
    - Change Size of Logical Log Files
  - 280Change Size of Logical Log Files
    - 281Change Size of Logical Log Files
    - Logical Log File Status
  - 282Logical Log File Status
    - Logical Log File ID Numbers
  - 283Logical Log File ID Numbers
    - Add a Logical Log File
  - 284Add a Logical Log File
    - 285Add a Logical Log File
    - Drop a Logical Log File
  - 286Drop a Logical Log File
    - Move a Logical Log File to Another Dbspace
  - 287Move a Logical Log File to Another Dbspace
    - 288Move a Logical Log File to Another Dbspace
  - 289Change the Logging Status of a Database
    - 290Adding Logging to a Database
    - 291Ending or Modifying Logging from DB-Monitor
    - Back Up a Logical Log File
    - ANSI Compliance
  - 292Back Up a Logical Log File
    - Start Continuous Logical Log Backup
  - 293Start Continuous Logical Log Backup
    - End Continuous Logical Log Backup
  - 294End Continuous Logical Log Backup
    - Switch to the Next Logical Log File
  - 295Switch to the Next Logical Log File
  - Free a Logical Log File
    - 296Free a Logical Log File
    - 297Free a Logical Log File Status A
    - Status U
    - Status U-B
    - Status U-C
    - Status U-B-L
    - If the Logical Log Backup Cannot Complete
  - 298If the Logical Log Backup Cannot Complete
    - Archive Administration
- 299Archive Administration
  - Archive Types
    - 300Archive Types
    - Level-0 Archive
    - 301Archive Types Level-1 Archive
    - Level-2 Archive
    - Incremental Archive Strategy
    - How Long Will an Archive Take?
  - 302How Long Will an Archive Take?
  - 303Plan the Archive Schedule
    - 304Minimize Restore Time
    - 305Minimize Archive Time
    - Online Archives
    - Single Tape Drive
    - Examine Your Archive Conguration
    - Operator Availability
  - 306Examine Your Archive Conguration
    - Your Conguration File
    - 307Examine Your Archive Conguration
    - The Archives
    - TAPEDEV Conguration Parameter
    - TAPEBLK and TAPESIZE
  - 308Change Pathname of Archive Tape Device
    - Change Block Size of Archive Tape Device
  - 311Change Block Size of Archive Tape Device
    - Change Tape Size of Archive Tape Device
  - 312Change Tape Size of Archive Tape Device
    - Create an Archive, Any Type
  - 313Create an Archive, Any Type
    - 314Create an Archive, Any Type
    - If the Logical Log Files Fill During an Archive
  - 315If the Logical Log Files Fill During an Archive
    - Two Tape Drives
    - If an Archive Terminates Prematurely One Tape Drive
  - 316If an Archive Terminates Prematurely
    - Monitor OnLine Activity
- 317Monitor OnLine Activity
  - Monitor Archive History
    - 318Monitor Archive History
    - Monitor Blobs in a Blobspace
  - 319Monitor Blobs in a Blobspace
    - 320Monitor Blobs in a Blobspace
    - Monitor Blobs in a Dbspace
  - 321Monitor Blobs in a Dbspace
    - Monitor Buffers
  - 322Monitor Buffers
    - tbstat -b
    - tbstat -X
    - 323Monitor Buffers tbstat -B
    - tbstat -p
    - Monitor Buffer-Pool Activity
  - 324Monitor Buffer-Pool Activity
    - tbstat -F
    - Monitor Checkpoints tbstat -R
    - tbstat -D
  - 325Monitor Checkpoints
  - 326Monitor Chunks
    - Monitor Conguration Information
  - 329Monitor Conguration Information
    - Monitor Databases
  - 330Monitor Databases
    - Monitor Dbspaces
  - 331Monitor Dbspaces
    - 332Monitor Dbspaces
    - Monitor Disk Pages
  - 333Monitor Disk Pages
    - Monitor Extents
  - 334Monitor Extents
    - Monitor Index Information
  - 335Monitor Index Information
    - Monitor Logging Activity
  - 336Monitor Logging Activity
    - 337Monitor Logging Activity
    - Monitor the Message Log
  - 338Monitor the Message Log
    - Monitor OnLine Prole
  - 339Monitor OnLine Prole
    - Monitor Shared Memory and Latches
  - 340Monitor Shared Memory and Latches
    - Monitor Tblspaces
  - 341Monitor Tblspaces
    - Monitor Users and Transactions
  - 342Monitor Users and Transactions
    - Modify OnLine Conguration
- 343Modify OnLine Conguration
  - 344Create a Blobspace
    - Drop a Blobspace
  - 347Drop a Blobspace
    - Change the Number of Buffers in the Pool
  - 348Change the Number of Buffers in the Pool
    - Change the Size of Either Log Buffer
  - 349Change the Size of Either Log Buffer
  - 350Add a Chunk
    - Change the Maximum Number of Chunks
  - 352Change the Maximum Number of Chunks
    - Create a Dbspace
  - 353Create a Dbspace
    - 354Create a Dbspace
    - Drop a Dbspace
  - 355Drop a Dbspace
    - Enforce/Turn Off Residency for This Session
  - 356Enforce/Turn Off Residency for This Session
  - Enforce/Turn Off Residency
  - 357Change the Status of a Mirrored Chunk
    - Enable Mirroring
  - 360Enable Mirroring
    - Start/End Mirroring in a Blobspace or Dbspace
  - 361Start/End Mirroring in a Blobspace or Dbspace
    - Start Mirroring
    - 362Start/End Mirroring in a Blobspace or Dbspace
    - End Mirroring
    - Change Physical Log Location or Size
  - 363Change Physical Log Location or Size
    - 364Change Physical Log Location or Size
    - Change the Checkpoint Interval
  - 365Change the Checkpoint Interval
    - Change the Destination of Console Messages
  - 366Change the Destination of Console Messages
    - Change the Maximum Number of Dbspaces
  - 367Change the Maximum Number of Dbspaces
    - Change the Maximum Number of Locks
  - 368Change the Maximum Number of Locks
    - Change the Maximum Number of Tblspaces
  - 369Change the Maximum Number of Tblspaces
    - Change the Maximum Number of Users
  - 370Change the Maximum Number of Users
    - Change the Number of Page Cleaners
  - 371Change the Number of Page Cleaners
    - Things to Avoid
- 372Things to Avoid
373Data Consistency, Recovery, and Migration
- Consistency Checking
- 378Consistency Checking
  - Using the tbcheck Commands
    - 379Using the tbcheck Commands tbcheck -cr
    - tbcheck -cc
    - tbcheck -ce
    - Using the OnLine Message Log tbcheck -cI
    - tbcheck -cD
  - 380Using the OnLine Message Log
  - 381Setting Consistency-Checking Variables
    - 382GCORE
    - 383DUMPCORE
    - DUMPSHMEM
    - Recovering from Corruption
    - DUMPDIR
  - 384Recovering from Corruption
    - 385Recovering from Corruption
    - Mirroring
- 386Mirroring
  - Beginning
  - 387Beginning
    - Processing
  - 388Processing
    - Recovery
  - 389Recovery
  - Ending
    - OnLine Logging Overview
- 390OnLine Logging Overview
  - Dbspace Logging
  - 391Dbspace Logging
    - 393Dbspace Logging
  - 394Blobspace Logging
    - 396Operations Logging
    - Operations Rollback
    - 397Blob Restoration
    - What Happens During Logical Log Backup
- 398What Happens During Logical Log Backup
  - Ready LTAPEDEV
  - 399Ready LTAPEDEV
  - Locate the Next Logical Log
  - Copy Blobpages
    - Place Log Header on Tape
  - 400Place Log Header on Tape
    - Write Log Records to Tape
  - 401Write Log Records to Tape
    - 1 2 3
    - Write Trailer Page
  - Write Trailer Page
- 402What Happens During an Archive
  - Read Archive History Information
  - 403Read Archive History Information
  - Mount a Tape on TAPEDEV
    - Verify the Archive Level
  - 404Verify the Archive Level
  - Check Free Space in the Logical Log
  - Force a Checkpoint
    - Synchronize tbtape and tbinit Activities
    - Purpose of Checkpoint Timestamp
    - Purpose of Data Snapshot
  - 405Synchronize tbtape and tbinit Activities
    - 406Synchronize tbtape and tbinit Activities
    - Archive Disk Pages
    - Write Tape Header Page Archive blobpages
  - 407Write Tape Header Page
    - Archive Reserved Pages
  - 408Archive Reserved Pages
    - Determine Archive Criteria
  - 409Determine Archive Criteria
    - Archive Disk Pages That Meet Criteria
  - 410Archive Disk Pages That Meet Criteria
  - Monitor and Archive Physical Log Pages
  - Write a Trailer Page
  - Update the Reserved Pages
    - Fast Recovery
- 411Fast Recovery
  - How Does OnLine Initiate Fast Recovery?
    - Fast Recovery and Logging
  - 412Fast Recovery and Logging
    - Step 1: Checkpoint Condition
  - 413Step 1: Checkpoint Condition
  - Step 2: Find Checkpoint Record in Logical Log
    - 414Step 2: Find Checkpoint Record in Logical Log
    - Step 3: Roll Forward Log Records
  - 415Step 3: Roll Forward Log Records
    - Step 4: Roll Back Incomplete Transactions
  - 416Step 4: Roll Back Incomplete Transactions
    - Data Restore: When Should You Do It?
- 417Data Restore: When Should You Do It?
  - Steps That Occur During a Data Restore
    - 418Steps That Occur During a Data Restore
    - Gather All Tapes Needed for Restore
  - 419Gather All Tapes Needed for Restore
    - Verify OnLine Conguration
  - 420Verify OnLine Conguration
    - Initiate Data Restore from Ofine Mode
  - 421Initiate Data Restore from Ofine Mode
  - Mount Level-0 Archive Tape
    - Verify Current Conguration
  - 422Verify Current Conguration
  - Prompt for Logical Log Backup
    - Write Each Archive Page to Disk
  - 423Write Each Archive Page to Disk
  - Initialize Shared Memory
  - Roll Forward Logical Logs
    - OnLine Is Quiescent
  - OnLine Is Quiescent
- 424Database and Table Migration
  - 425Database and Table Migration
  - 426Description of Migration Methods
    - UNLOAD/dbschema/LOAD
    - UNLOAD/dbschema/dbload
    - 427dbexport/dbimport
    - tbunload/tbload
- 428}
  - 429Which Migration Method Is Best for You?
    - Using UNLOAD with LOAD or dbload
  - 432Using UNLOAD with LOAD or dbload
    - 433Using UNLOAD with LOAD or dbload Create and Edit the Schema File First
    - Verify Adequate Disk Space for Data
    - Move Files
    - Create the New Database or Tables
    - Using dbexport and dbimport Use LOAD or dbload to Populate the Tables
  - 434Using dbexport and dbimport
    - Using tbunload and tbload
  - 435Using tbunload and tbload
    - 436Using tbunload and tbload tbunload
    - tbload
    - Migrating Data from OnLine to SE
  - 437Migrating Data from OnLine to SE
    - Migrating Data from SE to OnLine
  - 438Migrating Data from SE to OnLine
441How to Improve Performance
- Disk Layout
- 444Disk Layout
  - Optimize Blobspace Blobpage Size
- 445Optimize Blobspace Blobpage Size
  - tbcheck -pB and tbcheck -pe Utility Commands
    - 446tbcheck -pB and tbcheck -pe Utility Commands
    - Blobpage Average Fullness
  - 447Blobpage Average Fullness
    - Apply Effective Criteria
  - Apply Effective Criteria
- 448Eliminate User-Created Resource Bottlenecks
  - 449Eliminate User-Created Resource Bottlenecks
  - When Is Tuning Needed?
- 450When Is Tuning Needed?
  - % Cached Fields
    - ovtbls, ovlock, ovuser, and ovbuff Fields
  - 451ovtbls, ovlock, ovuser, and ovbuff Fields
  - Bufsize Pages/IO Fields
    - 452Bufsize Pages/IO Fields
    - Shared-Memory Buffers
- 453Shared-Memory Buffers
  - When Is Tuning Necessary?
    - Shared-Memory Resources
- 454Shared-Memory Resources
  - When Is Tuning Necessary?
- 455Log Buffer Size
  - Logging Status
    - Page-Cleaner Parameters
- 457Page-Cleaner Parameters
  - Efcient Page Cleaning
    - 458Efcient Page Cleaning
    - Checkpoint Frequency
- 460Checkpoint Frequency
  - Performance Tradeoffs
    - Psort Parallel-Process Sorting Package
- 462Psort Parallel-Process Sorting Package
  - How Psort Works
    - Tuning Psort
  - 463Tuning Psort
    - Psort and Shared Memory
  - Psort and Shared Memory
- 464SPINCNT Conguration Parameter
  - 465SPINCNT Conguration Parameter
467DB-Monitor Screens
- Main Menu
- 470Main Menu
  - Status Menu
- 471Status Menu
  - Parameters Menu
- 472Parameters Menu
  - Dbspaces Menu
- 473Dbspaces Menu
  - Mode Menu
- 474Mode Menu
  - Archive Menu
- 476Archive Menu
  - Logical-Logs Menu
- 477Logical-Logs Menu
479Utilities
- 483dbexport: Unload a Database and Schema File
  - Destination Options
  - 485Destination Options
    - 486Destination Options
    - Contents of the Schema File
  - 487Contents of the Schema File
    - dbimport: Create a Database
- 488dbimport: Create a Database
  - Input File Location Options
  - 490Input File Location Options
    - 491Input File Location Options
    - Create Options
  - 492Create Options
    - dbload: Load Data from a Command File
- 493dbload: Load Data from a Command File
  - Command-File Syntax Check
  - 496Command-File Syntax Check
  - Starting Line Number
    - Batch Size
  - 497Batch Size
    - Bad-Row Limits
  - 498Bad-Row Limits
  - 499How to Create a Command File
- 510dbschema: Output SQL Statements
  - Include Synonyms
  - 511Include Synonyms
    - Include Privileges
  - 512Include Privileges
    - Specify a Table, View, or Procedure
  - 513Specify a Table, View, or Procedure
    - tbcheck: Check, Repair, or Display
- 514tbcheck: Check, Repair, or Display
  - 515tbcheck: Check, Repair, or Display
    - 7-38 IBM Informix OnLine Database Server Administrators Guide
    - 516-
  - 517Option Descriptions
    - No Options
    - -cc Option
    - 518-cd and -cD Options
    - -ce Option
    - -ci and -cI Options
    - 519-cr Option
    - -n Option
    - 520-pB Option
    - -pc Option
    - -pd and -pD Options
    - 521-pe Option
    - -pk and -pK, -pl and -pL Options
    - -pp and -pP options
    - 522-pr Option
    - -pt and -pT Options
    - tbinit: Initialize OnLine
    - -q Option
    - -y Option
- 523tbinit: Initialize OnLine
  - 524No Options
  - -i Option
  - tbload: Create a Database or Table -p Option
- 525tbload: Create a Database or Table
  - Specify Tape Parameters
  - 527Specify Tape Parameters
    - Create Options
  - 528Create Options
    - tblog: Display Logical Log Contents
- 529tblog: Display Logical Log Contents
  - Log-Record Read Filters
  - 530Log-Record Read Filters
    - -b Option
    - Log-Record Display Filters
  - 532Log-Record Display Filters
  - 533Interpreting tblog Output
    - 534Record Types
    - 535Record Contents
    - tbmode: Mode and Shared-Memory Changes
- 542tbmode: Mode and Shared-Memory Changes
  - 543-y automatically responds yes to all prompts.
    - Utilities 7-65
  - Change OnLine Mode
  - 544Change OnLine Mode
    - -k Option
    - -m Option
    - Force a Checkpoint
    - -u Option
  - 545Force a Checkpoint
    - Change Shared-Memory Residency
  - 546Change Shared-Memory Residency
  - Switch the Logical Log File
    - Kill an OnLine Server Process
  - 547Kill an OnLine Server Process
  - Kill an OnLine Transaction
    - tbparams: Modify Log Conguration Parameters
- 548tbparams: Modify Log Conguration Parameters
  - Add a Logical Log File
    - Drop a Logical Log File
  - 549Drop a Logical Log File
    - Change Physical Log Parameters
  - 550Change Physical Log Parameters
    - tbspaces: Modify Blobspaces or Dbspaces
- 551tbspaces: Modify Blobspaces or Dbspaces
  - Create a Blobspace or Dbspace
  - 552Create a Blobspace or Dbspace
    - Drop a Blobspace or Dbspace
  - 553Drop a Blobspace or Dbspace
  - 554Add a Chunk
    - Change Chunk Status
  - 555Change Chunk Status
    - tbstat: Monitor OnLine Operation
- 556tbstat: Monitor OnLine Operation
  - 557tbstat: Monitor OnLine Operation
    - 5587-80 IBM Informix OnLine Database Server Administrators Guide
  - 560Option Descriptions
    - 562-B Option
    - -c Option
    - -d Option
    - 564-D Option
    - 565-F Option
    - 566-k Option
    - 567-l Option
    - 569-m Option
    - -o Option
    - 570-p Option
    - 573-P Option
    - -r Option
    - -R option
    - 576-t Option
    - 577-u Option
    - 579-X Option
    - tbtape: Logging, Archives, and Restore -z Option
- 580tbtape: Logging, Archives, and Restore
  - Request a Logical Log Backup
  - 582Request a Logical Log Backup
  - Start Continuous Backups
    - Create an Archive
  - 583Create an Archive
  - Perform a Data Restore
    - Change Database Logging Status
  - 584Change Database Logging Status
    - tbunload: Transfer Binary Data in Page Units
- 585tbunload: Transfer Binary Data in Page Units
  - Specify Tape Parameters
  - 587Specify Tape Parameters
- 591OnLine Message Log
  - 592OnLine Message Log
- 593Alphabetized Messages
621Product Environment
- 623The OnLine Environment
  - OnLine Features
    - 624OnLine Features High Performance
    - 625OnLine Features Fault Tolerance and High Availability
    - Multimedia Support
    - Features Beyond the Scope of OnLine Distributed Data Queries
  - 626Features Beyond the Scope of OnLine
    - Bad-Sector Mapping
    - Blob Scanning or Compression
- 627What Is Multiple Residency?
  - 629disk disk
    - How Multiple Residency Works
  - 630How Multiple Residency Works
  - 631How to Set Up Multiple Residency
    - Step 1: Create a New Conguration File
    - 632Step 2: Edit the Conguration File for the New OnLine
      - ROOTPATH
      - SERVERNUM
      - DBSERVER-NAME
      - MSGPATH
    - 633Step 3: Set Your TBCONFIG Environment Variable
    - 634Step 4: Complete Tuning OnLine Conguration (Optional)
    - Step 5: Initialize New OnLine
    - Step 6: Ensure That Users Correctly Dene Their TBCONFIG Variables
    - OnLine Administration with IBM Informix STAR
- 635OnLine Administration with IBM Informix STAR
  - Sharing Data by Using IBM Informix STAR
    - 637Updating Multiple OnLine Servers
    - 638Multiserver Modication Concepts
  - 639IBM Informix STAR and Two-Phase Commit Protocol
  - 643Two-Phase Commit and Automatic Recovery
    - Coordinator Recovery
    - 646Participant Recovery
    - Independent Action and Manual Recovery Presumed-Abort Optimization
  - 649Independent Action and Manual Recovery
  - 650Heuristic Decisions: What and Why
  - 656Heuristic Rollback
    - Condition 1: Logical Log Fills to a High-Water Mark
    - 657Condition 2: You Execute tbmode -z
    - When a Heuristic Rollback Occurs
  - 660Heuristic End-Transaction
    - Two-Phase Commit Protocol Errors
  - 663Two-Phase Commit Protocol Errors
  - 664Two-Phase Commit and Logical Log Records
    - BEGPREP
    - PREPARE
    - 665TABLOCKS
    - HEURTX
    - ENDTRANS
      - The output fromtblog contains only the type eld, as follows:
    - 666Transaction Commit Records
    - 670Heuristic End-Transaction Records
  - 671Determining Database Consistency
    - 672Step 1: Determine Where a Heuristic Decision Occurred
    - 673Step 2: Determine If the Networked Database Contains Inconsistent Data
    - 674Steps 3 and 4: Decide If Correction Is Needed
    - Step 5: Use Logical Log Records
    - 675Example Manual Recovery
    - IBM Informix STAR Conguration Parameters
  - 677IBM Informix STAR Conguration Parameters
    - DEADLOCK TIMEOUT
    - TXTIME-OUT
  - 678Track a Transaction with tbstat Output
    - 679Tracking a Global Transaction
    - Transaction address Field
    - 680Transaction ag Field
    - 681Transaction user Field
    - Transaction locks Field
    - Transaction log begin
    - 682Transaction isolation Field
    - Transaction retries Field
    - Transaction coordinator Field
683A
- Appendix
- Notices
  - Trademarks
  - 686Trademarks
    - Index
- 687Index
  - A
  - B
    - 6882IBM Informix OnLine Database Server Administrators Guide
    - Index 3
  - 689C
    - 4IBM Informix OnLine Database Server Administrators Guide
  - 690D
    - Index 5
  - 691E
    - 6IBM Informix OnLine Database Server Administrators Guide
  - 692F
  - G
  - H
  - I
    - Index 7
  - 693L
    - 6948IBM Informix OnLine Database Server Administrators Guide
    - Index 9
  - 695M
    - 10 IBM Informix OnLine Database Server Administrators Guide
  - 696O
  - P
    - Index 11
  - 697Q
  - R
  - S
    - 12 IBM Informix OnLine Database Server Administrators Guide
  - 698T
    - 699Index 13
    - 14 IBM Informix OnLine Database Server Administrators Guide
  - 700U
    - Index 15
  - 701V
  - W
  - X
  - Symbols

Models

Contents