TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176
Figure 5-2.. Qualifier Array Format for Locking Modes 5 and 6 . . . . . . . . . . . . . . . . . . . 208
Figure 5-3.. Lock Descriptor Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208
Figure 5-4.. Lock Descriptor Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 210
Figure 6-1.. ORDERS Database Schema Listing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 244
Figure 7-1.. Transactions and Transaction Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 315
Figure 7-2.. Suppression of Transactions Due to Inadequate Locking. . . . . . . . . . . . . . . 316
Figure 7-3.. Transferring Log Files to the Secondary System . . . . . . . . . . . . . . . . . . . . . 365
Figure 8-1.. DBUNLOAD File: Sequence of Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 416
Figure 9-1.. Using a Remote Program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459
Figure 9-2.. Using Method 1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 460
Figure 9-3.. Using Method 2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 461
Figure 9-4.. Using Method 3. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 462
Figure 9-5.. Preparing a Database-Access File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 468
Figure 9-6.. Using a Database-Access File. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 469
Figure 10-1.. Media Record for Detail Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 473
Figure 10-2.. Media Record for Primary Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 473
Figure 10-3.. Media Record for Secondary Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 474
Figure 10-4.. Block with Blocking Factor of Four . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475
Figure 10-5.. Independent Sub-Databases for Concurrency. . . . . . . . . . . . . . . . . . . . . . . 479
Figure B-1.. Actions Resulting from Multiple Access of Databases . . . . . . . . . . . . . . . . . 640
Figure C-1.. Selected Prime Numbers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 643