Index [ TurboIMAGE/XL Database Management System Reference Manual ] MPE/iX 5.0 Documentation
TurboIMAGE/XL Database Management System Reference Manual
Index
A
abnormal termination of a procedure
abort
and recovery
conditions
ABORTS parameter, of DBRECOV
absent list
versus null list
access
calculated
chained
class password, modifying
concurrent modes
creator-only
directed
disable
enable
exclusive
granting
modes
modes and user class number
none
option
path
read
rules
semi-exclusive
serial
update
write
access modes
and critical item update
and database operations
and locking/unlocking
and logging
and user class number
concurrent
selecting
ACCESS option, of DBUTIL
account
manager
member
protection
ACTIVATE command, of DBUTIL
activate DBA file
actual file designators
adding entries
coordinating calls
data
prefetching data
sequence for
to detail data sets
to master data sets
address, primary
administrator, database
algorithms, primary address calculation
ALLBASE/Turbo CONNECT product
ALL option, of DBUTIL
ALTLOG command, of MPE/iX
ampersand, continuation record
array
ASCII characters
at-sign in DBA file
audit trail
AUTODEFER option, of DBUTIL
disabling
enabling
automatic master
standalone
B
backup
copies
files
BBASIC
and complex numbers
and decimal numbers
bit map
block
and bit maps
definition of
blocking factor
BLOCKMAX option, of $CONTROL
broken chains
message returned
buffer
length
management
specifications
BUFFSPECS option, of DBUTIL
BUILD command, of MPE/iX
byte
C
C
sample program
calculated access
reading data
calling errors
call statements
BBASIC
C
COBOL II
FORTRAN 77
Pascal
procedure
capacity
definition of
detail data set
expansion
initial
master data set
maximum
show
CCE
CCG
CCL
chain
data
definition of
head
sorted
synonym
chained access
and current path
and locking
CHANGELOG command, of MPE/iX
changing data item values
checking
status of a procedure
the subsystem flag
CIUPDATE option, of DBUTIL
and application design
and DBINFO mode 502
disabling
enabling
settings
updating data
class lists
read and write
class number, user
cleanup mode, MPE/iX
closing
a data set
the database
COBOL II
sample program
COMMAND intrinsic, of MPE/iX
commands, Schema Processor
comments in schema
communication area of DBG
communications link, remote session
complex numbers
compound data items
concurrent access modes
conditional
locking
locks
condition code
CCE
CCG
CCL
continuation records
Schema Processor
$CONTROL
control blocks, database
Buffer Area (DBB)
Globals (DBG)
MPE V versus MPE/iX
overview of
Remote (DBR)
size of
System (DBS)
User Local (DBU)
User Local Index (DBUX)
CONTROL command
of DBRECOV
of Schema Processor
control, exclusive
conventions
database description language
model program
copying data entries to formatted tape
copying entire database
from backup volumes
to disk
to tape
correspondence of backup copy and log file
CREATE command, of DBUTIL
creating
a database
the text file
creator, database
creator-only access
critical items
detail search item
detail sort item
master key item
critical item update
critical mode
current path
and DBGET
definition
number and DBFIND
current record
number and DBFIND
rereading
D
data
chain
entries
files
integrity
names
prefetching
reading
database
access mode and user class number
access modes
access modes summary
accessor
adding entries
administrator
administrator, access to log file
attached to a DBEnvironment
backup copy
backup copy, flags
closing the
concurrent access modes
consistency
control blocks
creating
creator
creator, definition of
creator's logon group
definition language
definition of
description language, conventions
designer
detaching from a DBEnvironment
elements
entering data
exclusive control
manager
name, syntax
opening the
personnel
protection
recovery options
remote
restructure
security
statistics
storing
structure
structure, obtaining information
terminating access
utilities
database access
creator-only
none
read
types of
update
write
database-access (DBA) file
activate
activating
content
creating
deactivate
deactivating
name
reporting
syntax rules
syntax verification
using
Database Buffer Area Control Block (DBB)
allocating buffers
Database Globals Control Block (DBG)
database restructuring
supported structural changes
unsupported structural changes
Database System Control Block (DBS)
Database User Local Control Block (DBU)
Database User Local Index Control Block (DBUX)
data entry
and access mode
and user class number
deleting
length
locking
numbers
sequence for adding
data item
compound
definition of
identifiers
length
maximum
numbers
obtaining information about
packed
read access
security
types
update access
validating, checking
values, viewing
data set
automatic master
capacity
closing the
creating
definition of
detail
identified
identifiers
initializing
location
locking
manual master
master
maximum capacity
naming conventions
purging
reinitializing
relationships
rewinding
security
size
space allocation
storage
summary table
summary table information
types
write list
data set, detail
adding entries to
deleting
updating search and sort item values
data set, master
adding entries to
deleting
data types
designators
IEEE
DBB
allocating buffers
use of
DBBEGIN
calling sequence
description
errors
DBChange Plus
DBCLOSE
calling sequence
description
errors
DBCONTROL
and AUTODEFER option
and CIUPDATE option
calling sequence
description
errors
DBDELETE
calling sequence
description
errors
DBEND
calling sequence
description
errors
mode 1 option
mode 2 option
special, and logging
DBERROR
calling sequence
description
messages
DBEXPLAIN
calling sequence
description
messages
DBFIND
calling sequence
current path number
current record number
description
errors
DBGET
calling sequence
current path
description
errors
primary path
DBG, use of
DBINFO
and CIUPDATE option
and dynamic transactions
and logging facility
and Native Language Support
calling sequence
description
errors
mode 402, MPE V versus MPE/iX
special uses of
DBLOAD utility
DBLOCK
calling sequence
description
errors
multiple calls
DBMEMO
calling sequence
description
errors
DBOPEN
calling sequence
description
errors
logging
modes
DBPUT
calling sequence
description
errors
logging
DBRECOV utility
ABORT option
PURGE option
record table
RESTART option
STOP-RESTART feature
DBRECOV utility commands
CONTROL
EXIT
FILE
PRINT
RECOVER
ROLLBACK
RUN
DBRESTOR utility
DBSCHEMA
DBSCHEMA, Schema Processor
and uppercase characters
DBSTORE flag
override
DBSTORE utility
TRANSPORT option
DBS, use of
DBTABLE option, of DBRECOV
DBUNLOAD utility
and broken chains
DBUNLOCK
calling sequence
description
errors
DBUPDATE
and CIUPDATE option
calling sequence
description
errors
locking
logging and locking
DBUTIL utility
ACCESS option
AUTODEFER option
CIUPDATE option
DUMPING option
ILR option
INDEXING option
LOGGING option
MUSTRECOVER option
PREFETCH option
RECOVERY option
ROLLBACK option
DBUTIL utility commands
ACTIVATE
CREATE
DEACTIVATE
DISABLE
ENABLE
ERASE
EXIT
HELP
MOVE
PURGE
RELEASE
SECURE
SET
SHOW
VERIFY
DBU, use of
DBUX, use of
DBXBEGIN
calling sequence
description
errors
DBXEND
calling sequence
description
errors
mode 1 option
mode 2 option
special, and logging
DBXUNDO
calling sequence
description
errors
mode 1 option
mode 2 option
special, and logging
DEACTIVATE command, of DBUTIL
deadlocks
prevention
debugging
and DBERROR
and DBEXPLAIN
with I and J files
decimal numbers
default
options of $CONTROL command
read access
recovery mode
defaults for CONTROL command, of DBRECOV
deferred output
defining database security
delete chain
deleting
data
data entries
entries
deleting entries
coordinating calls
prefetching data
description language conventions
design considerations
designer, database
detail data set
adding entries to
deleting
media records
search items
search items, and master key item
space allocation
device
class, assigning the
list
DEVICE option, of DBUTIL
directed access
and locking
reading data
disable
access
AUTODEFER
dumping
flags
ILR
indexing
logging
MUSTRECOVER
PREFETCH
recovery
ROLLBACK
DISABLE command, of DBUTIL
display DBUTIL commands
displaying information
about locks
about the database
Distributed Systems (DS/3000)
dset array, of DBFIND
DSLINE command
in database-access file
DS user identification
dummy parameters
dumping
disable
enable
DUMPING option, of DBUTIL
show
dynamic
capacity See capacity, expansion
database transactions
locking
dynamic roll-back recovery
quick reference
dynamic transactions
and locking
E
enable
access
AUTODEFER
dumping
flags
ILR
indexing
logging
MUSTRECOVER
PREFETCH
recovery
ROLLBACK
ENABLE command, of DBUTIL
enabling user class to perform a task
entering data in the database
entries
migrating secondaries
primary
secondary
EOF parameter, of DBRECOV
ERASE command, of DBUTIL
erasing the database, and logging
error messages
errors
calling
DBBEGIN
DBCLOSE
DBCONTROL
DBDELETE
DBEND
DBFIND
DBGET
DBINFO
DBLOCK
DBMEMO
DBOPEN
DBPUT
DBUNLOCK
DBUPDATE
DBXBEGIN
DBXEND
DBXUNDO
interpreting
library procedures
Schema Processor
ERRORS option (DBSCHEMA)
ERRORS parameter, of DBRECOV
excluding user classes
exclusive access
EXIT command
of DBRECOV
of DBUTIL
expansion recovery
extended sort field
extended utility program
unconditional error messages
extents, file
F
failure
media
system
to recover transactions
file
data
designators, actual
designators, formal
errors, Schema Processor
name
FILE command, of DBRECOV
FILE command, of MPE
in database-access file
FILE command, of MPE/iX
FILETABLE option, of DBRECOV
flags
checking the subsystem
database backup copy
DBSTORE
disable
displaying
enable
logging
logging preparation
setting subsystem
FLAGS option, of DBUTIL
floating-point numbers
and data types
flowchart, security
formal file designators
FORTRAN 77
and complex numbers
sample routines
full data access
G
GETLOG command, of MPE/iX
granting a user class access
group
protection
user
H
halfword
HELP command, of DBUTIL
high-water mark
host language access
HP Sort
HWMPUT
I
I and J files
identifiers, data item
identifying users
IEEE data types
I file, debugging
ILR option, of DBUTIL
disable
enable
quick reference
increment
INDEXING option, of DBUTIL
indexing, third-party
disable
enable
information, database structure
initializing data sets
integers
integrity
interactive locking
internal
structures and techniques
techniques
interpreting errors
Intrinsic Level Recovery
MPE V versus MPE/iX
quick reference
intrinsic numbers
intrinsics
and database names
and data item names
and data set names
DBBEGIN
DBCLOSE
DBCONTROL
DBDELETE
DBEND
DBERROR
DBEXPLAIN
DBFIND
DBGET
DBINFO
DBLOCK
DBMEMO
DBOPEN
DBPUT
DBSTORE
DBUNLOCK
DBUPDATE
DBXBEGIN
DBXEND
DBXUNDO
summary of
invalid password
item part, schema
J
J file, debugging
K
key item
adding entries
defined as critical item
updating values
L
language
conventions
native
native, defined
LANGUAGE option, of DBUTIL
languages, programming
call statements
examples of
library procedures
abort condition messages
calling error messages
error messages
exceptional condition messages
file system and memory management error messages
summary of
LINES option, of $CONTROL
list
absent
null
list file
Schema Processor
LISTLOG command, of MPE/iX
LIST option
and $PAGE command
of $CONTROL
lock area
lock descriptors
array, format of
sort sequence
locking
accessor entries
and dynamic transactions
and transactions
choosing a level
choosing an item
conditional
descriptor entries
facility, examples of
levels
requirements
same level
set entries
strong
unconditional
locking/unlocking
access modes
and chained access
and DBUPDATE
and direct access
and logging
and serial access
and transaction length
conditional
deadlocks
deciding on a strategy
during user dialog
dynamic
examples of
interactive dialog
internals
internal tables
issuing multiple locks
levels
overview
performance
release
remote databases
shared access
unconditional
LOCKS option, of DBUTIL
locks, showing
LOG command, of MPE/iX
log file
building
size, determining
time stamps
logging
acquiring capability
and access modes
and locking
and process suspension
CHANGELOG capability
checking MPE/iX configuration
considerations
cycle
cycle, sample job stream
DBCLOSE
DBDELETE
DBOPEN
DBPUT
DBSTORE flag
device, quick reference
disable
displaying status
enable
erasing the database
flags
flags and database backup copy
format records
initiating process
intrinsics
maintaining
overview
preparation
process, controlling
quick reference
re-enabling
special DBEND
special DBXEND
special DBXUNDO
statistics
time stamp
to disk
to disk, quick reference
to tape
to tape, quick reference
Transaction Management
transaction numbers
user
what it does
logging and recovery database utilities
summary
logging DBUPDATE and locking
LOGGING option, of DBUTIL
logical transaction
and locking
definition of
log identifier
creating
setting in root file
LOGID option, of DBUTIL
LOGINFO option, of DBUTIL
logon group, database creator
log records
file reference
fmode
formats, MPE/iX
formats, TurboIMAGE/XL
rmode
user reference
M
magnetic tape
maintenance word
changing or removing
MAINT option, of DBUTIL
making a database backup copy
manager, database
manual master
mapped files, privileged
master data set
adding entries to
automatic
deleting
index
manual
media records
space allocation for
master key item
and detail search items
maximum
data items
data set capacity
records in data set
MDBX parameter, of DBRECOV
media records
memory management error messages
messages
DBERROR
DBEXPLAIN
methods, remote database-access
migrating secondaries
entries
mirror database
MODE4 parameter, of DBRECOV
model program
conventions
ORDERS database
modes, access
and critical item update
and database operations
and locking/unlocking
and logging
and user class number
concurrent
selecting
MODEX parameter, of DBRECOV
MOVE command, of DBUTIL
moving
files across devices
from MPE/iX to MPE V
to TurboIMAGE/XL
MPE/iX
account and logon group
cleanup mode
COMMAND intrinsic and DS
disk files
log record formats
security
subsystem, HP Sort
WRITELOG records
MPE/iX commands
ALTLOG
BUILD
CHANGELOG
FILE
GETLOG
LISTLOG
LOG
RELLOG
RESTORE
SHOWLOGSTATUS
STORE
SYSGEN
MR capability
multiple
access
database transactions
RIN capability
MUSTRECOVER option, of DBUTIL
disable
enable
N
names
data
database, syntax
data set
Native Language Support (NLS)
Network Services (NS/3000)
nibble
NOABORTS parameter, of DBRECOV
no access
data item
data set
NOLIST option, of $CONTROL
NOMDBX parameter, of DBRECOV
NOROOT option, of $CONTROL
NOSTAMP parameter, of DBRECOV
NOSTATS parameter, of DBRECOV
NOSTORE parameter, of DBRECOV
NOTABLE option, of $CONTROL
NOUNEND parameter, of DBRECOV
null
password
read/write class lists
null list
versus absent list
numbers, data item
O
opening
database more than once
the database
ORDERS database
model program
schema
output
deferred
Schema Processor
overview, TurboIMAGE/XL
P
packed types, uses of
$PAGE
PAGE command, of Schema Processor
parameters
and halfword boundaries
procedure
unused
Pascal
sample routines
password
access class, modifying
database creator
invalid
null
part, schema
semicolon
syntax
PASSWORD option, of DBUTIL
paths
access
current
obtaining information about
primary
performance analysis, TurboIMAGE/XL
pointers
data set
definition of
post-recovery options
PREFETCH option, of DBUTIL
disable
enable
primary address
calculation
primary entries
primary path
DBGET procedure
prime numbers
PRINT command, of DBRECOV
private volume
privileged file protection
procedure
abnormal termination
calls, status information
call statements
error messages
parameters
status, checking
procedures, summary of
process
statistics, recovery program
suspension, logging and
program aborts and recovery
dynamic roll-back
programming languages
call statements
compatibility mode
examples of
native mode
program, model
programs, executable
C
COBOL II
RPG
protection
account
database
group
library procedure
privileged file
utilities
PURGE command, of DBUTIL
purging the database
Q
QUERY/3000
data types
definition of
remote database access
quick reference, logging and recovery
logging device
recovery options
sample job streams
R
read access
default
read and write class lists
excluding user classes
schema
reading
methods
the data
reading data
calculated access
chained access
directed access
serial access
real numbers
and data types
records
in data set, maximum
media
rereading
size
record table, of DBRECOV
RECOVER command, of DBRECOV
recovering
the database
recovery
and dynamic transactions
considerations
CONTROL command, of DBRECOV
DBRECOV STOP-RESTART
determining success of
disable
disabling roll-back
dynamic roll-back
enable
enabling roll-back
enabling roll-forward
FILE command, of DBRECOV
files
MPE/iX cleanup mode
multiple database transactions
overview
performing DBRECOV STOP-RESTART
performing roll-back recovery
performing roll-forward recovery
post-recovery options
PRINT command, of DBRECOV
quick reference
record numbers
RECOVER command, of DBRECOV
roll-back time stamp
roll-forward
RUN command, of DBRECOV
statistics
stream file
tables
transferring log files
recovery files
statistics
recovery mode, default
RECOVERY option, of DBUTIL
recovery options
default mode
dynamic roll-back
ILR
roll-back
roll-forward
reinitialize data sets
RELEASE command, of DBUTIL
releasing locks
releasing the database
RELLOG command, of MPE/iX
remote
database locking
session, communications link
remote database access
IMAGE/3000 and TurboIMAGE/XL
local application
logon identification
methods
referencing
TurboIMAGE/V and TurboIMAGE/XL
using QUERY/3000
Remote Database Control Block (DBR)
rereading data
resetting data sets
Resource Identification Number (RIN)
RESTART option, of DBRECOV
RESTORE command, of MPE/iX
restoring from database backup copy
return status
rewinding data sets
RIN
ROLLBACK command, of DBRECOV
ROLLBACK option, of DBUTIL
disable
enable
roll-back recovery
disabling
dynamic
performing
quick reference
roll-forward recovery
quick reference
root file
purging
ROOT option, of $CONTROL
RPG
sample program
RUN command, of DBRECOV
S
sample database, ORDERS
sample job stream
recovery
recovery and logging
roll-back recovery
roll-forward recovery
starting logging cycle
sample programs
C
COBOL II
RPG
sample routines
FORTRAN 77
Pascal
schema
changes
comments
definition of
for ORDERS database
item part
password part
set part (details)
set part (masters)
structure
syntax errors
Schema Processor
command error messages
commands
continuation records
creating the text file
DBSCHEMA
definition of
errors
example
file error messages
list file
messages
operating instructions
output
root file
summary information
syntax error messages
text file
Schema Processor commands
$CONTROL
$PAGE
syntax
$TITLE
search items
adding entries
creating
defined as critical items
design considerations
number per detail
updating values
secondary
address
entries
entries, deleting data
SECURE command, of DBUTIL
securing the database
security
database, defining
data item
data set
flowchart
passwords
provisions, MPE/iX
user classes
security, file system
releasing
securing
selecting the block size
semi-exclusive access
sequence for adding entries
sequence of entries, DBUNLOAD
serial access
and locking
reading data
SET command, of DBUTIL
set part
details
masters
set part (details), schema
set part (masters), schema
sharing database
show
capacity
locks
SHOW command, of DBUTIL
SHOWLOGSTATUS command, of MPE/iX
sorted
chains
entries, maintenance of
sort items
defined as critical items
design considerations
updating values
sort sequence for lock descriptors
space allocation for
detail data sets
master data sets
special capability
multiple RIN
STAMP parameter, of DBRECOV
start recovery operation
STATS parameter, of DBRECOV
status area
information
information and multiple access
information, procedure calls
MPE V versus MPE/iX
register
status array
STOPTIME parameter, of DBRECOV
storage
location
unit
STORE command, of MPE/iX
STORE parameter, of DBRECOV
storing entire database
strong locking
sub-items
count
length
subsystem flag
checking
setting
SUBSYSTEMS option, of DBUTIL
summary
data set table, Schema Processor
description
information
of database access modes
of data types
of library procedures
of logging and recovery utilities
table description
synonym chain
synonyms
syntax
errors, Schema Processor messages
Schema Processor commands
SYSGEN command, of MPE/iX
system
failures
manager
T
TABLE option, of $CONTROL
tables, recovery
terminal read
and locking
and logical transactions
text file
Schema Processor
third-party indexing
disable
enable
purging
releasing
securing
time stamp
database
log records
$TITLE
TITLE command, of Schema Processor
TPI
disable
enable
purging
releasing
securing
transaction
block
dynamic, defined
logging
logical, defined
multiple database, defined
numbers, logging
static, defined
Transaction Management, of MPE/iX
transactions
definition
dynamic
multiple database
static
TRANSACT/V
TRANSPORT option, of DBSTORE
TurboIMAGE/V versus TurboIMAGE/XL
TurboIMAGE/XL
effect on programs
overview
type designators
and programming languages
table of
types, data
summary
uses of
U
unconditional locking
UNEND parameter, of DBRECOV
unrecoverable
disk
tape
unused parameters
update access
and critical item update
disallowed
updating
data item values
search item values
sort item values
updating data
access modes, user class number
CIUPDATE option
key items
search and sort items
updating values
of search items
of sort items
upshifting, by DBSCHEMA
user access
user classes
empty
locking
user class number
deleting data
opening the database
setting
updating data
user file label
user logging
and logical transactions
how it works
intrinsics
intrinsics, calling sequence
users, identifying
USERS option, of DBUTIL
user type
AC
GU
utilities
conditional error messages
DBLOAD
DBRECOV
DBRESTOR
DBSTORE
DBUNLOAD
DBUTIL
executing
operation
protection
unconditional error messages
V
validity checking, data item
VERIFY command, of DBUTIL
viewing data item values
volume
private
W
word
write access
disallowed
write class list
WRITELOG records, MPE/iX
MPE/iX 5.0 Documentation