IBM 000-8697 - page 536

7-58 IBM Informix OnLine Database Server Administrator’s Guide

Interpreting tblog Output

BFRMAP blobfree map change tblspaceid

bpageno

status

logid

hexadecimal

USED/FREE

decimal

hexadecimal

BLDCL buildtblspace tblspaceid

fextsize

nextsize

rowsize

ncolumns

hexadecimal

decimal

BSPADD add blobspace blobspacename ASCII

BTCPYBCK copybackchild key to

parent tblspaceid

parentlogical page

childlogical page

slot

rowoff

keynumber

hexadecimal

decimal

BTMERGE mergeB+ tree nodes tblspaceid

parentlogical page

leftlogical page

rightlogical page

leftslot

leftrowoff

rightslot

rightrowoff

keynumber

hexadecimal

decimal

Type Contents Additional Columns Format

(2 of 7)

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