Index [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
Index
Special characters
*
implications for ALTER TABLE
A
accessing a DBEnvironment
access mode
change for DBEFiles
display for DBEFiles
single user and multiuser
access plan
displayed in SYSTEM.PLAN view
ADD DBEFILE
example
expanding DBEFileSet with
in SQLMigrate
syntax
when to use
adding
column
constraint
ADDLOG
command creating log file
command in SQLUtil
ADD TO GROUP
example
syntax
AliasDB file
ALLBASE/NET
connecting to remote databases
ALLBASE/SQL command size
ALTDBE
syntax
ALTER authority
explained
ALTER DBEFILE
ALTER TABLE
example
when to use
applications
dynamic recompile
maintenance
modifying
stored sections in
validation of sections
archive checkpoint record
creating with COMMIT ARCHIVE
defined
archive logging
calculating log file size
explained
wrapperDBE
archive mode
setting in DBECon file
assigning a default DBEFileSet
assigning pages
to data buffer
to DBEFiles
to log buffer
to runtime control block buffer
ATTACHFILE
attaching a file
SQLUtil
syntax
attribute
as a column in a table
defined
audit
elements changing
elements parameter
functionality
information wrapperDBE
logging in effect
logging parameter
log record
name parameter
parameter
parameters for wrapperDBE
syntax
tool wrapperDBE
audit DBE
creating
example
parameter
audit tool
exit from SQLAudit
exit on error
generate audit information
get current audit point
help command
invoke editor from SQLAudit
lock current audit point
modify current audit point
quit SQLAudit
set
set connect to DBEnvironment
set echo command
set editor command
set recoverfile command
show current audit point
unlock audit point
authority
basic types
defined
EXECUTE in SYSTEM.PROCAUTH
for SQL statements
grantable privilege
granting
in SYSTEM.TABAUTH
module related
OWNER
REFERENCES in SYSTEM.COLAUTH
revoking
RUN in SYSTEM.MODAUTH
space
special
special in SYSTEM.SPACEAUTH
special in SYSTEM.SPACEDEFAULT
SPECIAL in SYSTEM.SPECAUTH
table and view
TABLE in SYSTEM.TABAUTH
UPDATE in SYSTEM.COLAUTH
verification
authorization group
as owner
characteristics
CONNECT authority for
delegating management of
determining membership
entries in SYSTEM.GROUP
indirect member
invalid chain
management
resource authority for
authorize once per session
changing in SQLUtil
in DBECon file
setting with SQLUtil
startup value
autostart mode
and user mode
changing in SQLUtil
defined
displaying with SQLUtil
procedures
setting in DBECon file
B
backup
creating with SQLUtil STORE
creating with SQLUtil STOREONLINE
displaying type set in SQLUtil
of DBEnvironment
online procedures with archive logging
overview
procedures with nonarchive logging
SET BACKUP in SQLUtil
SQLUtil STORE
SQLUtil STOREONLINE PARTIAL
SQLUtil STORE PARTIAL
backward migration
base table
in the system catalog
view underlying
BEGIN ARCHIVE
with archive log files
BINARY
defining columns as
storage requirements
B-tree
buffer
data
log
runtime control block
C
calculations
database storage
directory overhead for tables
disk space for indexes
disk space for tables
index key length
number of index leaf pages
number of index non-leaf pages
number of overhead index pages
pages per table
page table page for tables
row length
rows per data page
rows per index leaf page
rows per index non-leaf page
size of nonarchive log files
total number of index pages
catalog
system
CATALOG
reserved user
views owned by
CCOUNT
in maintaining indexes
CHANGELOG
changing log file
SQLUtil
syntax
changing
a table's lock mode
audit elements
log file with CHANGELOG
system table lock type
CHAR
defining columns as
storage requirements
check constraint
DBEFileSet specification
entries in SYSTEM.CHECKDEF
entries in SYSTEM.CONSTRAINT
checkpoint
and log file space
archive checkpoint record
using to monitor log file usage
CHECKPOINT
host variable
parameter
SQLUtil
class
as owner
created implicitly
creating
defining
differences from DBEUserID and group
guidelines for creating
cleanup
with monitor
cluster count
in maintaining indexes
clustering index
changing a key
creating
defined
design
guidelines for
when to create
collision of two keys
column
adding
defining data types for
definition
definitions stored in the system catalog
deleting
maximum length
maximum number of
minimum number
naming
null values for
renaming
size
UPDATE authority in system catalog
command files
creating with SQLGEN
in loading tables
uses for
comment partition parameter
COMMIT ARCHIVE
with archive log files
complex operations
in maintenance
compound key
when to use
concurrency
in creating tables
concurrent
connections maximum
sessions maximum
transactions
transactions maximum
CONNECT authority
defined
delegating
for modules
granting
listed in SYSTEM.SPECAUTH
revoking
connecting
example
starting a DBE session by
to the DBEnvironment
console log file
wrapperDBE
console message file
messages
constraint
adding to table
creating tables with
dropping from table
effects on loading tables
entries in SYSTEM.CHECKDEF
entries in SYSTEM.CONSTRAINT
CREATE DBEFILE
deviceid
example
group name
in SQLMigrate
syntax
CREATE DBEFILESET
effect on SYSTEM.DBEFILE
example
syntax
CREATE GROUP
example
syntax
CREATE INDEX
example
syntax
CREATE SCHEMA
defining a database with
CREATE TABLE
basic syntax
CREATE TEMPSPACE
example
to create sort space
CREATE VIEW
example
syntax
creating
audit DBE
indexes
log file
partition
creating objects
authorization groups
databases
DBEFiles
DBEFileSets
DBEnvironments
defining a database schema
expandable DBEFiles
hash structures
indexes
log files
procedures
rules
security scheme
security schemes
tables
views
current language
D
data
access with views
conversion and performance
independence
normalizing
redundancy
statistical
database
logical design
objects
physical design
sample tables
schema for
storage calculation
database administrator (DBA)
defined
database design
logical
physical
data buffer
changing number of pages
displaying number of pages
pages displaying with SQLUtil
setting in DBECon file
setting number of pages in SQLUtil
shared memory for
size
data definition
disabling
disabling in DBECon file
disabling in SQLUtil
enabling in DBECon file
overview
data types
BINARY
CHAR
DATE
DATETIME
DECIMAL
FLOAT
in defining columns
INTEGER
INTERVAL
REAL
SMALLINT
storage requirements
TIME
VARBINARY
VARCHAR
DATE
defining columns as
storage requirements
DATETIME
defining columns as
storage requirements
DBA authority
defined
for SYSTEM views
statements requiring
uses of
DBA (database administrator)
defined
DBA tasks
database creation and security
logical design
physical design
DBCore
and SYSTEM.CALL pseudotable
control block buffer pages
DBE
audit parameter
creating audit
DBECon file
adjusting values in
backup
creating parameters with START DBE NEW
DBEnvironment language
DDL Enabled flag
default options
element in a DBEnvironment
example
in a new DBEnvironment
Memory Resident Data Buffer flag
purging
SHOWDBE-ALL
timeout value
wrapperDBE
DBECon file parameters
DBECreator
and DBECon file
and restoring
and restoring partial
and START DBE NEWLOG
changing in SQLUtil
defined
setting in DBECon file
specified in the DBECon file
DBEFile
access
access mode change
access mode display
adding to DBEFileSets
allocating expandable DBEFile space
altering the type of
calculating data rows per page
calculating number of directory pages
creating
defined
device change
dropping
element in a DBEnvironment
entries in SYSTEM.DBEFILESET
estimating size
listed in SYSTEM.DBEFILE
maximum size
naming
on different disk drives
pages
per DBEnvironment
purging
size
size in pages
type
type index
type, mixed
types
type table
when to add
DBEFile0
DBEFILE clause
default name
default size
displaying name with SQLUtil
element in a DBEnvironment
in a new DBEnvironment
purging
setting in DBECon file
DBEFileSet
access
adding DBEFiles to
authority in SYSTEM.SPACEDEFAULT
creating
DBEFiles in
default
element in a DBEnvironment
entries in SYSTEM.DBEFILESET
for check constraints
for long columns
for tables
granting authority
listed in SYSTEM.DBEFILE
maximum size
organizing tables in
placing tables and indexes in
revoking authority
system
SYSTEM
tables
DBELOG1
DBELOG2
DBEnvironment
access
backup
configuration
creating separate
elements
elements created at configuration
elements illustrated
maintenance
migration of
naming
recovery
recreating with SQLGEN
sample
starting
starting with SQLGEN
startup parameters
stopping
storage requirements
DBE session
starting
terminating
DBEUserID
as owner
reserved users
DBEUserIDs
reserved
DDL enabled flag
setting in DBECon file
DDL Enabled flag
changing
changing in SQLUtil
disabling data definition
startup value
DDL statements
wrapperDBE
deadlock
monitoring with SYSTEM.COUNTER
DECIMAL
defining columns as
storage requirements
default
column values specifying
DBEFileSet assigning
partition parameter
timeout setting in DBECon file
user timeout changing in SQLUtil
deferred constraints
used when loading tables
definition
of audit functionality
of objects in system catalog
DELETE authority
and views
explained
deleting
column
table
description file option
example
DETACHFILE
detaching a file
SQLUtil
syntax
device change for DBEFiles
deviceid
CREATE DBEFILE
direct grantable privilege
and WITH GRANT option
directory
calculations for overhead
of log files
disk space
for DBEFile0
for indexes
for log file
for system catalog
for tables
modules
monitoring use
display DBE attributes
SHOWDBE
double quotes
DROP DBEFILE
before purging
example
DROP GROUP
syntax
DROP MODULE
dropping
constraint
DBEFiles
indexes
modules
partition
rules and procedures
sections
side effects of dropping constraints
tables
DROP TABLE
dual file
logging type
dual logging
enabling, disabling
specifying for DBE
dynamic statements
E
ECHO_ALL
SET in SQLGEN
SET in SQLUtil
editor
syntax
EDITOR
SQLGEN
ENDRECOVERY
syntax
entity
as a database table
defined
error code
-4008
example
audit DBE
partition
EXECUTE authority
entries in SYSTEM.PROCAUTH
granting
EXIT
from SQLAudit
from SQLGEN
from SQLMigrate
from SQLUtil
EXIT_ON_DBERR
SET in SQLUtil
EXIT_ON_DBERR OFF
SET in SQLGEN
exit on error
SQLAudit
exit status
checking
setting
expandable DBEFiles
creating
expanding
log file
system DBEFileSet
EXTERNAL load
loading tables
F
first normal form
defined
FLOAT
defining columns as
storage requirements
formula
directory overhead for tables
index key length
indexkey length
nonarchive log file size
number of index leaf pages
number of index non-leaf pages
number of overhead index leaf
pages per table
row length
rows per data page
rows per index leaf page
rows per index non-leaf page
total number of index pages
forward migration
functional dependency
G
GENERATE ALL
generate audit information
audit tool
GENERATE DBE
GENERATE DBEFILES
GENERATE DEFAULTSPACE
GENERATE GROUPS
GENERATE INDEXES
GENERATE INSTALLAUTH
GENERATE LOAD
GENERATE MODAUTH
GENERATE MODOPTINFO
GENERATE PARTITION
GENERATE PROCAUTH
GENERATE PROCEDURES
GENERATE PROCOPTINFO
GENERATE RULES
GENERATE SPACEAUTH
GENERATE SPECAUTH
GENERATE STATISTICS
GENERATE TABAUTH
GENERATE TABLES
GENERATE TEMPSPACES
GENERATE VIEWAUTH
GENERATE VIEWS
GENPLAN
and SYSTEM.PLAN
get current audit point
GRANT
EXECUTE authority
RUN authority
SELECT ON
grantable privilege
explained
granting
procedure authorities
SECTIONSPACE authority
TABLESPACE authority
to PUBLIC
group
assigning authorities to
created explicitly
entries in SYSTEM.GROUP
name CREATE DBEFILE
H
hard crash
recovery from
hash structure
creating tables as
design
disk space for
entries in SYSTEM.HASH
HELP
in SQLMigrate
SQLAudit
SQLGEN
SQLUtil
host variable
CHECKPOINT
HPRDBSS
as owner of system tables
reserved user
I
identifier numbers
for log files
implicit locking
private
public
publicread
index
altering the key
as type of DBEFile
authority
calculating key length
calculating rows per leaf page
calculating rows per non-leaf page
cluster count
clustering
clustering design
compound key
creating
DBEFile
design
disk space for
dropping
dropping and recreating
entries in SYSTEM.CONSTRAINTINDEX
entries in SYSTEM.HASH
entries in SYSTEM.INSTALLAUTH
for joins
key
key length
maximum key length
maximum per DBEnvironment
name
number of leaf pages
number of non-leaf pages
number of overhead pages
organizing in DBEFileSets
simple key
stored in mixed DBEFile
temporary
total number of pages
unique
unique design
updating
INDEX authority
explained
indicator variable
for null values
in effect, audit logging
INFO command
displaying column definitions with
initial table loads
in database creation
input tree
INSERT
INSERT authority
and views
explained
INSTALL
example
transferring modules with
installable module
SQLMOD
INTEGER
idefining columns as
storage requirements
integrity constraint
creating tables with
design
disk space for
entries in SYSTEM.CONSTRAINT
entries in SYSTEM.CONSTRAINTCOL
entries in SYSTEM.CONSTRAINTINDEX
intermediate levels of a tree
INTERNAL load
loading tables
INTERVAL
defining columns as
storage requirements
invalidation
application program sections
statements causing
invoke editor from SQLAudit
audit tool
ISQL
command size
overview
syntax summary
J
JCW
GENERR
GENWARN
MIGERR
MIGWARN
SQLVERERR
system JCW and SQLGEN
system JCW and SQLMigrate
system JCW and SQLUtil
UTILERR
UTILWARN
join
maximum tables per
used to create a view
K
key
calculation of length
changing, in a clustering index
compound
creating an index on primary
defined
determining for index
simple
L
LANG clause
in CREATE TABLE
language
current language
DBECon file setting
DBEnvironment and current
displaying the DBE's
in defining tables or columns
native language support
LANGUAGEID
in SYSTEM.COLUMN
in SYSTEM.TABLE
leaf level of a tree
limits
in ALLBASE/SQL
table of maximum
list archived files
STOREINFO
LOAD
example
external
EXTERNAL option
GENERATE LOAD
in deleting columns
in maintenance operations
INTERNAL option
loading tables from files
lock current audit point
locking
in table creation
of system catalog by UPDATE STATISTICS
on the system catalog
PUBLIC
publicread
strategy in CREATE TABLE
system catalog
LOCK TABLE
override automatic locking
lock type of system tables
changing
log buffer
changing number of pages
displaying number of pages
setting in DBECon file
setting number of pages in SQLUtil
shared memory for
size
written to log file
LOG DBEFILE clause
log file
adding with ADDLOG
ADDLOG command
archive logging
backup
changing dual logging
changing the name
changing the size
creating
creating a new
creating new with START DBE NEWLOG
default name
default size
defined
different from DBEFiles
disk space for
displaying information with SHOWLOG
dual, in wrapperDBE
dual logging
element in a DBEnvironment
estimating size for
inactive, in wrapperDBE
in a new DBEnvironment
listed in log directory
log records
moving with MOVELOG
not usable
number of, wrapperDBE
purging
purging with PURGELOG
recovering with RECOVERLOG
rescuing with RESCUELOG
restoring with RESTORELOG
single, in wrapperDBE
size
size in pages
SQLUtil
storing with STORELOG
switching
usable, in wrapperDBE
wrapperDBE
writeahead logging
logfile
change for DBEnvironment
name(s) in DBECon file
name stored in DBECon file
LOG FULL
understanding the condition
logging
archive explained
enabling archive logging
file names and numbers
file sequence numbers
LOG FULL condition
managing log files
nonarchive explained
single or dual log files
specifying dual logging
understanding log file types
using multiple files
using nonarchive logs
logical design
log pages
log records
audit
written to the log file
LONG BINARY
storage requirements
long column
DBEFileSet specification
LONG VARBINARY
storage requirements
M
maintenance
adding a column
adding a constraint to a table
adding DBEFiles to DBEFileSets
applications
changing a table's lock mode
changing DBEFile type
cleanup with monitor
DBECon File
DBEnvironment
deleting a column
deleting table rows
disk space
dividing tables
dropping a constraint from a table
dropping a DBEFile
dropping and recreating hash structures
dropping and recreating indexes
dropping and recreating procedures
dropping and recreating rules
dropping a table
dropping modules
enabling and disabling data definition
granting and revoking procedure authorities
indexes
merging tables
reloading tables
revalidating procedure sections
rules and procedures
security schemes
setting SQLUtil maintenance word
system catalog statistics
tables
updating groups
using simple and complex operations
maintenance word
adjusting parameter in DBECon file
changing in SQLUtil
changing with SQLUtil
setting
setting in DBECon file
maximum
table of limits
timeout value in DBECon file
transactions in DBECon file
transactions in SQLUtil
user timeout in SQLUtil
maximum transactions
changing with SQLUtil
displaying with SQLUtil
maxpartitions parameter
media failure
recovery from
memory resident data buffer flag
changing
setting
startup value
messages
console message file
MIGRATE
in SQLMigrate
migration
backward
forward
of DBEnvironments
steps in
mixed
as type of DBEFile
modify current audit point
module
and SYSTEM.SECTION view
and SYSTEM.SETOPTINFO view
definition of
disk space for
dropping
installing
pages needed to store
validation of
monitor
for cleanup
monitoring performance
with SQLMON
MOSET
in SET BACKUP
MOVEFILE
moving a file
SQLUtil
syntax
MOVELOG
syntax
moving a file
MOVEFILE
multiple files
in logging
multiuser mode
changing to
DBE session
setting in DBECon file
N
naming
double quotes
NATIVE-3000
defined
native language
current language
DBEnvironment and current
defaults
displaying the DBE's
in creating tables
in DBECon file
in defining columns
overview
shown in SYSTEM.COLUMN
shown in SYSTEM.TABLE
NETUsers file
NETUtil
purpose
nonarchive logging
and backing up database files
calculating log file size
calculating number of pages
explained
size
nonreplicate DBE
SQLMigrate
normal forms
in database design
normalization
defined
first normal form
NOT NULL
not usable log files
wrapperDBE
null indicator
in loading from files
null values
O
objects
statements that create
once per session flag in DBECon file
online backup
procedures in archive mode
orphaned log files
wrapperDBE
orphaned privilege
defined
elimination of
overflow page
owner
and OWNER authority
class
creating classes
defining classes
in SYSTEM.TABLE
of system section tables
of system tables
of tables
OWNER authority
defined
for modules
P
pages
and clustering indexes
assigning to DBEFiles
calculating data rows per page
calculating pages per table
calculating rows per index leaf page
calculating rows per index non-leaf page
efficient use of
in DBEFiles
in log files
in START DBE NEW
number of index leaf pages
number of index non-leaf pages
number of overhead index pages
temporary
total number of index pages
page table page
calculations for tables
parameter
audit
audit elements
audit log
audit name
CHECKPOINT
comment partition
default partition
maxpartitions
replicate
parameters
changing with SQLUtil
displaying with SQLUtil
in DBECon file
startup
startup in SQLUtil
parameters in procedures
default values in SYSTEM.PARAMDEFAULT
entries in SYSTEM.PARAMETER
partition
creating
dropping
example
table
PCR (Parent-child relationship)
explained
performance
and deleting indexes
effect on, from using mixed DBEFiles
improving, by grouping tables
improving, with clustering indexes
improving with index on join column
monitoring with SQLMON
physical design
physical object
preprocessing
drop
PREVIEW
in SQLMigrate
primary key
creating an index on
creating unique constraints with
printing
of rules
priority
in transactions
private
procedure
creating
dropping and recreating
entries for parameters in SYSTEM.PARAMETER
entries in SYSTEM.PARAMDEFAULT
entries in SYSTEM.PROCEDURE
entries in SYSTEM.PROCRESULT
examining in the system catalog
EXECUTE authority in SYSTEM.PROCAUTH
GENERATE PROCAUTH command
GENERATE PROCEDURES command
maintaining
stored sections in
pseudo-mapped files
and online backups
moving to mapped
not supported
pseudotables
defined
functions
STOREDSECT.SYSTEM
SYSTEM.ACCOUNT
SYSTEM.CALL
SYSTEM.COUNTER
SYSTEM.PLAN
SYSTEM.TRANSACTION
SYSTEM.USER
PUBLIC
granting authorities to
grant to
special DBEUserID
PURGEALL
syntax
PURGEDBE
syntax
PURGEFILE
syntax
PURGELOG
syntax
Q
query
and SYSTEM.PLAN view
query optimization
quit
syntax
QUIT
in SQLMigrate
in SQLUtil
quit from SQLAudit
audit tool
QUIT (SHOWDBE)
description
R
REAL
defining columns as
storage requirements
recompile dynamically
RECOVERLOG
syntax
recovery
in archive mode
in nonarchive mode
overview
rollback
recreating
indexes
rules and procedures
REFERENCES authority
explained
listed in SYSTEM.COLAUTH
REFERENCES clause
defining referential constraints with
referential constraint
creating tables with
entries in SYSTEM.CONSTRAINT
entries in SYSTEM.CONSTRAINTCOL
entries in SYSTEM.CONSTRAINTINDEX
RELEASE
SQLGEN
terminating a DBE session with
remote databases
accessing
REMOVE DBEFILE
example
REMOVE FROM GROUP
example
syntax
removing all rows
TRUNCATE TABLE statement
renaming
columns
tables
REPAIR
in SQLMigrate
repeating data groups
removing in normalization
replicate
DBE using SQLmigrate
parameter
re-preprocessing
avoiding
RESCUELOG
syntax
reserved users
CATALOG
HPRDBSS
PUBLIC
SYSTEM
TEMP
resource authority
listed in SYSTEM.SPACEAUTH
RESOURCE authority
defined
RESTORE
syntax
RESTORELOG
syntax
RESTORE PARTIAL
syntax
RESTORESET
in SET BACKUP
restoring
data with RESTORE
logs with RESTORELOG
revalidate
procedure sections
revalidating
application program sections
sections
REVOKE
CONNECT authority
example
EXECUTE authority
RESOURCE authority
SELECT ON
revoking
procedure authorities
SECTIONSPACE authority
TABLESPACE authority
rollback recovery
explained
rollforward
wrapperDBE
rollforward recovery
archive log files
explained
root level of a tree
row
calculating length
calculating rows per page
formula for length
length
maximum length
rule
columns in the system catalog
creating
determining behavior in a DBEnvironment
dropping and recreating
effects on loading tables
entries in SYSTEM.RULE
examining in the system catalog
maintaining
RUN authority
for modules
granting
in system catalog
runtime control blocks
setting in DBECon file
setting number in SQLUtil
shared memory for
run tree
S
sample DBEnvironment
contents of
tables
schema
database
SQLGEN
schema file
creating with SQLGEN
search item
second normal form
defined
section
and SYSTEM.SECTION view
and SYSTEM.SETOPTINFO view
and UPDATE STATISTICS
calculating space
default DBEFileSet
disk space for
invalidating
revalidating
statements that do not create
stored in catalog
types
valid
valid and invalid
validating and invalidating
SECTIONSPACE authority
defined
granting
revoking
SECTIONSPACE default DBEFileSet
security
creating DBEnvironment security scheme
management
specifying when creating a table
SELECT authority
and views
explained
selectlist
semicolon
used in SQLUtil
sequence number
for log files
wrapperDBE
sequential search
set
connect to DBEnvironment
recoverfile
SQLAudit
SET
SET BACKUP
in SQLUtil
SET CONSTRAINTS DEFERRED
used when loading tables
SETDBEMAINT
syntax
SET DBEnvironment
SQLAudit
SET DML ATOMICITY
used when loading tables
SET ECHO_ALL
in SQLAudit
in SQLUtil
SET ECHO_ALL OFF
syntax
SET ECHO_ALL ON
syntax
SET EDITOR
SQLAudit
SQLGEN
SET_EXIT_DBERR
syntax
SET EXIT_ON_DBERR OFF
syntax
SET EXIT_ON_DBERR ON
syntax
SETOPT
and SYSTEM.SETOPTINFO view
SET RECOVERFILE
SQLAudit
SET SCHEMA
SQLGEN
SETUPRECOVERY
syntax
SETUPRECOVERY PARTIAL
set up rollforward
syntax
set up rollforward
SETUPRECOVERY PARTIAL
shared memory
data buffer
estimating requirements
for log buffer
requirements for buffers
runtime control block buffer
transactions
SHOWACCESS
syntax
SHOW AUDITPOINT
syntax
SHOWDBE
ALL-syntax
display DBE attributes
EXIT-syntax
HELP-syntax
LANG-syntax
MAINT-syntax
QUIT-syntax
STARTPARMS-syntax
syntax
wrapperDBE
SHOW 'DBEnvironmentName' VERSION
in SQLMigrate
SHOWLOG
syntax
using to monitor log file usage
wrapperDBE
SHOWSET
in SQLUtil
SHOW VERSIONS
in SQLMigrate
simple key
simple operations
in maintenance
single file
logging type
single user mode
and starting a DBE session
changing to
DBE session
setting in DBECon file
size of log file
SMALLINT
defining columns as
storage requirements
soft crash
and rollback recovery
sort ordering
special authority
DBA authority
listed in SYSTEM.SPACEAUTH
listed in SYSTEM.SPACEDEFAULT
listed in SYSTEM.SPECAUTH
SQLAudit
overview
SQLAudit commands
audit[point]
editor
exit
get audit[point]
help
lock audit[point]
modify audit[point]
quit
set
set DBEnvironment
set echo
set editor
set_exit_dberr
set recoverfile
show audit[point]
unlock audit[point]
SQLCore
and null values
and pseudotables
system statistics used by
SQLGEN
command summary
introduction
schema
schema files
starting up
SQLGEN commands
EDITOR
EXIT
GENERATE ALL
GENERATE DBE
GENERATE DBEFILES
GENERATE DEFAULTSPACE
GENERATE GROUPS
GENERATE INDEXES
GENERATE INSTALLAUTH
GENERATE LOAD
GENERATE MODAUTH
GENERATE MODOPTINFO
GENERATE PARTITION
GENERATE PROCAUTH
GENERATE PROCEDURES
GENERATE PROCOPTINFO
GENERATE RULES
GENERATE SPACEAUTH
GENERATE SPECAUTH
GENERATE STATISTICS
GENERATE TABAUTH
GENERATE TABLES
GENERATE TEMPSPACES
GENERATE VIEWAUTH
GENERATE VIEWS
HELP
RELEASE
SET ECHO_ALL OFF
SET ECHO_ALL ON
SET EDITOR
SET EXIT_ON_DBERR OFF
SET EXIT_ON_DBERR ON
SET SCHEMA
STARTDBE
SQLINSTL
overview
SQLMigrate
nonreplicate DBE
overview
replicate DBE
starting up
SQLMigrate commands
ADD DBEFile
EXIT
HELP
MIGRATE
PREVIEW
QUIT
REPAIR
SHOW 'DBEnvironmentName' VERSION
SHOW VERSIONS
SQLMON
available DBEFileset space
cluster count
examining DBEFilesets
hash structures
index space
monitoring the log
overview
stored sections
table information
SQL statements
authorities required for
locks obtained by
syntax summary
SQLUtil
ATTACHFILE
CHANGELOG
CHECKPOINT
DETACHFILE
example
log file
MOVEFILE
overview
starting up
SQLUtil commands
ADDLOG
ALTDBE
ATTACHFILE
CHANGELOG
DETACHFILE
ENDRECOVERY
EXIT
HELP
MOVEFILE
MOVELOG
PURGEALL
PURGEDBE
PURGEFILE
PURGELOG
QUIT
RECOVERLOG
RESCUELOG
RESTORE
RESTORELOG
RESTORE PARTIAL
SET
SETDBEMAINT
SETUPRECOVERY
SETUPRECOVERY PARTIAL
SHOWACCESS
SHOWDBE
SHOWDBE-ALL
SHOWDBE-EXIT
SHOWDBE-HELP
SHOWDBE-LANG
SHOWDBE-MAINT
SHOWDBE-QUIT
SHOWDBE-STARTPARMS
SHOWLOG
SHOWSET
STORE
STOREINFO
STORELOG
STOREONLINE
STOREONLINE PARTIAL
STORE PARTIAL
WRAPDBE
SQLVer
START
in ISQL
START DBE
example
single user
startup parameters
syntax
STARTDBE
SQLGEN
START DBE NEW
and dual log files
configuring a DBE
creating a log file
elements created
example
wrapperDBE
START DBE NEWLOG
changing dual logging
creating a new log file
example
starting DBE sessions
with CONNECT
with START DBE
startup parameter
adjusting in DBECon file
changing with SQLUtil
DBEnvironment
default
defaults
in DBECon file
statements
dynamic
static backup
in archive mode
with nonarchive logging
statistical data
updating
STOP DBE
terminating DBE sessions
storage requirements
for specific data types
overview
STORE
SQLUtil
STOREDSECT
as owner of system section tables
reserved user
stored section
and validation
when stored
STOREDSECT.SYSTEM
defined
STOREINFO
list archived files
syntax
STORELOG
syntax
STOREONLINE
SQLUtil
STOREONLINE PARTIAL
SQLUtil
STORE PARTIAL
SQLUtil
STORESET
in SET BACKUP
syntax
WRAPDBE command
syntax summary
ISQL
SQL statements
SYSTEM
reserved user
SYSTEM.ACCOUNT
column definition and description
SYSTEM.CALL
column definition and description
system catalog
after configuration
allocating disk space
CATALOG views
complete information and tables
disk space for
element in a DBEnvironment
examining
example
locks
locks obtained by SQL statements
locks on
monitoring space
owners HPRDBSS, CATALOG, and SYSTEM
pseudotable functions
pseudotables
purging
rule columns
rules
sizeo
statements that add to
SYSTEM views
updating
view constraint information store in
view definitions stored in
SYSTEM.CHECKDEF
column definition and description
view constraint information stored in
SYSTEM.COLAUTH
column definition and description
SYSTEM.COLDEFAULT
column definition and description
SYSTEM.COLUMN
affected by UPDATE STATISTICS
column definition and description
querying
SYSTEM.CONSTRAINT
column definition and description
view constraint definitions stored in
SYSTEM.CONSTRAINTCOL
column definition and description
SYSTEM.CONSTRAINTINDEX
column definition and description
SYSTEM.COUNTER
column definition and description
SYSTEM.DBEFILE
affected by UPDATE STATISTICS
characteristics of files stored in
column definition and description
DBEFileSet names stored in
names of files stored in
SYSTEM.DBEFILESET
affected by UPDATE STATISTICS
column definition and description
names stored in
SYSTEM DBEFileSet
adding space to
defined
determining space in
in a new DBEnvironment
SYSTEM.GROUP
column definition and description
SYSTEM.HASH
column definition and description
SYSTEM.IMAGEKEY
column definition and description
SYSTEM.INDEX
affected by UPDATE STATISTICS
and cluster count
column definition and description
SYSTEM.INSTALLAUTH
column definition and description
SYSTEM.MODAUTH
column definition and description
SYSTEM.PARAMDEFAULT
column definition and description
SYSTEM.PARAMETER
column definition and description
SYSTEM.PLAN
column definition and description
SYSTEM.PROCAUTH
column definition and description
SYSTEM.PROCEDURE
column definition and description
SYSTEM.PROCEDUREDEF
column definition and description
SYSTEM.PROCRESULT
column definition and description
SYSTEM.RULE
column definition and description
SYSTEM.RULECOLUMN
column definition and description
SYSTEM.SECTION
column definition and description
monitoring stored sections in
view definitions stored in
SYSTEM.SETOPTINFO
column definition and description
SYSTEM.SPACEAUTH
column definition and description
SYSTEM.SPACEDEFAULT
column definition and description
SYSTEM.SPECAUTH
column definition and description
SYSTEM.TABAUTH
column definition and description
SYSTEM.TABLE
affected by UPDATE STATISTICS
column definition and description
examining table definitions in
querying
view definitions stored in
system table
lock type changing
SYSTEM.TEMPSPACE
column definition and description
SYSTEM.TPINDEX
column definition and description
SYSTEM.TRANSACTION
column definition and description
SYSTEM.USER
column definition and description
monitoring, to show current users
SYSTEM.VIEWDEF
column definition and description
system views
containing security data
in the system catalog
listed
restricting catalog access
T
table
adding a column to
adding constraint to
as type of DBEFile
authorities
changing lock mode
creating
DBEFile
DBEFileSet
DBEFileSet specification
default DBEFileSet
deleting a column to
deleting all rows
design
disk space for
dividing
double quotes
dropping
dropping constraint from
examining definitions
for sample database
implicit locking
implied security
in DBEFileSet
loading
loading external files
loading internal file
locking
maximum column length
maximum columns per
maximum per DBEnvironment
merging columns
name
organizing in DBEFileSets
owner
partition
private
public
publicread
renaming
restrictions
revoking authority for
separate disk drives
stored in mixed DBEFile
system
unloading
TABLESPACE authority
defined
granting
revoking
TABLESPACE default DBEFileSet
tasks
adding a column
adding a constraint to a table
adding DBEFiles to DBEFileSets
adding log files with ADDLOG
backup and recovery
backup in nonarchive mode
changing a table's lock mode
changing DBEFile type
cleanup after abnormal termination
creating a DBEnvironments
creating a hash structure
creating a new log file
creating an index
creating a procedure
creating a rule
creating a table
creating a view
creating DBEFiles and DBEFileSets
creating DBEnvironment security scheme
creating log files
creating logical and physical objects
creating the database security scheme
defining a database schema
deleting a column
deleting table rows
displaying log file information with SHOWLOG
dividing tables
dropping a constraint from a table
dropping a DBEFile
dropping and recreating hash structures
dropping and recreating indexes
dropping and recreating procedures
dropping and recreating rules
dropping a table
dropping modules
enabling and disabling data definition
enabling and disabling rule operation
examining the system catalog
granting and revoking procedure authorities
indexes
loading tables
maintaining applications
maintaining rules and procedures
maintenance
managing log files
merging tables
moving log files with MOVELOG
online backup in archive mode
purging log files with PURGELOG
recovering log files with RECOVERLOG
recovery in nonarchive mode
reloading tables
rescuing log files with RESCUELOG
restoring log files with RESTORELOG
revalidating procedure sections
revoking table authorites
rollforward recovery in archive mode
starting and stopping DBE sessions
static backup in archive mode
storing log files with STORELOG
updating groups
updating system catalog statistics
temporary index
and performance
tempspace
creating
TERMINATE QUERY
TERMINATE TRANSACTION
TERMINATE USER
terminating a DBE session
using RELEASE
using STOP DBE
using TERMINATE USER
third normal form
TIME
defining columns as
storage requirements
timeout value
and DBECon file
changing in SQLUtil
default in DBECon file
maximum
maximum in DBECon file
transaction
changing maximum in SQLUtil
concurrent
defined
estimating number
implicitly begun
priority
setting maximum number of
shared memory for block buffer
SYSTEM.TRANSACTION
transfer ownership
and CONNECT authority
TRANSFER OWNERSHIP
syntax
transitive dependency
TRUNCATE TABLE
removing all rows
tuple header
TurboSTORE II
in SET BACKUP
types of DBEFile
table and mixed
U
unavailable DBECon file
wrapperDBE
unique constraint
creating
entries in SYSTEM.CONSTRAINT
entries in SYSTEM.CONSTRAINTCOL
entries in SYSTEM.CONSTRAINTINDEX
unique index
defined
design
guidelines for
UNLOAD
creating files from tables
for restructuring
GENERATE LOAD
in deleting columns
in maintenance operations
internal
unlock audit point
audit tool
UPDATE authority
and views
explained
listed in SYSTEM.COLAUTH
updates
wrapperDBE
UPDATE STATISTICS
example
invalidating sections
on system views
overview
updating cluster count
when to use
usable log files
wrapperDBE
user mode
adjusting parameter in DBECon file
changing with SQLUtil
displaying with SQLUtil
setting in DBECon file
user timeout value
changing in SQLUtil
setting in DBECon file
V
VALIDATE
revalidating procedure sections
validating
application program sections
modules
VARBINARY
defining columns as
storage requirements
VARCHAR
defining columns as
storage requirements
version checker
view
and SYSTEM.SECTION
as a stored section
authorities
creating:view
data access
design
dropping
granting authorities for
maximum base tables per
maximum columns per
maximum per DBEnvironment
name
owner
restructuring with
revoking authority for
security applications
WITH CHECK OPTION
virtual table
W
WITH CHECK OPTION
view
WITH GRANT OPTION clause
examples
WRAPDBE
syntax
wrapperDBE
wrapperDBE
archive logging
audit information
audit parameters
audit tool
command mode
console log file
DBECon file
DDL statements
dual log files
inactive log files
log files
log files, number of
not usable log files
orphaned log files
roll forward
sequence number
SHOWDBE command
SHOWLOG command
single log files
START DBE NEW
unavailable DBECon file
updates
usable log files
WRAPDBE command
writeahead logging
explained
MPE/iX 5.5 Documentation