TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

Figures
19
Figure 1-1.. How to Use TurboIMAGE/XL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Figure 2-1.. CUSTOMER Data Set Sample. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
Figure 2-2.. Master and Detail Data Set Relationships . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Figure 2-3.. Master and Detail Data Sets Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Figure 2-4.. Adding Entries to a Sorted Chain . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45
Figure 2-5.. ORDERS Data Sets and Paths. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
Figure 2-6.. A Sample Entry for Each Data Set in the ORDERS Database . . . . . . . . . . . 47
Figure 2-7.. Granting Capability to User Class 11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
Figure 2-8.. Security Flowchart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
Figure 3-1.. Database Definition Process. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
Figure 3-2.. Sample Schema Creation Session . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80
Figure 3-3.. Schema Processor Batch Job Stream. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
Figure 3-4.. Data Set Summary Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
Figure 3-5.. ORDERS Database Schema ORDERS Database Schema . . . . . . . . . . . . . . . 89
Figure 4-1.. Sample Data Entries from ORDERS Database. . . . . . . . . . . . . . . . . . . . . . . 103
Figure 4-2.. Reading Access Methods (DBGET Procedure) . . . . . . . . . . . . . . . . . . . . . . . 106
Figure 4-3.. Lock Descriptor List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119
Figure 5-1.. Sample DBEXPLAIN Messages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177
Figure 5-2.. Qualifier Array Format for Locking Modes 5 and 6 . . . . . . . . . . . . . . . . . . . 209
Figure 5-3.. Lock Descriptor Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209
Figure 5-4.. Lock Descriptor Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211
Figure 6-1.. ORDERS Database Schema Listing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246
Figure 7-1.. Transactions and Transaction Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 317
Figure 7-2.. Suppression of Transactions Due to Inadequate Locking. . . . . . . . . . . . . . . 318
Figure 7-3.. Transferring Log Files to the Secondary System . . . . . . . . . . . . . . . . . . . . . 367
Figure 8-1.. DBUNLOAD File: Sequence of Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 418
Figure 9-1.. Using a Remote Program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 465
Figure 9-2.. Using Method 1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 466
Figure 9-3.. Using Method 2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 467
Figure 9-4.. Using Method 3. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 468
Figure 9-5.. Preparing a Database-Access File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 474
Figure 9-6.. Using a Database-Access File. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475
Figure 10-1.. Media Record for Detail Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 479
Figure 10-2.. Media Record for Primary Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 479
Figure 10-3.. Media Record for Secondary Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 480
Figure 10-4.. Block with Blocking Factor of Four . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 481
Figure 10-5.. Independent Sub-Databases for Concurrency. . . . . . . . . . . . . . . . . . . . . . . 485
Figure B-1.. Actions Resulting from Multiple Access of Databases . . . . . . . . . . . . . . . . . 650
Figure C-1.. Selected Prime Numbers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 653