TurboIMAGE/XL Database Management System Reference Manual (30391-90012)
Table Of Contents
- 1 Introduction
- 2 Database Structure and Protection
- 3 Defining a Database
- 4 Using the Database
- 5 TurboIMAGE/XL Library Procedures
- Using TurboIMAGE/XL Intrinsics
- DBBEGIN
- DBCLOSE
- DBCONTROL
- DBDELETE
- DBEND
- DBERROR
- DBEXPLAIN
- DBFIND
- DBGET
- DBINFO
- INTRINSIC NUMBER 402
- Syntax
- Parameters
- Discussion
- Mode 101: Item Number
- Mode 102: Item Name
- Mode 103: Items in Database
- Mode 104: Items in Data Set
- Mode 113: BTREEMODE1 and Wildcard Character
- Mode 201: Set Number
- Mode 202: Set Name
- Mode 203: Sets in Database
- Mode 204: Sets with Item
- Mode 205: Set Capacity
- Mode 206: Number of Data Set Chunks
- Mode 207: Size of Data Set Chunks
- Mode 208: Primary and Actual Capacity
- Mode 209: B-Tree Attachment
- Mode 301: Paths
- Mode 302: Key or Search Item
- Mode 401: Logging
- Mode 402: ILR
- Mode 403: Dynamic Roll-Back
- Mode 404: Logging Subsystem Information
- Mode 406: Database Information
- Mode 501: Subsystem Access
- Mode 502: Critical Item Update
- Modes 8nn: Third-Party Indexing
- Mode 901: Language
- DBLOCK
- DBMEMO
- DBOPEN
- DBPUT
- DBUNLOCK
- DBUPDATE
- DBXBEGIN
- DBXEND
- DBXUNDO
- 6 Host Language Access
- Model Program
- ORDERS Database Model Program
- Main Body of Program
- Opening the Database
- Retrieving All the Records on a Chain (with Item Level Locking)
- Retrieving a Data Entry Using a Record Number
- Retrieving Master Data Using a Key Value
- Retrieving Data Serially (with Set Level Locking)
- Adding an Entry
- Updating an Entry
- Deleting an Entry
- Rewinding a Data Set
- Obtaining Database Information
- Obtaining Error Messages and Explanations
- Closing the Database
- C
- COBOL II
- Defining Data Types, Variables, and Intrinsics
- Main Body of Program
- Opening the Database
- Retrieving All the Records on a Chain (with Item Level Locking)
- Retrieving a Data Entry Using a Record Number
- Retrieving Master Data Using a Key Value
- Retrieving Data Serially (with Set Level Locking)
- Adding an Entry
- Updating an Entry
- Deleting an Entry
- Rewinding a Data Set
- Obtaining Database Information
- Obtaining Error Messages and Explanations
- Closing the Database
- FORTRAN 77
- Pascal
- RPG
- 7 Logging and Recovery
- Database Utilities Used in Logging and Recovery
- Recovery Options
- Logical Transactions
- Dynamic Roll-Back Recovery
- Intrinsic Level Recovery
- Logging Preparation
- Step 1--Checking MPE/iX Logging Configuration
- Step 2--Acquiring Logging Capability
- Step 3--Logging to Tape or Disk
- Step 4--Building a Log File for Logging to Disk
- Step 5--Creating the Log Identifier
- Step 6--Setting the Log Identifier
- Step 7--Setting Flags for the Database Backup Copy
- Step 8--Making a Database Backup Copy
- TurboSTORE/iX 7x24 True-Online Backup
- Logging Status
- Logging Maintenance
- Roll-Forward Recovery
- Roll-Back Recovery
- DBRECOV Commands Used with Roll-Forward and Roll-Back Recovery
- Recovery Tables
- Post-Recovery Options
- The Mirror Database
- 8 Using the Database Utilities
- Restructuring the Database with TurboIMAGE/XL Utilities
- Summary of Utility Routines
- Utility Program Operation
- DBLOAD
- DBRECOV
- >CONTROL
- >EXIT
- >FILE
- >RECOVER
- >ROLLBACK
- >RUN
- DBRESTOR
- DBSTORE
- DBUNLOAD
- DBUTIL
- >>ACTIVATE
- >>ADDINDEX
- >>CREATE
- >>DEACTIVATE
- >>DETACH
- >>DISABLE
- >>DROPINDEX
- >>ENABLE
- >>ERASE
- >>EXIT
- >>HELP
- >>MOVE
- >>PURGE
- >>REBUILDINDEX
- >>REDO
- >>RELEASE
- >>SECURE
- >>SET
- >>SHOW
- Syntax
- Parameters
- Example (Show Users)
- Example Discussion
- Example (Show All)
- Example Discussion
- Example (Show Capacity)
- Format of Show Device List
- Example (Show Device)
- Format of Show Indices
- Example (Show Indices)
- Format of Show Locks List
- Example 1 (Show Locks)
- Example 1 Discussion
- Example 2 (Show Locks)
- Example 2 Discussion
- >>VERIFY
- 9 Using a Remote Database
- 10 Internal Structures and Techniques
- 11 B-Tree Indices
- A Error Messages
- B Results of Multiple Access
- C Database Design Considerations
- D Multiple Calls to DBLOCK
- E TurboIMAGE/XL Log Record Formats
- F MPE/iX Log Record Formats
- G Recovery and Logging Quick Reference
- H TurboIMAGE/XL versus TurboIMAGE/V
Index
Index 701
overview, 312
performing DBRECOV STOP-RESTART, 369
performing roll-back recovery, 356
performing roll-forward recovery, 350
post-recovery options, 365
PRINT command, of DBRECOV, 361
quick reference, 669
record numbers, 395
RECOVER command, of DBRECOV, 361
roll-back time stamp, 355
RUN command, of DBRECOV, 357, 362
statistics, 395, 404
statistics files, 363
stream file, 353
tables, 363
transferring log files, 366
RECOVERY option, of DBUTIL, 428, 432
recovery options, 312
default mode, 312
dynamic roll-back, 313, 321
ILR, 313, 323
roll-back, 313, 354
roll-forward, 313, 346
REDO command, of DBUTIL, 445
redoing the command, 445
reinitialize data sets, 435
RELEASE command, of DBUTIL, 446
releasing
the database, 446
RELLOG command, of MPE/iX, 327
remote
database locking, 658
session, communications link, 466
remote database access, 492
IMAGE/3000 and TurboIMAGE/XL, 465
local application, 465
logon identification, 470
methods, 465
referencing, 473
TurboIMAGE/V and TurboIMAGE/XL, 465
using QUERY/3000, 476
Remote Database Control Block (DBR), 492
Resource Identification Number (RIN), 655
RESTART option, of DBRECOV, 389
restoring from database backup copy, 347
RIN, 655
ROLLBACK command, of DBRECOV, 402
ROLLBACK option, of DBUTIL, 428, 432
disable, 428
enable, 432
roll-back recovery, 313, 402
disabling, 356
dynamic, 313, 321
performing, 356
quick reference, 672
roll-forward recovery, 313, 400
quick reference, 671
root file
purging, 441
with B-Tree index, 505
RUN command, of DBRECOV, 404
run-time control blocks, 490
S
sample job stream
recovery, 674
recovery and logging, 674
roll-back recovery, 676, 680
roll-forward recovery, 675, 679
starting logging cycle, 675, 678
scalability, 485
schema
changes, 380
syntax errors, 527
Schema Processor
command error messages, 525
file error messages, 523
list file, 522
messages, 522
root file, 522
syntax error messages, 527
text file, 522
search items
B-Tree indices, 501
design considerations, 651
trailing-@, 502
updating values, 451
secondary
address, 480
entries, 480
SECURE command, of DBUTIL, 447
securing the database, 447
security
file system releasing, 446
file system securing, 447
semaphores, 485
sequence
of DBUNLOAD entries, 418
SET command, of DBUTIL, 448
sharing database, 649
show
capacity, 458
locks, 459
SHOW command, of DBUTIL, 453