Summary of the content on the page No. 1
IBM Informix OnLine
Database Server
Administrator’s Guide
Version 5.x
December 2001
Part No. 000-8697
Summary of the content on the page No. 2
Note: Before using this information and the product it supports, read the information in the appendix entitled “Notices.” This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. When you send information to IBM, you grant IBM a nonexclusive right to use or dis
Summary of the content on the page No. 3
Table of Contents Table of Contents Introduction In This Introduction ................. 3 About This Manual.................. 3 Organization of This Manual............. 4 Demonstration Database .............. 5 IBM Informix OnLine ................. 7 Product Overview................. 7 IBM Informix OnLine and Other IBM Informix Products . . . 7 Documentation Conventions .............. 8 Typographical Conventions ............. 8 Icon Conventions................. 9 Command-Line Conventions........
Summary of the content on the page No. 4
Chapter 1 Installation and Initial Configuration In This Chapter................... 1-5 Define Your Starting Point ............... 1-6 Upgrade an Earlier Version of OnLine ......... 1-7 Overview of OnLine Installation Steps ......... 1-10 Overview of OnLine Initial Configuration Tasks ....... 1-10 OnLine Configuration Files ............. 1-11 Contents of tbconfig.std .............. 1-13 Set Up Your Initial Configuration ............ 1-20 Root Dbspace Configuration Guidelines......... 1-21 Mirroring Con
Summary of the content on the page No. 5
Chapter 2 System Architecture In This Chapter .................. 2-7 Initialization ................... 2-7 Initialization Commands ............. 2-8 What Happens During Shared-Memory Initialization . . . 2-10 What Happens During Disk-Space Initialization ..... 2-14 UNIX Kernel and Semaphore-Allocation Parameters.... 2-18 OnLine User Processes................ 2-22 How User Processes Attach to Shared Memory...... 2-24 User Processes and Critical Sections.......... 2-28 OnLine User Process Status
Summary of the content on the page No. 6
Structure of a Blobspace or Dbspace Mirror Chunk..... 2-92 OnLine Limits for Chunks ............. 2-93 Reserved Pages ................. 2-95 Chunk Free-List Page ............... 2-103 tblspace Tblspace................. 2-104 Database Tblspace ................ 2-107 Create a Database: What Happens on Disk........ 2-108 OnLine Limits for Databases............. 2-110 Create a Table: What Happens on Disk ......... 2-110 Create a Temporary Table: What Happens on Disk ..... 2-113 Structure of an Exten
Summary of the content on the page No. 7
Chapter 3 Operating OnLine In This Chapter .................. 3-5 Changing Modes.................. 3-6 Types of OnLine Modes.............. 3-6 From Offline to Quiescent ............. 3-8 From Offline to Online .............. 3-8 From Quiescent to Online ............. 3-9 Gracefully from Online to Quiescent ......... 3-10 Immediately from Online to Quiescent......... 3-11 From Any Mode Immediately to Offline ........ 3-12 Logical Log Administration .............. 3-13 Examine Your Logical Log Configu
Summary of the content on the page No. 8
If the Logical Log Files Fill During an Archive....... 3-59 If an Archive Terminates Prematurely ......... 3-60 Monitor OnLine Activity ............... 3-61 Monitor Archive History.............. 3-61 Monitor Blobs in a Blobspace ............ 3-63 Monitor Blobs in a Dbspace ............. 3-65 Monitor Buffers ................. 3-66 Monitor Buffer-Pool Activity............. 3-68 Monitor Checkpoints ............... 3-69 Monitor Chunks................. 3-70 Monitor Configuration Information ..........
Summary of the content on the page No. 9
Change the Maximum Number of Dbspaces....... 3-111 Change the Maximum Number of Locks........ 3-112 Change the Maximum Number of Tblspaces....... 3-113 Change the Maximum Number of Users ........ 3-114 Change the Number of Page Cleaners......... 3-115 Things to Avoid .................. 3-116 Chapter 4 Data Consistency, Recovery, and Migration In This Chapter .................. 4-5 Consistency Checking................ 4-6 Using the tbcheck Commands............ 4-6 Using the OnLine Message Log ...
Summary of the content on the page No. 10
Monitor and Archive Physical Log Pages ........ 4-38 Write a Trailer Page................ 4-38 Update the Reserved Pages ............. 4-38 Fast Recovery ................... 4-39 How Does OnLine Initiate Fast Recovery?........ 4-39 Fast Recovery and Logging ............. 4-40 Step 1: Checkpoint Condition ............ 4-41 Step 2: Find Checkpoint Record in Logical Log ...... 4-41 Step 3: Roll Forward Log Records........... 4-43 Step 4: Roll Back Incomplete Transactions ........ 4-44 Data Restore:
Summary of the content on the page No. 11
Chapter 5 How to Improve Performance In This Chapter .................. 5-3 Disk Layout ................... 5-4 Optimize Blobspace Blobpage Size ........... 5-5 tbcheck -pB and tbcheck -pe Utility Commands...... 5-5 Blobpage Average Fullness............. 5-7 Apply Effective Criteria.............. 5-8 Eliminate User-Created Resource Bottlenecks........ 5-8 When Is Tuning Needed?............... 5-10 % Cached Fields ................ 5-10 ovtbls, ovlock, ovuser, and ovbuff Fields........ 5-11 Bufsiz
Summary of the content on the page No. 12
Chapter 6 DB-Monitor Screens In This Chapter................... 6-3 Main Menu................... 6-4 Status Menu .................. 6-5 Parameters Menu ................ 6-6 Dbspaces Menu ................. 6-7 Mode Menu .................. 6-8 Force-Ckpt Option ................ 6-9 Archive Menu.................. 6-10 Logical-Logs Menu................ 6-11 Chapter 7 Utilities In This Chapter................... 7-5 dbexport: Unload a Database and Schema File ........ 7-5 Syntax ....................
Summary of the content on the page No. 13
tbload: Create a Database or Table............ 7-47 Syntax.................... 7-48 Specify Tape Parameters.............. 7-49 Create Options................. 7-50 tblog: Display Logical Log Contents ........... 7-51 Syntax.................... 7-51 Log-Record Read Filters.............. 7-52 Log-Record Display Filters............. 7-54 Interpreting tblog Output ............. 7-55 tbmode: Mode and Shared-Memory Changes........ 7-64 Syntax.................... 7-65 Change OnLine Mode ..............
Summary of the content on the page No. 14
tbunload: Transfer Binary Data in Page Units ........ 7-107 Syntax .................... 7-108 Specify Tape Parameters .............. 7-109 Chapter 8 OnLine Message Log In This Chapter................... 8-3 OnLine Message Log................. 8-3 Alphabetized Messages................ 8-5 Chapter 9 Product Environment In This Chapter................... 9-3 The OnLine Environment ............... 9-3 OnLine Features................. 9-3 Features Beyond the Scope of OnLine.......... 9-6 What Is Mult
Summary of the content on the page No. 15
Introduction Introduction In This Introduction .................. 3 About This Manual................... 3 Organization of This Manual.............. 4 Demonstration Database ............... 5 IBM Informix OnLine.................. 7 Product Overview.................. 7 IBM Informix OnLine and Other IBM Informix Products .... 7 Documentation Conventions ............... 8 Typographical Conventions .............. 8 Icon Conventions.................. 9 Command-Line Conventions.............. 9 Element
Summary of the content on the page No. 16
2 IBM Informix OnLine Database Server Administrator’s Guide
Summary of the content on the page No. 17
In This Introduction This introduction provides an overview of the information in this manual and describes the conventions it uses. About This Manual The IBM Informix OnLine Administrator’s Guide describes the powerful Informix online transaction processing (OLTP) database server. You do not need database management experience or familiarity with relational database concepts to use this manual. However, a knowledge of SQL (Structured Query Language) would be useful. For detailed information abo
Summary of the content on the page No. 18
Organization of This Manual Organization of This Manual This manual includes the following chapters: Chapter 1, “Installation and Initial Configuration,” provides a step- by-step explanation of OnLine database server installation and setup. The chapter includes a worksheet to assist you in planning your system and in documenting your configuration. Chapter 2, “System Architecture,” provides optional reference material about OnLine operation that is intended to deepen your understanding of OnLi
Summary of the content on the page No. 19
Demonstration Database A Notices appendix contains information about IBM products, services, and features. An index directs you to areas of particular interest. Demonstration Database Your IBM Informix OnLine software includes a demonstration database called stores5 that contains information about a fictitious wholesale sporting- goods distributor. The sample command files that make up a demonstration application are included as well. Most of the examples in this manual are based on the stores5 de
Summary of the content on the page No. 20
Demonstration Database You can run the dbaccessdemo5 script again whenever you want a fresh demonstration database to work with. The script prompts you when the creation of the database is complete and asks if you would like to copy the sample command files to the current directory. Answer “N” to the prompt if you have made changes to the sample files and do not want them replaced with the original versions. Answer “Y” to the prompt if you want to copy over the sample command files. To create and p
