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