 |
» |
|
|
|
A- access mode
- single user and multiuser, Starting and Stopping DBE Sessions
- access plan
- displayed in SYSTEM.PLAN view, System.Plan
- accessing a DBEnvironment, Defining the DBEnvironment Scope
- ADD DBEFILE
- example, Adding DBEFiles to DBEFileSets
- expanding DBEFileSet with, Adding a New DBEFile
- in SQLMigrate, ADD DBEFILE
- syntax, Adding DBEFiles to DBEFileSets
- when to use, Managing DBEFiles and DBEFileSets
- ADD TO GROUP
- example, Creating Authorization Groups
- syntax, Managing Authorization Groups
- adding
- column, Adding Columns
- constraint, Adding Constraints
- ADDLOG
- command creating log file, Defining Additional Audit DBEnvironment Log Files
- command in SQLUtil, Defining Additional Audit DBEnvironment Log Files
- syntax, ADDLOG
- AliasDB file, Using NETUtil
- ALLBASE/NET
- connecting to remote databases, Remote Database Access
- ALLBASE/SQL command size, ALLBASE/SQL Limits
- ALTER authority
- explained, Controlling Table Access with Authorities
- ALTER DBEFILE, Changing DBEFile Type
- ALTER TABLE, Changing a Table's Locking Behavior
- example, Adding Columns
- when to use, Adding Columns
- applications
- dynamic recompile, Invalidation and Revalidation of Sections
- maintenance, Maintaining Applications
- modifying, Invalidation and Revalidation of Sections
- stored sections in, Information in the System Catalog on Validity of Sections
- validation of sections, Invalidation and Revalidation of Sections
- archive checkpoint record
- creating with COMMIT ARCHIVE, Adding Files to the Archive Log
- defined, Logs and Recovery
- archive logging
- calculating log file size, Estimating Log File Size
- explained, Choosing Archive Logging
- wrapperDBE, Setting up a Wrapper DBEnvironment
- archive mode
- setting in DBECon file, Adjusting Startup Values
- assigning a default DBEFileSet, Assigning Default DBEFileSets
- assigning pages
- to data buffer, Estimating Data Buffer Pages, Starting a DBE Session in Single-User Mode
- to DBEFiles, Estimating DBEFile Size
- to log buffer, Estimating Log Buffer Pages, Starting a DBE Session in Single-User Mode
- to runtime control block buffer, Estimating Runtime Control Block Buffer Pages
- ATTACHFILE
- attaching a file, Moving DBEFiles to Different Groups
- SQLUtil, Moving DBEFiles to Different Groups
- attribute
- as a column in a table, Defining Columns
- defined, Identifying the Data for Tables
- audit
- elements changing, Creating Audit DBEnvironments
- elements parameter, Creating Audit DBEnvironments
- functionality, Creating Audit DBEnvironments
- information wrapperDBE, Setting up a Wrapper DBEnvironment
- log record, Creating Audit DBEnvironments
- logging in effect, Defining Additional Audit DBEnvironment Log Files
- logging parameter, Creating Audit DBEnvironments
- name parameter, Creating Audit DBEnvironments
- parameter, Defining Additional Audit DBEnvironment Log Files
- parameters for wrapperDBE, Selecting Log Files when the DBECon File is Inaccessible
- syntax, AUDIT
- tool wrapperDBE, Setting up a Wrapper DBEnvironment
- audit DBE
- creating, Creating Audit DBEnvironments, Example of Setting Up an Audit DBEnvironment
- example, Creating Audit DBEnvironments
- parameter, Creating Audit DBEnvironments
- audit tool
- exit from SQLAudit, EXIT
- exit on error, SET EXIT_ON_DBERR
- generate audit information, AUDIT
- get current audit point, GET AUDITPOINT
- help command, HELP
- invoke editor from SQLAudit, EDITOR
- lock current audit point, LOCK AUDITPOINT
- modify current audit point, MODIFY AUDITPOINT
- quit SQLAudit, QUIT
- set, SET
- set connect to DBEnvironment, SET DBENVIRONMENT
- set echo command, SET ECHO_ALL
- set editor command, SET EDITOR
- set recoverfile command, SET RECOVERFILE
- show current audit point , SHOW AUDITPOINT
- unlock audit point, UNLOCK AUDITPOINT
- authority
- basic types, Authority Types
- defined, Defining Security Levels
- EXECUTE in SYSTEM.PROCAUTH, System.Procauth
- for SQL statements, Authorities Required by ALLBASE/SQL Statements
- grantable privilege, Using the GRANT OPTION Clause
- granting, Granting/Revoking RUN Authority, Granting/Revoking EXECUTE Authority
- in SYSTEM.TABAUTH, System.Tabauth
- module related, Module Related Authorities
- OWNER, Owner Authority
- REFERENCES in SYSTEM.COLAUTH, System.Colauth
- revoking, Granting/Revoking RUN Authority, Granting/Revoking EXECUTE Authority
- RUN in SYSTEM.MODAUTH, System.Modauth
- space, Space Authorities
- special, Special Authorities
- special in SYSTEM.SPACEAUTH, System.Spaceauth
- special in SYSTEM.SPACEDEFAULT, System.Spacedefault
- SPECIAL in SYSTEM.SPECAUTH, System.Specauth
- table and view, Controlling Table Access with Authorities
- TABLE in SYSTEM.TABAUTH, System.Tabauth
- UPDATE in SYSTEM.COLAUTH, System.Colauth
- verification, Verification of Authority
- authorization group
- as owner, Owner Authority
- characteristics, Defining Authorization Groups
- CONNECT authority for, Granting/Revoking CONNECT Authority
- delegating management of, Granting/Revoking CONNECT Authority
- determining membership, Determining Group Membership
- entries in SYSTEM.GROUP, System.Group
- indirect member, Determining Group Membership
- invalid chain, Determining Group Membership
- management, Managing Authorization Groups
- resource authority for, Granting/Revoking RESOURCE Authority
- authorize once per session
- changing in SQLUtil, Adjusting Startup Values
- in DBECon file, Adjusting Startup Values
- startup value, Using START DBE NEW
- autostart mode
- and user mode, Using Autostart
- changing in SQLUtil, Adjusting Startup Values
- defined, Using Autostart
- procedures, Using Autostart
- setting in DBECon file, Adjusting Startup Values
B- B-tree, Designing Indexes, Calculating Storage for Indexes
- backup
- displaying type set in SQLUtil, SHOWSET
- of DBEnvironment, Nonarchive Backup Procedures
- online procedures with archive logging, Online Backup Procedures in Archive Mode
- overview, Backup and Recovery
- procedures with nonarchive logging, Nonarchive Backup Procedures
- SQLUtil STORE, Nonarchive Backup Procedures
- backward migration, Steps for Backward Migration
- base table
- in the system catalog, System Catalog
- view underlying, Designing Views
- BEGIN ARCHIVE
- with archive log files, Logs and Recovery
- BINARY
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- buffer
- data, Estimating Shared Memory Requirements
- log, Estimating Shared Memory Requirements
- runtime control block, Estimating Shared Memory Requirements
C- calculations
- database storage, Calculating Storage for Database Objects
- directory overhead for tables, Calculating Directory Overhead
- disk space for indexes, Calculating Storage for Indexes
- disk space for tables, Calculating Storage for Tables
- index key length, Determining Index Keys, Calculating the Index Key Length
- number of index leaf pages, Calculating the Number of Leaf Pages
- number of index non-leaf pages, Calculating the Number of Non-Leaf Pages
- number of overhead index pages, Calculating the Number of Directory Overhead Pages
- page table page for tables, Calculating Directory Overhead
- pages per table, Calculating Number of Pages
- row length, Defining Column Size, Calculating Row Length
- rows per data page, Calculating Rows per Page
- rows per index leaf page, Calculating the Number of Rows per Leaf Page
- rows per index non-leaf page, Calculating the Number of Rows per Non-Leaf Page
- size of nonarchive log files, Estimating Log File Size
- total number of index pages, Calculating Total Number of Index Pages
- CATALOG
- reserved user, Views owned by SYSTEM and CATALOG
- views owned by, Views owned by SYSTEM and CATALOG
- catalog
- system, Creating Logical and Physical Objects
- CCOUNT
- in maintaining indexes, Monitoring the Cluster Count
- CHANGELOG
- changing log file, Using Console Message Files
- SQLUtil, Using Console Message Files
- changing
- a table's lock mode, Changing a Table's Locking Behavior
- audit elements, Creating Audit DBEnvironments
- log file with CHANGELOG, Using Console Message Files
- system table lock type, Changing System Table Lock Types
- CHAR
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- check constraint
- DBEFileSet specification, DBEFileSet Name
- entries in SYSTEM.CHECKDEF, System.CheckDef
- entries in SYSTEM.CONSTRAINT, System.Constraint
- CHECKPOINT
- host variable, Detaching and Attaching Database Files
- parameter, Detaching and Attaching Database Files
- SQLUtil, Detaching and Attaching Database Files
- checkpoint
- and log file space, Using Nonarchive Logs
- archive checkpoint record, Logs and Recovery
- using to monitor log file usage, Log Records and Transactions
- class
- as owner, Owner Authority
- created implicitly, Differences Between Groups and Classes
- creating, Creating Classes
- defining, Defining Classes
- differences from DBEUserID and group, Defining Classes
- guidelines for creating, Guidelines for Creating Classes
- cleanup
- with monitor, Cleaning Up after Abnormal Termination
- cluster count
- in maintaining indexes, Monitoring the Cluster Count
- clustering index
- changing a key, Altering the Index Key
- creating, Defining Clustering Indexes
- defined, Determining Index Type
- design, Defining Clustering Indexes
- guidelines for, Defining Clustering Indexes
- when to create, Defining Clustering Indexes
- collision of two keys, Understanding the Hash Function
- column
- adding, Adding Columns
- defining data types for, Defining Column Data Type
- definition, Defining Columns
- definitions stored in the system catalog, System.Coldefault, System.Column
- deleting, Deleting Columns
- maximum length, Defining Tables
- maximum number of, Defining Tables
- minimum number, Column Name and Data Type
- naming, Defining Column Names
- null values for, Defining Null Values For Columns
- renaming, Renaming Tables or Columns
- size, Defining Column Size
- UPDATE authority in system catalog, System.Colauth
- command files
- creating with SQLGEN, Using SQLGEN
- in loading tables, Using Command Files for Loading
- uses for, Using ISQL
- comment partition parameter, Creating Audit DBEnvironments
- COMMIT ARCHIVE
- with archive log files, Logs and Recovery
- complex operations
- in maintenance, Using Simple and Complex Maintenance Operations
- compound key
- when to use, How Index Keys are Used
- concurrency
- in creating tables, Creating Tables
- concurrent
- connections maximum, ALLBASE/SQL Limits
- sessions maximum, ALLBASE/SQL Limits
- transactions, Estimating Log File Size, Example
- transactions maximum, ALLBASE/SQL Limits
- CONNECT authority
- defined, Special Authorities
- delegating, Granting/Revoking CONNECT Authority
- for modules, Module Related Authorities
- granting, Granting/Revoking CONNECT Authority
- listed in SYSTEM.SPECAUTH, System.Specauth
- revoking, Granting/Revoking CONNECT Authority
- connecting
- example, Using Autostart
- starting a DBE session by, Managing DBEnvironment Sessions
- to the DBEnvironment, Starting and Stopping DBE Sessions
- console log file
- wrapperDBE, Dual Logs, Selecting Log Files when the DBECon File is Inaccessible
- console message file
- messages, Using a Host Variable with the CHECKPOINT Statement
- constraint
- adding to table, Adding Constraints
- creating tables with, Constraint Definitions
- dropping from table, Dropping Constraints
- effects on loading tables, Loading Tables with Constraints on Them
- entries in SYSTEM.CHECKDEF, System.CheckDef
- entries in SYSTEM.CONSTRAINT, System.Constraint
- CREATE DBEFILE
- deviceid, Maintaining a Nonstop Production System
- example, Creating DBEFiles
- group name, Maintaining a Nonstop Production System
- in SQLMigrate, CREATE DBEFILE
- syntax, Creating DBEFiles
- CREATE DBEFILESET
- effect on SYSTEM.DBEFILE, System.DBEFile
- example, Creating DBEFileSets
- syntax, Creating DBEFileSets
- CREATE GROUP
- example, Creating Authorization Groups
- syntax, Managing Authorization Groups
- CREATE INDEX
- example, Creating Indexes
- syntax, Creating Indexes
- CREATE SCHEMA
- defining a database with, Creating a Database Schema
- CREATE TABLE
- basic syntax, Creating Tables
- CREATE TEMPSPACE
- example, Calculating Temporary Disk Space
- to create sort space, Calculating Temporary Disk Space
- CREATE VIEW
- example, Creating Views, Controlling Table Access with Views
- syntax, Creating Views
- creating
- audit DBE, Creating Audit DBEnvironments, Example of Setting Up an Audit DBEnvironment
- indexes, Creating Indexes
- log file, Example of Setting Up an Audit DBEnvironment, Defining Additional Audit DBEnvironment Log Files
- partition, Defining Partitions and Tables
- creating objects
- authorization groups, Creating Authorization Groups
- databases, Database Creation and Security
- DBEFiles, Creating DBEFiles
- DBEFileSets, Creating DBEFileSets
- DBEnvironments, Using START DBE NEW
- defining a database schema, Creating a Database Schema
- expandable DBEFiles, Allocating Expandable DBEFile Space
- hash structures, Creating Hash Structures
- indexes, Creating Indexes
- log files, Log Files
- procedures, Creating a Procedure
- rules, Creating a Rule
- security scheme, Creating the DBEnvironment Security Scheme
- security schemes, Controlling Table Access with Authorities
- tables, Creating Tables
- views, Creating Views
- current language, Native Language Support
D- data
- access with views, Designing Views
- conversion and performance, Defining Column Data Type
- independence, Designing Views
- normalizing, Normalizing the Data
- redundancy, Normalizing the Data
- statistical, Using UPDATE STATISTICS on System Views
- data buffer
- setting in DBECon file, Adjusting Startup Values
- setting number of pages in SQLUtil, Adjusting Startup Values
- shared memory for, Estimating Shared Memory Requirements
- size, Estimating Data Buffer Pages, ALLBASE/SQL Limits
- data definition
- disabling, Disabling Data Definition
- disabling in DBECon file, Adjusting Startup Values
- disabling in SQLUtil, Adjusting Startup Values
- enabling in DBECon file, Adjusting Startup Values
- overview, Logical Design
- data types
- BINARY, Defining Column Data Type
- CHAR, Defining Column Data Type
- DATE, Defining Column Data Type
- DATETIME, Defining Column Data Type
- DECIMAL, Defining Column Data Type
- FLOAT, Defining Column Data Type
- in defining columns, Defining Column Data Type
- INTEGER, Defining Column Data Type
- INTERVAL, Defining Column Data Type
- REAL, Defining Column Data Type
- SMALLINT, Defining Column Data Type
- storage requirements, Calculating Row Length
- TIME, Defining Column Data Type
- VARBINARY, Defining Column Data Type
- VARCHAR, Defining Column Data Type
- database
- logical design, Logical Design
- objects, Owner Authority
- physical design, Physical Design
- sample tables, Final Form of Sample Database Tables
- schema for, Creating a Database Schema
- storage calculation, Calculating Storage for Database Objects
- database administrator (DBA)
- defined, DBA Tasks and Tools
- database design
- logical, Logical Design
- physical, Physical Design
- DATE
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- DATETIME
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- DBA (database administrator)
- defined, DBA Tasks and Tools
- DBA authority, Defining the DBEnvironment Scope
- defined, Special Authorities
- for SYSTEM views, Views owned by SYSTEM and CATALOG
- statements requiring, DBA Functions
- uses of, Using DBA Authority
- DBA tasks
- database creation and security, Database Creation and Security
- logical design, Logical Design
- physical design, Physical Design
- DBCore
- and SYSTEM.CALL pseudotable, System.Call
- control block buffer pages, Estimating Runtime Control Block Buffer Pages
- DBE
- audit parameter, Creating Audit DBEnvironments
- creating audit, Creating Audit DBEnvironments
- DBE session, Managing DBEnvironment Sessions
- starting, Using Autostart, Using START DBE, Connecting to a DBE
- terminating, Using STOP DBE
- DBECon file
- adjusting values in, Adjusting Startup Values
- backup, Nonarchive Backup Procedures, Adding Files to the Archive Log
- creating parameters with START DBE NEW, Using START DBE NEW
- DBEnvironment language, Using START DBE NEW
- DDL Enabled flag, Using START DBE NEW
- default options, Starting a DBE Session in Single-User Mode
- element in a DBEnvironment, Creating Logical and Physical Objects
- example, Supplying Startup Parameters with START DBE NEW, Examining DBECon Parameters
- in a new DBEnvironment, Supplying Startup Parameters with START DBE NEW
- Memory Resident Data Buffer flag, Using START DBE NEW
- timeout value, Using START DBE NEW
- wrapperDBE, Setting up a Wrapper DBEnvironment, Dual Logs
- DBECon file parameters, Adjusting Startup Values
- DBECreator
- and DBECon file, Using START DBE NEW
- and START DBE NEWLOG, Starting a New Log
- changing in SQLUtil, Adjusting Startup Values
- defined, DBA Tasks and Tools
- setting in DBECon file, Adjusting Startup Values
- specified in the DBECon file, Supplying Startup Parameters with START DBE NEW
- DBEFile
- adding to DBEFileSets, Estimating DBEFile Size, Adding DBEFiles to DBEFileSets
- allocating expandable DBEFile space, Allocating Expandable DBEFile Space
- altering the type of, Changing DBEFile Type
- calculating data rows per page, Calculating Rows per Page
- calculating number of directory pages, Calculating Number of Pages
- creating, Creating DBEFiles
- defined, Understanding DBEFile Characteristics
- dropping, Dropping a DBEFile
- element in a DBEnvironment, Creating Logical and Physical Objects
- entries in SYSTEM.DBEFILESET, System.DBEFileSet
- estimating size, Estimating DBEFile Size
- listed in SYSTEM.DBEFILE, System.DBEFile
- maximum size, ALLBASE/SQL Limits
- naming, Creating DBEFiles
- on different disk drives, Using Different Storage Devices
- pages, Defining Column Size, Estimating DBEFile Size, Creating DBEFiles
- per DBEnvironment, ALLBASE/SQL Limits
- size, Estimating DBEFile Size
- size in pages, Understanding DBEFile Characteristics
- type, Understanding DBEFile Characteristics, Choosing DBEFile Types and Devices, Creating DBEFiles
- type index, Using Separate DBEFiles for Tables and Indexes
- type table, Using Separate DBEFiles for Tables and Indexes
- type, mixed, Understanding DBEFile Characteristics, Using a Single MIXED DBEFile
- types, Using a Single MIXED DBEFile
- when to add, Managing DBEFiles and DBEFileSets
- DBEFile0, Calculating Storage for the System Catalog
- DBEFILE clause, Calculating Storage for the System Catalog
- default name, Calculating Storage for the System Catalog
- default size, Calculating Storage for the System Catalog
- element in a DBEnvironment, Creating Logical and Physical Objects
- in a new DBEnvironment, Supplying Startup Parameters with START DBE NEW
- setting in DBECon file, Adjusting Startup Values
- DBEFileSet, Understanding DBEFile Characteristics
- adding DBEFiles to, Adding DBEFiles to DBEFileSets
- authority in SYSTEM.SPACEDEFAULT, System.Spacedefault
- creating, Creating DBEFileSets
- DBEFiles in, Understanding DBEFile Characteristics
- default, Assigning Default DBEFileSets
- element in a DBEnvironment, Creating Logical and Physical Objects
- entries in SYSTEM.DBEFILESET, System.DBEFileSet
- for check constraints, DBEFileSet Name
- for long columns, DBEFileSet Name
- for tables, DBEFileSet Name
- granting authority, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- listed in SYSTEM.DBEFILE, System.DBEFile
- maximum size, ALLBASE/SQL Limits
- organizing tables in, Arranging Tables and Indexes in DBEFileSets
- placing tables and indexes in, Monitoring System Catalog Size
- revoking authority, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- SYSTEM, Arranging Tables and Indexes in DBEFileSets, Calculating Storage for the System Catalog, Supplying Startup Parameters with START DBE NEW
- system, Calculating Storage for the System Catalog
- tables, Grouping Tables in DBEFileSets
- DBELOG1, Sample Log Configuration
- DBELOG2, Sample Log Configuration
- DBEnvironment, Defining the DBEnvironment Scope
- access, Defining the DBEnvironment Scope
- backup, Nonarchive Backup Procedures
- configuration, Log Records and Transactions, DBEnvironment Configuration and Security, Using START DBE NEW
- creating separate, Defining the DBEnvironment Scope
- elements, Creating Logical and Physical Objects
- elements created at configuration, Supplying Startup Parameters with START DBE NEW
- elements illustrated, Elements of an ALLBASE/SQL DBEnvironment
- maintenance, Maintaining the DBEnvironment
- migration of, Migrating DBEnvironments Between Releases of ALLBASE/SQL
- recovery, Archive Recovery Procedures
- recreating with SQLGEN, Using SQLGEN
- sample, Defining the DBEnvironment Scope
- starting, Using START DBE
- starting with SQLGEN, STARTDBE
- stopping, Terminating a DBE Session
- storage requirements, Physical Design
- DBEUserID, Verification of Authority
- as owner, Owner Authority, Owner and Table Name
- reserved users, System Catalog
- DBEUserIDs
- reserved, Defining Authorization Groups
- DDL Enabled flag
- changing in SQLUtil, Adjusting Startup Values
- disabling data definition, Disabling Data Definition
- startup value, Using START DBE NEW
- DDL enabled flag
- setting in DBECon file, Adjusting Startup Values
- DDL statements
- wrapperDBE, Creating a DBEnvironment
- deadlock
- monitoring with SYSTEM.COUNTER, System.Counter
- DECIMAL
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- default
- column values specifying, DEFAULT Clause
- DBEFileSet assigning, Assigning Default DBEFileSets
- partition parameter, Creating Audit DBEnvironments
- timeout setting in DBECon file, Adjusting Startup Values
- user timeout changing in SQLUtil, Adjusting Startup Values
- deferred constraints
- used when loading tables, Loading Tables with Constraints on Them
- definition
- of audit functionality, Creating Audit DBEnvironments
- of objects in system catalog, Definitions of Rules, Procedures, Constraints, and Views
- DELETE authority
- and views, Controlling Table Access with Views
- explained, Controlling Table Access with Authorities
- deleting
- column, Deleting Columns
- table, Deleting Columns
- description file option
- example, Loading from an External File
- DETACHFILE
- detaching a file, Moving DBEFiles to Different Groups
- SQLUtil, Moving DBEFiles to Different Groups
- deviceid
- CREATE DBEFILE, Maintaining a Nonstop Production System
- direct grantable privilege
- and WITH GRANT option, Using the GRANT OPTION Clause
- directory
- calculations for overhead, Calculating Directory Overhead
- of log files, Understanding Log File Types
- disk space
- for DBEFile0, Calculating Storage for the System Catalog
- for indexes, Calculating Storage for Indexes
- for log file, Disk Space for the Log
- for system catalog, Calculating Storage for the System Catalog
- for tables, Calculating Storage for Tables
- modules, Monitoring File Space for Modules and Sections
- monitoring use, Managing DBEFiles and DBEFileSets
- display DBE attributes
- SHOWDBE, SHOWDBE
- double quotes, Examining Table Attributes
- DROP DBEFILE, Dropping a DBEFile
- example, Dropping a DBEFile
- DROP GROUP
- syntax, Managing Authorization Groups
- DROP MODULE, Dropping Modules
- DROP TABLE, Dropping Tables
- dropping
- constraint, Dropping Constraints
- DBEFiles, Dropping a DBEFile
- indexes, Dropping and Recreating an Index
- modules, Dropping Modules
- partition, Defining Partitions and Tables
- rules and procedures, Dropping and Recreating Rules and Procedures
- sections, Storage of Definitions for Newly Created Objects
- side effects of dropping constraints, Maintaining Sets of Interrelated Objects
- tables, Dropping Tables
- dual file
- logging type, Using Single or Dual Logs
- dual logging, Sample Log Configuration
- enabling, disabling, Starting a New Log
- specifying for DBE, Dual Logging
- dynamic statements, Module Related Authorities
E- EDITOR
- SQLGEN, EDITOR
- editor
- syntax, EDITOR
- entity
- as a database table, Defining Columns
- defined, Identifying the Data for Tables
- error code
- -4008, Running out of Shared Memory
- example
- audit DBE, Creating Audit DBEnvironments
- partition, Defining Partitions and Tables
- EXECUTE authority
- entries in SYSTEM.PROCAUTH, System.Procauth
- granting, Granting/Revoking EXECUTE Authority
- EXIT
- from SQLAudit, EXIT
- from SQLGEN, EXIT
- from SQLMigrate, EXIT
- exit on error
- SQLAudit, SET EXIT_ON_DBERR
- exit status
- checking, Checking the Exit Status
- setting, Checking the Exit Status
- expandable DBEFiles
- creating, Allocating Expandable DBEFile Space
- expanding
- log file, Starting a New Log
- system DBEFileSet, Calculating Storage for the System Catalog
- EXTERNAL load
- loading tables, Loading from an External File
F- first normal form
- defined, First Normal Form
- FLOAT
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- formula
- directory overhead for tables, Calculating Directory Overhead
- index key length, Calculating the Index Key Length, ALLBASE/SQL Limits
- indexkey length, Determining Index Keys
- nonarchive log file size, Estimating Log File Size
- number of index leaf pages, Calculating the Number of Leaf Pages
- number of index non-leaf pages, Calculating the Number of Non-Leaf Pages
- number of overhead index leaf, Calculating the Number of Directory Overhead Pages
- pages per table, Calculating Number of Pages
- row length, Defining Column Size, Calculating Row Length, ALLBASE/SQL Limits
- rows per data page, Calculating Rows per Page
- rows per index leaf page, Calculating the Number of Rows per Leaf Page
- rows per index non-leaf page, Calculating the Number of Rows per Non-Leaf Page
- total number of index pages, Calculating Total Number of Index Pages
- forward migration, Steps for Forward Migration
- functional dependency, Second Normal Form
G- GENERATE ALL, GENERATE ALL
- generate audit information
- audit tool, AUDIT
- GENERATE DBE, GENERATE DBE
- GENERATE DBEFILES, GENERATE DBEFILES
- GENERATE DEFAULTSPACE, GENERATE DEFAULTSPACE
- GENERATE GROUPS, GENERATE GROUPS
- GENERATE INDEXES, GENERATE INDEXES
- GENERATE INSTALLAUTH, GENERATE INSTALLAUTH
- GENERATE LOAD, GENERATE LOAD
- GENERATE MODAUTH, GENERATE MODAUTH
- GENERATE MODOPTINFO, GENERATE MODOPTINFO
- GENERATE PARTITION, GENERATE PARTITION
- GENERATE PROCAUTH, GENERATE PROCAUTH
- GENERATE PROCEDURES, GENERATE PROCEDURES
- GENERATE PROCOPTINFO, GENERATE PROCOPTINFO
- GENERATE RULES, GENERATE RULES
- GENERATE SPACEAUTH, GENERATE SPACEAUTH
- GENERATE SPECAUTH, GENERATE SPECAUTH
- GENERATE STATISTICS, GENERATE STATISTICS
- GENERATE TABAUTH, GENERATE TABAUTH
- GENERATE TABLES, GENERATE TABLES
- GENERATE TEMPSPACES, GENERATE TEMPSPACES
- GENERATE VIEWAUTH, GENERATE VIEWAUTH
- GENERATE VIEWS, GENERATE VIEWS
- GENPLAN
- and SYSTEM.PLAN, System.Plan
- get current audit point, GET AUDITPOINT
- GRANT
- EXECUTE authority, Granting/Revoking EXECUTE Authority
- RUN authority, Granting/Revoking RUN Authority
- SELECT ON, Authorities for Single Users
- grantable privilege
- explained, Using the GRANT OPTION Clause
- granting
- procedure authorities, Granting and Revoking Procedure Authorities
- SECTIONSPACE authority, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- TABLESPACE authority, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- to PUBLIC, Table Type
- group
- assigning authorities to, Authorities for Groups
- created explicitly, Differences Between Groups and Classes
- entries in SYSTEM.GROUP, System.Group
- name CREATE DBEFILE, Maintaining a Nonstop Production System
H- hard crash, Logs and Recovery
- recovery from, Archive Recovery Procedures
- hash structure
- creating tables as, Creating Hash Structures
- design, Designing Hash Structures
- disk space for, Calculating Storage for Hash Structures
- entries in SYSTEM.HASH, System.Hash
- HELP
- in SQLMigrate, HELP
- SQLAudit, HELP
- SQLGEN, HELP
- host variable
- CHECKPOINT, Detaching and Attaching Database Files
- HPRDBSS
- as owner of system tables, Changing System Table Lock Types
- reserved user, System Catalog
I- identifier numbers
- for log files, Log Names and Numbers
- idx access mode
- change for DBEFiles, ATTACHFILE, MOVEFILE
- display for DBEFiles, SHOWACCESS
- idx ALTDBE
- syntax, ALTDBE
- idx ATTACHFILE
- syntax, ATTACHFILE
- idx authorize once per session
- setting with SQLUtil, ALTDBE
- idx autostart mode
- changing in SQLUtil, ALTDBE
- displaying with SQLUtil, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- idx backup
- creating with SQLUtil STORE, STORE
- creating with SQLUtil STOREONLINE, STOREONLINE
- SET BACKUP in SQLUtil, SET
- SQLUtil STORE PARTIAL, STORE PARTIAL
- SQLUtil STOREONLINE PARTIAL, STOREONLINE PARTIAL
- idx CHANGELOG
- syntax, CHANGELOG
- idx data buffer
- changing number of pages, ALTDBE
- displaying number of pages, SHOWDBE-STARTPARMS
- pages displaying with SQLUtil, SHOWDBE-ALL
- idx DBECon file
- DDL Enabled flag, ALTDBE
- purging, PURGEALL, PURGEDBE
- SHOWDBE-ALL, SHOWDBE-ALL
- idx DBECreator
- and restoring, RESTORE
- and restoring partial, RESTORE PARTIAL
- idx DBEFile
- access, DETACHFILE
- access mode change, ATTACHFILE, MOVEFILE
- access mode display, SHOWACCESS
- device change, ATTACHFILE, CHANGELOG, MOVEFILE
- purging, PURGEALL, PURGEDBE, PURGEFILE
- idx DBEFile0
- displaying name with SQLUtil, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- purging, PURGEALL, PURGEDBE, PURGEFILE
- idx DBEFileSet
- access, DETACHFILE
- idx DBEnvironment
- naming, ALTDBE
- startup parameters, SHOWDBE-STARTPARMS
- idx DDL Enabled flag
- changing, ALTDBE
- idx DETACHFILE
- syntax, DETACHFILE
- idx device change for DBEFiles, ATTACHFILE, MOVEFILE
- idx DROP DBEFILE
- before purging, PURGEFILE
- idx ECHO_ALL
- SET in SQLGEN, SET ECHO_ALL OFF
- SET in SQLUtil, SET
- idx ENDRECOVERY
- syntax, ENDRECOVERY
- idx EXIT
- from SQLUtil, EXIT
- idx EXIT_ON_DBERR
- SET in SQLUtil, SET
- idx EXIT_ON_DBERR OFF
- SET in SQLGEN, SET EXIT_ON_DBERR OFF
- idx HELP
- SQLUtil, HELP
- idx language
- displaying the DBE's, SHOWDBE-LANG
- idx log buffer
- changing number of pages, Parameters
- displaying number of pages, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- idx log file
- purging, PURGEALL, PURGEDBE
- idx logfile
- change for DBEnvironment, CHANGELOG
- idx maintenance
- setting SQLUtil Maintenance Word, SHOWDBE-MAINT
- idx Maintenance Word
- setting, SETDBEMAINT, SHOWDBE-MAINT
- idx maintenance word
- changing with SQLUtil, ALTDBE
- idx maximum transactions
- changing with SQLUtil, Parameters
- displaying with SQLUtil, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- idx memory resident data buffer flag
- setting, ALTDBE
- idx MOSET
- in SET BACKUP, SET
- idx MOVEFILE
- syntax, MOVEFILE
- idx MOVELOG
- syntax, MOVELOG
- idx native language
- displaying the DBE's, SHOWDBE-LANG
- idx parameters
- changing with SQLUtil, ALTDBE
- displaying with SQLUtil, SHOWDBE-ALL
- startup in SQLUtil, SHOWDBE-STARTPARMS
- idx PURGEALL
- syntax, PURGEALL
- idx PURGEDBE
- syntax, PURGEDBE
- idx PURGEFILE
- syntax, PURGEFILE
- idx QUIT
- in SQLUtil, QUIT
- idx QUIT (SHOWDBE)
- description, SHOWDBE-QUIT
- idx RECOVERLOG
- syntax, RECOVERLOG
- idx RESTORE
- syntax, RESTORE
- idx RESTORE PARTIAL
- syntax, RESTORE PARTIAL
- idx RESTORESET
- in SET BACKUP, SET
- idx semicolon
- used in SQLUtil, Using SQLUtil
- idx SET BACKUP
- in SQLUtil, SET
- idx SET ECHO_ALL
- in SQLUtil, SET
- idx SET ECHO_ALL OFF
- syntax, SET ECHO_ALL OFF
- idx SET ECHO_ALL ON
- syntax, SET ECHO_ALL ON
- idx SET EXIT_ON_DBERR OFF
- syntax, SET EXIT_ON_DBERR OFF
- idx SET EXIT_ON_DBERR ON
- syntax, SET EXIT_ON_DBERR ON
- idx SETDBEMAINT
- syntax, SETDBEMAINT
- idx SETUPRECOVERY
- syntax, SETUPRECOVERY
- idx SETUPRECOVERY PARTIAL
- syntax, SETUPRECOVERY PARTIAL
- idx SHOWACCESS
- syntax, SHOWACCESS
- idx SHOWDBE
- ALL-syntax, SHOWDBE-ALL
- EXIT-syntax, SHOWDBE-EXIT
- HELP-syntax, SHOWDBE-HELP
- LANG-syntax, SHOWDBE-LANG
- MAINT-syntax, SHOWDBE-MAINT
- QUIT-syntax, SHOWDBE-QUIT
- STARTPARMS-syntax, SHOWDBE-STARTPARMS
- syntax, SHOWDBE
- idx SQLGEN commands
- SET ECHO_ALL OFF, SET ECHO_ALL OFF
- SET ECHO_ALL ON, SET ECHO_ALL ON
- SET EXIT_ON_DBERR OFF, SET EXIT_ON_DBERR OFF
- SET EXIT_ON_DBERR ON, SET EXIT_ON_DBERR ON
- idx SQLUtil
- overview, Using SQLUtil
- starting up, Starting SQLUtil
- idx SQLUtil commands
- ALTDBE, ALTDBE
- ATTACHFILE, ATTACHFILE
- CHANGELOG, CHANGELOG
- DETACHFILE, DETACHFILE
- ENDRECOVERY, ENDRECOVERY
- EXIT, EXIT
- HELP, HELP
- MOVEFILE, MOVEFILE
- MOVELOG, MOVELOG
- PURGEALL, PURGEALL
- PURGEDBE, PURGEDBE
- PURGEFILE, PURGEFILE
- QUIT, QUIT
- RECOVERLOG, RECOVERLOG
- RESTORE, RESTORE
- RESTORE PARTIAL, RESTORE PARTIAL
- SET, SET
- SETDBEMAINT, SETDBEMAINT
- SETUPRECOVERY, SETUPRECOVERY
- SETUPRECOVERY PARTIAL, SETUPRECOVERY PARTIAL
- SHOWACCESS, SHOWACCESS
- SHOWDBE, SHOWDBE
- SHOWDBE-ALL, SHOWDBE-ALL
- SHOWDBE-EXIT, SHOWDBE-EXIT
- SHOWDBE-HELP, SHOWDBE-HELP
- SHOWDBE-LANG, SHOWDBE-LANG
- SHOWDBE-MAINT, SHOWDBE-MAINT
- SHOWDBE-QUIT, SHOWDBE-QUIT
- SHOWDBE-STARTPARMS, SHOWDBE-STARTPARMS
- STORE, STORE
- STORE PARTIAL, STORE PARTIAL
- STOREINFO, STOREINFO
- STORELOG, STORELOG
- STOREONLINE, STOREONLINE
- STOREONLINE PARTIAL, STOREONLINE PARTIAL
- idx SQLVer , Using SQLVer
- idx START DBE
- syntax, Parameters
- idx startup parameter
- changing with SQLUtil, ALTDBE
- DBEnvironment, SHOWDBE-STARTPARMS
- idx STORE
- SQLUtil, STORE
- idx STORE PARTIAL
- SQLUtil, STORE PARTIAL
- idx STOREINFO
- syntax, STOREINFO
- idx STORELOG
- syntax, STORELOG
- idx STOREONLINE
- SQLUtil, STOREONLINE
- idx STOREONLINE PARTIAL
- SQLUtil, STOREONLINE PARTIAL
- idx STORESET
- in SET BACKUP, SET
- idx system catalog
- purging, PURGEALL, PURGEDBE
- idx TurboSTORE II
- in SET BACKUP, SET
- idx user mode
- changing with SQLUtil, ALTDBE
- displaying with SQLUtil, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- idx version checker, Using SQLVer
- implicit locking
- private, Table Type
- public, Table Type
- publicread, Table Type
- in effect, audit logging, Defining Additional Audit DBEnvironment Log Files
- index
- altering the key, Altering the Index Key
- as type of DBEFile, Understanding DBEFile Characteristics
- authority, Controlling Table Access with Authorities
- calculating key length, Calculating the Index Key Length
- calculating rows per leaf page, Calculating the Number of Rows per Leaf Page
- calculating rows per non-leaf page, Calculating the Number of Rows per Non-Leaf Page
- cluster count, Monitoring the Cluster Count
- clustering, Determining Index Type
- clustering design, Defining Clustering Indexes
- compound key, Determining Index Keys
- creating, Creating Indexes
- DBEFile, Using Separate DBEFiles for Tables and Indexes
- design, Designing Indexes, Determining Index Type
- disk space for, Calculating Storage for Indexes
- dropping, Dropping Tables
- dropping and recreating, Dropping and Recreating an Index
- entries in SYSTEM.CONSTRAINTINDEX, System.ConstraintIndex
- entries in SYSTEM.HASH, System.Hash
- entries in SYSTEM.INSTALLAUTH, System.Installauth
- for joins, How Index Keys are Used
- key, Determining Index Keys, Altering the Index Key
- key length, Determining Index Keys, Calculating the Index Key Length, ALLBASE/SQL Limits
- maximum key length, ALLBASE/SQL Limits
- maximum per DBEnvironment, ALLBASE/SQL Limits
- name, Creating Indexes
- number of leaf pages, Calculating the Number of Leaf Pages
- number of non-leaf pages, Calculating the Number of Non-Leaf Pages
- number of overhead pages, Calculating the Number of Directory Overhead Pages
- organizing in DBEFileSets, Arranging Tables and Indexes in DBEFileSets
- simple key, Determining Index Keys
- stored in mixed DBEFile, Using a Single MIXED DBEFile
- temporary, Dropping and Recreating an Index
- total number of pages, Calculating Total Number of Index Pages
- unique, Determining Index Type
- unique design, Defining Unique Indexes
- updating, Maintaining Indexes
- INDEX authority
- explained, Controlling Table Access with Authorities
- indicator variable
- for null values, Defining Null Values For Columns
- INFO command
- displaying column definitions with, Examining Table Attributes
- initial table loads
- in database creation, Loading Tables
- input tree, Calculating Space Needed for Sections, Invalidation and Revalidation of Sections
- INSERT, Merging Tables
- INSERT authority
- and views, Controlling Table Access with Views
- explained, Controlling Table Access with Authorities
- INSTALL
- example, Sharing Modules Between DBEnvironments
- transferring modules with, Sharing Modules Between DBEnvironments
- installable module
- SQLMOD, Sharing Modules Between DBEnvironments
- INTEGER
- idefining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- integrity constraint
- creating tables with, Constraint Definitions
- design, Designing Integrity Constraints
- disk space for, Referential Constraints
- entries in SYSTEM.CONSTRAINT, System.Constraint
- entries in SYSTEM.CONSTRAINTCOL, System.Constraintcol
- entries in SYSTEM.CONSTRAINTINDEX, System.ConstraintIndex
- intermediate levels of a tree, Designing Indexes
- INTERNAL load
- loading tables, Loading from an Internal File
- INTERVAL
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- invalidation
- application program sections, Invalidation and Revalidation of Sections, Information in the System Catalog on Validity of Sections, Causes for Invalidation of Sections
- statements causing, Causes for Invalidation of Sections
- invoke editor from SQLAudit
- audit tool, EDITOR
- ISQL
- command size, ALLBASE/SQL Limits
- overview, Using ISQL
- syntax summary, ISQL Syntax Summary
J- JCW
- GENERR, JCWs Set by SQLGEN
- GENWARN, JCWs Set by SQLGEN
- MIGERR, JCWs Set by SQLMigrate
- MIGWARN, JCWs Set by SQLMigrate
- SQLVERERR, Using SQLVer
- system JCW and SQLGEN, JCWs Set by SQLGEN
- system JCW and SQLMigrate, JCWs Set by SQLMigrate, Parameters
- system JCW and SQLUtil, JCWs Set by SQLUtil, Description
- UTILERR, JCWs Set by SQLUtil
- UTILWARN, JCWs Set by SQLUtil
- join, Defining Tables
- maximum tables per, ALLBASE/SQL Limits
- used to create a view, Creating Views
L- LANG clause
- in CREATE TABLE, Owner and Table Name
- language
- current language, Native Language Support
- DBECon file setting, Adjusting Startup Values
- DBEnvironment and current, Specifying a Native Language Parameter
- in defining tables or columns, Owner and Table Name
- native language support, Native Language Support
- LANGUAGEID
- in SYSTEM.COLUMN, System.Column
- in SYSTEM.TABLE, System.Table
- leaf level of a tree, Designing Indexes
- limits
- in ALLBASE/SQL, ALLBASE/SQL Limits
- table of maximum, ALLBASE/SQL Limits
- list archived files
- STOREINFO, STOREINFO
- LOAD
- example, Loading from an External File
- external, Dividing Tables
- EXTERNAL option, Loading from an External File
- GENERATE LOAD, GENERATE LOAD
- in deleting columns, Deleting Columns
- in maintenance operations, Using Simple and Complex Maintenance Operations
- INTERNAL option, Loading from an Internal File
- loading tables from files, Loading Tables
- lock current audit point, LOCK AUDITPOINT
- LOCK TABLE
- override automatic locking, Table Type
- lock type of system tables
- changing, Changing System Table Lock Types
- locking
- in table creation, Table Type
- of system catalog by UPDATE STATISTICS, Updating System Catalog Statistics
- on the system catalog, Locks Held on the System Catalog by SQL Statements
- PUBLIC, Defining Security Levels, Granting Authorities to PUBLIC
- publicread, Table Type
- strategy in CREATE TABLE, Creating Tables
- system catalog, Sharing Modules Between DBEnvironments
- log buffer
- setting in DBECon file, Adjusting Startup Values
- setting number of pages in SQLUtil, Adjusting Startup Values
- shared memory for, Estimating Shared Memory Requirements
- size, Estimating Log Buffer Pages, ALLBASE/SQL Limits
- written to log file, Estimating Log Buffer Pages
- LOG DBEFILE clause, Sample Log Configuration
- log file, Using NETUtil
- adding with ADDLOG, Adding Log Files with ADDLOG
- syntax, ADDLOG
- ADDLOG command, Defining Additional Audit DBEnvironment Log Files
- archive logging, Logs and Recovery
- backup, Adding Files to the Archive Log
- changing dual logging, Starting a New Log
- changing the name, Starting a New Log
- changing the size, Starting a New Log
- creating, Log Files, Example of Setting Up an Audit DBEnvironment, Defining Additional Audit DBEnvironment Log Files
- creating a new, Starting a New Log
- creating new with START DBE NEWLOG, Starting a New Log
- default name, Disk Space for the Log
- default size, Disk Space for the Log
- defined, Managing ALLBASE/SQL Logs
- different from DBEFiles, Understanding DBEFile Characteristics, Understanding Log File Characteristics
- disk space for, Disk Space for the Log
- displaying information with SHOWLOG, Examining Log File Characteristics, Monitoring the Log with SHOWLOG, SHOWLOG
- dual logging, Sample Log Configuration
- dual, in wrapperDBE, Single Logs
- element in a DBEnvironment, Creating Logical and Physical Objects
- estimating size for, Estimating Log File Size
- in a new DBEnvironment, Supplying Startup Parameters with START DBE NEW
- inactive, in wrapperDBE, Creating a DBEnvironment
- listed in log directory, Understanding Log File Types
- log records, Log Records and Transactions
- moving with MOVELOG, Moving Log Files with MOVELOG
- not usable, Dual Logs
- number of, wrapperDBE, Wrapping the DBEnvironment Around the Log Files
- purging with PURGELOG, Purging Log Files with PURGELOG, PURGELOG
- recovering with RECOVERLOG, Restoring Log Files with RESTORELOG
- rescuing with RESCUELOG, Rescuing Log Files with RESCUELOG, RESCUELOG
- restoring with RESTORELOG, Restoring Log Files with RESTORELOG, RESTORELOG
- single, in wrapperDBE, Selecting Valid Log Files with SHOWLOG
- size, Example of Setting Up an Audit DBEnvironment, ALLBASE/SQL Limits
- size in pages, Understanding Log File Characteristics
- SQLUtil, Defining Additional Audit DBEnvironment Log Files
- storing with STORELOG, Storing Log Files with STORELOG
- switching, Using Multiple Log Files, Using Multiple Log Files, Log Names and Numbers
- usable, in wrapperDBE, Setting up a Wrapper DBEnvironment
- wrapperDBE, Setting up a Wrapper DBEnvironment, WRAPDBE
- writeahead logging, Managing ALLBASE/SQL Logs
- LOG FULL
- understanding the condition, Understanding the LOG FULL Condition
- log pages, Estimating Log File Size
- log records, Log Records and Transactions, Estimating Log Buffer Pages
- audit, Creating Audit DBEnvironments
- written to the log file, Maintaining Buffers for Data and Log Pages
- logfile
- name stored in DBECon file, Adjusting Startup Values
- name(s) in DBECon file, Adjusting Startup Values
- logging
- archive explained, Choosing Archive Logging
- enabling archive logging, Archive Logging
- file names and numbers, Log Names and Numbers
- file sequence numbers, Sequence Numbers
- LOG FULL condition, Understanding the LOG FULL Condition
- managing log files, Managing Log Files
- nonarchive explained, Choosing Nonarchive Logging
- single or dual log files, Using Single or Dual Logs
- specifying dual logging, Dual Logging
- understanding log file types, Understanding Log File Types
- using multiple files, Using Multiple Log Files
- using nonarchive logs, Using Nonarchive Logs, Using Archive Logs
- logical design, Logical Design
- LONG BINARY
- storage requirements, Calculating Row Length
- long column
- DBEFileSet specification, DBEFileSet Name
- LONG VARBINARY
- storage requirements, Calculating Row Length
M- maintenance
- adding a column, Adding Columns
- adding a constraint to a table, Adding Constraints
- adding DBEFiles to DBEFileSets, Adding a New DBEFile
- applications, Maintaining Applications
- changing a table's lock mode, Changing a Table's Locking Behavior
- changing DBEFile type, Changing DBEFile Type
- cleanup with monitor, Cleaning Up after Abnormal Termination
- DBECon File, Adjusting Startup Values
- DBEnvironment, Maintaining the DBEnvironment
- deleting a column, Deleting Columns
- deleting table rows, Dropping Tables
- disk space, Grouping Tables in DBEFileSets
- dividing tables, Dividing Tables
- dropping a constraint from a table, Dropping Constraints
- dropping a DBEFile, Dropping a DBEFile
- dropping a table, Dropping Tables
- dropping and recreating hash structures, Dropping and Recreating Hash Structures
- dropping and recreating indexes, Dropping and Recreating an Index
- dropping and recreating procedures, Dropping and Recreating Rules and Procedures
- dropping and recreating rules, Dropping and Recreating Rules and Procedures
- dropping modules, Dropping Modules
- enabling and disabling data definition, Disabling Data Definition
- granting and revoking procedure authorities, Granting and Revoking Procedure Authorities
- indexes, Maintaining Indexes
- merging tables, Merging Tables
- reloading tables, Reloading a Table to Improve Index Performance
- revalidating procedure sections, Validating Procedure Sections
- rules and procedures, Maintaining Rules and Procedures
- security schemes, Maintaining Security
- system catalog statistics, Updating System Catalog Statistics
- tables, Maintaining Tables
- updating groups, Maintaining Security
- using simple and complex operations, Using Simple and Complex Maintenance Operations
- Maintenance Word
- adjusting parameter in DBECon file, Adjusting Startup Values
- changing in SQLUtil, Adjusting Startup Values
- setting in DBECon file, Adjusting Startup Values
- maximum
- table of limits, ALLBASE/SQL Limits
- timeout value in DBECon file, Adjusting Startup Values
- transactions in DBECon file, Adjusting Startup Values
- transactions in SQLUtil, Adjusting Startup Values
- user timeout in SQLUtil, Adjusting Startup Values
- maxpartitions parameter, Creating Audit DBEnvironments
- media failure
- recovery from, Archive Recovery Procedures
- memory resident data buffer flag
- changing, Adjusting Startup Values
- startup value, Using START DBE NEW
- messages
- console message file, Using a Host Variable with the CHECKPOINT Statement
- MIGRATE
- in SQLMigrate, MIGRATE
- migration
- backward, Steps for Backward Migration
- forward, Steps for Forward Migration
- of DBEnvironments, Migrating DBEnvironments Between Releases of ALLBASE/SQL
- steps in, Steps for Forward Migration
- mixed
- as type of DBEFile, Understanding DBEFile Characteristics
- modify current audit point, MODIFY AUDITPOINT
- module
- and SYSTEM.SECTION view, System.Section
- and SYSTEM.SETOPTINFO view, System.Setoptinfo
- definition of, Causes for Invalidation of Sections
- disk space for, Monitoring File Space for Modules and Sections
- dropping, Dropping Modules
- installing, Sharing Modules Between DBEnvironments
- pages needed to store, Calculating Space Needed for Sections
- validation of, Information in the System Catalog on Validity of Sections, Causes for Invalidation of Sections
- monitor
- for cleanup, Cleaning Up after Abnormal Termination
- monitoring performance
- with SQLMON, Using SQLMON
- MOVEFILE, Using Different Storage Devices
- moving a file, DBEFiles in Different Groups and Volumes
- SQLUtil, DBEFiles in Different Groups and Volumes
- moving a file
- MOVEFILE, DBEFiles in Different Groups and Volumes
- multiple files
- in logging, Using Multiple Log Files
- multiuser mode
- changing to, Adjusting Startup Values
- DBE session, Starting and Stopping DBE Sessions
- setting in DBECon file, Adjusting Startup Values
N- naming
- double quotes, Creating DBEFileSets
- native language
- current language, Native Language Support
- DBEnvironment and current, Specifying a Native Language Parameter
- defaults, Native Language Support
- in creating tables, Owner and Table Name
- in DBECon file, Specifying a Native Language Parameter
- in defining columns, Language Clause
- overview, Native Language Support
- shown in SYSTEM.COLUMN, System.Column
- shown in SYSTEM.TABLE, System.Table
- NATIVE-3000
- defined, Native Language Support
- NETUsers file, Using NETUtil
- NETUtil
- purpose, Using NETUtil
- nonarchive logging
- and backing up database files, Nonarchive Backup Procedures, Online Backup Procedures in Archive Mode
- calculating log file size, Estimating Log File Size
- calculating number of pages, Estimating Log File Size
- explained, Choosing Nonarchive Logging
- size, Estimating Log File Size
- nonreplicate DBE
- SQLMigrate, Types of Forward Migration
- normal forms
- in database design, Normalizing the Data
- normalization, Second Normal Form, Final Form of Sample Database Tables
- defined, Normalizing the Data
- first normal form, First Normal Form
- NOT NULL, Defining Null Values For Columns
- not usable log files
- wrapperDBE, Dual Logs
- null indicator
- in loading from files, Loading from an External File
- null values, Defining Null Values For Columns
O- objects
- statements that create, Storage of Definitions for Newly Created Objects
- once per session flag in DBECon file, Adjusting Startup Values
- online backup
- procedures in archive mode, Online Backup Procedures in Archive Mode
- orphaned log files
- wrapperDBE, Setting up a Wrapper DBEnvironment
- orphaned privilege
- defined, Orphaned Privileges
- elimination of, Orphaned Privileges
- overflow page, Understanding the Hash Function
- owner
- and OWNER authority, Owner Authority
- class, Owner Authority
- creating classes, Creating Classes
- defining classes, Defining Classes
- in SYSTEM.TABLE, Examining Table Attributes
- of system section tables, Changing System Table Lock Types
- of system tables, Changing System Table Lock Types
- of tables, Owner and Table Name
- OWNER authority
- defined, Special Authorities
- for modules, Module Related Authorities
P- page table page, Calculating Directory Overhead
- calculations for tables, Calculating Directory Overhead
- pages
- and clustering indexes, Defining Clustering Indexes
- assigning to DBEFiles, Estimating DBEFile Size
- calculating data rows per page, Calculating Rows per Page
- calculating pages per table, Calculating Number of Pages
- calculating rows per index leaf page, Calculating the Number of Rows per Leaf Page
- calculating rows per index non-leaf page, Calculating the Number of Rows per Non-Leaf Page
- efficient use of, Calculating Row Length
- in DBEFiles, Understanding DBEFile Characteristics
- in log files, Understanding Log File Characteristics
- in START DBE NEW, Calculating Storage for the System Catalog
- number of index leaf pages, Calculating the Number of Leaf Pages
- number of index non-leaf pages, Calculating the Number of Non-Leaf Pages
- number of overhead index pages, Calculating the Number of Directory Overhead Pages
- temporary, Calculating Temporary Disk Space
- total number of index pages, Calculating Total Number of Index Pages
- parameter
- audit, Defining Additional Audit DBEnvironment Log Files
- audit elements, Creating Audit DBEnvironments
- audit log, Creating Audit DBEnvironments
- audit name, Creating Audit DBEnvironments
- CHECKPOINT, Detaching and Attaching Database Files
- comment partition, Creating Audit DBEnvironments
- default partition, Creating Audit DBEnvironments
- maxpartitions, Creating Audit DBEnvironments
- replicate, Using SQLGEN
- parameters
- in DBECon file, Adjusting Startup Values
- startup, Using START DBE NEW
- parameters in procedures
- default values in SYSTEM.PARAMDEFAULT, System.Paramdefault
- entries in SYSTEM.PARAMETER, System.Parameter
- partition
- creating, Defining Partitions and Tables
- dropping, Defining Partitions and Tables
- example, Defining Partitions and Tables
- table, Defining Partitions and Tables, System Catalog Views
- PCR (Parent-child relationship)
- explained, Referential Constraints
- performance
- and deleting indexes, Dropping and Recreating an Index
- effect on, from using mixed DBEFiles, Using a Single MIXED DBEFile
- improving with index on join column, How Index Keys are Used
- improving, by grouping tables, Grouping Tables in DBEFileSets
- improving, with clustering indexes, Defining Clustering Indexes
- monitoring with SQLMON, Using SQLMON
- physical design, Physical Design
- physical object, Designing Views
- preprocessing, Causes for Invalidation of Sections, Sharing Modules Between DBEnvironments
- drop, Avoiding the Need for Re-Preprocessing
- PREVIEW
- in SQLMigrate, PREVIEW
- primary key
- creating an index on, Determining Index Keys
- creating unique constraints with, Unique Constraints
- printing
- of rules, Determining Behavior of Rules in a DBEnvironment Session
- priority
- in transactions, System.Transaction
- private, Table Type
- procedure
- creating, Creating a Procedure
- dropping and recreating, Dropping and Recreating Rules and Procedures
- entries for parameters in SYSTEM.PARAMETER, System.Parameter
- entries in SYSTEM.PARAMDEFAULT, System.Paramdefault
- entries in SYSTEM.PROCEDURE, System.Procedure
- entries in SYSTEM.PROCRESULT, System.ProcResult
- examining in the system catalog, Examining the Inventory of Rules and Procedures
- EXECUTE authority in SYSTEM.PROCAUTH, System.Procauth
- GENERATE PROCAUTH command, GENERATE PROCAUTH
- GENERATE PROCEDURES command, GENERATE PROCEDURES
- maintaining, Maintaining Rules and Procedures
- stored sections in, Information in the System Catalog on Validity of Sections
- pseudo-mapped files
- and online backups, Online Backup Procedures in Archive Mode
- moving to mapped, Description
- not supported, Description
- pseudotables
- defined, Views owned by SYSTEM and CATALOG
- functions, Summary of System Catalog Views by Function
- STOREDSECT.SYSTEM, Storedsect.System
- SYSTEM.ACCOUNT, System.Account
- SYSTEM.CALL, System.Call
- SYSTEM.COUNTER, System.Counter
- SYSTEM.PLAN, System.Plan
- SYSTEM.TRANSACTION, System.Transaction
- SYSTEM.USER, System.User
- PUBLIC
- grant to, Table Type
- granting authorities to, Defining Security Levels
- special DBEUserID, Using UPDATE STATISTICS on System Views
- PURGEFILE, Starting a New Log, Dropping a DBEFile
- PURGELOG
- syntax, PURGELOG
R- re-preprocessing, Causes for Invalidation of Sections
- avoiding, Avoiding the Need for Re-Preprocessing
- REAL
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- recompile dynamically, Invalidation and Revalidation of Sections
- recovery
- in archive mode, Archive Recovery Procedures
- in nonarchive mode, Nonarchive Full Recovery Procedures
- overview, Backup and Recovery
- rollback, Rollback Recovery
- recreating
- indexes, Dropping and Recreating an Index
- rules and procedures, Dropping and Recreating Rules and Procedures
- REFERENCES authority
- explained, Controlling Table Access with Authorities
- listed in SYSTEM.COLAUTH, System.Colauth
- REFERENCES clause
- defining referential constraints with, Referential Constraints
- referential constraint
- creating tables with, Referential Constraints
- entries in SYSTEM.CONSTRAINT, System.Constraint
- entries in SYSTEM.CONSTRAINTCOL, System.Constraintcol
- entries in SYSTEM.CONSTRAINTINDEX, System.ConstraintIndex
- RELEASE, Managing DBEnvironment Sessions
- SQLGEN, RELEASE
- terminating a DBE session with, Using RELEASE
- remote databases
- accessing, Remote Database Access
- REMOVE DBEFILE
- example, Dropping a DBEFile
- REMOVE FROM GROUP
- example, Granting/Revoking RESOURCE Authority
- syntax, Managing Authorization Groups
- removing all rows
- TRUNCATE TABLE statement, Making Changes to a New Log File
- renaming
- columns, Renaming Tables or Columns
- tables, Renaming Tables or Columns
- REPAIR
- in SQLMigrate, REPAIR
- repeating data groups
- removing in normalization, First Normal Form
- replicate
- DBE using SQLmigrate, Types of Forward Migration
- parameter, Using SQLGEN
- RESCUELOG
- syntax, RESCUELOG
- reserved users
- CATALOG, Views owned by SYSTEM and CATALOG
- HPRDBSS, System Catalog
- PUBLIC, Defining Security Levels, Granting Authorities to PUBLIC
- SYSTEM, Views owned by SYSTEM and CATALOG
- TEMP, Defining Authorization Groups
- RESOURCE authority, Granting/Revoking RESOURCE Authority
- defined, Special Authorities
- resource authority
- listed in SYSTEM.SPACEAUTH, System.Spaceauth
- RESTORELOG
- syntax, RESTORELOG
- restoring
- data with RESTORE, Nonarchive Full Recovery Procedures, Full Rollforward Recovery, Partial Rollforward Recovery
- logs with RESTORELOG, Full Rollforward Recovery, Partial Rollforward Recovery
- revalidate
- procedure sections, Validating Procedure Sections
- revalidating
- application program sections, Invalidation and Revalidation of Sections
- sections, Causes for Invalidation of Sections
- REVOKE, Avoiding the Need for Re-Preprocessing
- CONNECT authority, Granting/Revoking CONNECT Authority
- example, Granting/Revoking RUN Authority
- EXECUTE authority, Granting/Revoking EXECUTE Authority
- RESOURCE authority, Granting/Revoking RESOURCE Authority
- SELECT ON, Authorities for Single Users
- revoking
- procedure authorities, Granting and Revoking Procedure Authorities
- SECTIONSPACE authority, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- TABLESPACE authority, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- rollback recovery
- explained, Rollback Recovery
- rollforward
- wrapperDBE, Setting up a Wrapper DBEnvironment
- rollforward recovery
- archive log files, Logs and Recovery
- explained, Full Rollforward Recovery, Partial Rollforward Recovery
- root level of a tree , Designing Indexes
- row
- calculating length, Calculating Row Length
- calculating rows per page, Calculating Rows per Page
- formula for length, Defining Column Size
- length, Calculating Row Length
- maximum length, Defining Tables
- rule
- columns in the system catalog, System.RuleColumn
- creating, Creating a Rule
- determining behavior in a DBEnvironment, Determining Behavior of Rules in a DBEnvironment Session
- dropping and recreating, Dropping and Recreating Rules and Procedures
- effects on loading tables, Loading Tables with Rules Built on Them
- entries in SYSTEM.RULE, System.Rule
- examining in the system catalog, Examining the Inventory of Rules and Procedures
- maintaining, Maintaining Rules and Procedures
- RUN authority
- for modules, Module Related Authorities
- granting, Granting/Revoking RUN Authority
- in system catalog, System.Modauth
- run tree, Calculating Space Needed for Sections, Invalidation and Revalidation of Sections
- runtime control blocks
- setting in DBECon file, Adjusting Startup Values
- setting number in SQLUtil, Adjusting Startup Values
- shared memory for, Estimating Shared Memory Requirements, Estimating Runtime Control Block Buffer Pages
S- sample DBEnvironment
- contents of, Defining the DBEnvironment Scope
- tables, Final Form of Sample Database Tables
- schema
- database, Creating a Database Schema
- SQLGEN, Using SQLGEN
- schema file
- creating with SQLGEN, SET SCHEMA
- search item, Determining Index Keys, How Index Keys are Used
- second normal form
- defined, Second Normal Form
- section
- and SYSTEM.SECTION view, System.Section
- and SYSTEM.SETOPTINFO view, System.Setoptinfo
- and UPDATE STATISTICS, Updating System Catalog Statistics
- calculating space, Calculating Space Needed for Sections
- default DBEFileSet, Assigning Default DBEFileSets
- disk space for, Calculating Space Needed for Sections
- invalidating, Dropping Tables, Dividing Tables, Invalidation and Revalidation of Sections, Information in the System Catalog on Validity of Sections, Causes for Invalidation of Sections
- revalidating, Causes for Invalidation of Sections
- statements that do not create, Invalidation and Revalidation of Sections
- stored in catalog, Storage of Sections
- types, Information in the System Catalog on Validity of Sections
- valid, Invalidation and Revalidation of Sections
- valid and invalid, Invalidation and Revalidation of Sections
- validating and invalidating, Invalidation and Revalidation of Sections
- SECTIONSPACE authority
- defined, Space Authorities
- granting, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- revoking, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- SECTIONSPACE default DBEFileSet, Assigning Default DBEFileSets
- security
- creating DBEnvironment security scheme, Creating the DBEnvironment Security Scheme
- management, Defining Security Levels
- specifying when creating a table, Creating Tables
- SELECT authority
- and views, Controlling Table Access with Views
- explained, Controlling Table Access with Authorities
- selectlist, Creating Views
- sequence number
- for log files, Sequence Numbers
- wrapperDBE, Single Logs, Wrapping the DBEnvironment Around the Log Files
- sequential search, Determining Index Keys
- SET, SET
- set
- connect to DBEnvironment, SET DBENVIRONMENT
- recoverfile, SET RECOVERFILE
- SQLAudit, SET
- SET CONSTRAINTS DEFERRED
- used when loading tables, Loading Tables with Constraints on Them
- SET DBEnvironment
- SQLAudit, SET DBENVIRONMENT
- SET DML ATOMICITY
- used when loading tables, Loading Tables with Constraints on Them
- SET ECHO_ALL
- in SQLAudit, SET ECHO_ALL
- SET EDITOR
- SQLAudit, SET EDITOR
- SQLGEN, SET EDITOR
- SET RECOVERFILE
- SQLAudit, SET RECOVERFILE
- SET SCHEMA
- SQLGEN, SET SCHEMA
- set up rollforward
- SETUPRECOVERY PARTIAL, SETUPRECOVERY PARTIAL
- SET_EXIT_DBERR
- syntax, SET EXIT_ON_DBERR
- SETOPT
- and SYSTEM.SETOPTINFO view, System.Setoptinfo
- SETUPRECOVERY PARTIAL
- set up rollforward, SETUPRECOVERY PARTIAL
- shared memory
- data buffer, Estimating Data Buffer Pages
- estimating requirements, Estimating Shared Memory Requirements
- for log buffer, Estimating Log Buffer Pages
- requirements for buffers, Estimating Shared Memory Requirements
- runtime control block buffer, Estimating Runtime Control Block Buffer Pages
- transactions, Estimating the Number of Transactions
- SHOW 'DBEnvironmentName' VERSION, SHOW 'DBEnvironmentName' VERSION
- in SQLMigrate, SHOW 'DBEnvironmentName' VERSION
- SHOW AUDITPOINT
- syntax , SHOW AUDITPOINT
- SHOW VERSIONS
- in SQLMigrate, SHOW VERSIONS
- SHOWDBE, Examining DBECon Parameters
- display DBE attributes, SHOWDBE
- wrapperDBE, Selecting Log Files when the DBECon File is Inaccessible, Wrapping the DBEnvironment Around the Log Files
- SHOWLOG
- syntax, SHOWLOG
- using to monitor log file usage, Monitoring the Log with SHOWLOG
- wrapperDBE, Selecting Valid Log Files with SHOWLOG
- SHOWSET
- in SQLUtil, SHOWSET
- simple key, Determining Index Keys
- simple operations
- in maintenance, Using Simple and Complex Maintenance Operations
- single file
- logging type, Using Single or Dual Logs
- single user mode
- and starting a DBE session, Using START DBE
- changing to, Adjusting Startup Values
- DBE session, Starting and Stopping DBE Sessions
- setting in DBECon file, Adjusting Startup Values
- size of log file, Example of Setting Up an Audit DBEnvironment
- SMALLINT
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- soft crash, Logs and Recovery
- and rollback recovery, Archive Recovery Procedures
- sort ordering, Determining Index Keys
- special authority
- DBA authority, Using DBA Authority
- listed in SYSTEM.SPACEAUTH, System.Spaceauth
- listed in SYSTEM.SPACEDEFAULT, System.Spacedefault
- listed in SYSTEM.SPECAUTH, System.Specauth
- SQL statements
- authorities required for, Authorities Required by ALLBASE/SQL Statements
- locks obtained by, Locks Held on the System Catalog by SQL Statements
- syntax summary, SQL Syntax Summary
- SQLAudit
- overview, Using SQLAudit
- SQLAudit commands
- audit[point], AUDIT
- editor, EDITOR
- exit, EXIT
- get audit[point], GET AUDITPOINT
- help, HELP
- lock audit[point], LOCK AUDITPOINT
- modify audit[point], MODIFY AUDITPOINT
- quit, QUIT
- set, SET
- set DBEnvironment, SET DBENVIRONMENT
- set echo, SET ECHO_ALL
- set editor, SET EDITOR
- set recoverfile, SET RECOVERFILE
- set_exit_dberr, SET EXIT_ON_DBERR
- show audit[point], SHOW AUDITPOINT
- unlock audit[point], UNLOCK AUDITPOINT
- SQLCore
- and null values, Defining Null Values For Columns
- and pseudotables, Views owned by SYSTEM and CATALOG
- system statistics used by, System.Counter
- SQLGEN
- command summary, SQLGEN Commands
- introduction, Using SQLGEN
- schema, Using SQLGEN
- schema files, SQLGEN Schema Files
- starting up, Starting SQLGEN
- SQLGEN commands
- EDITOR, EDITOR
- EXIT, EXIT
- GENERATE ALL, GENERATE ALL
- GENERATE DBE, GENERATE DBE
- GENERATE DBEFILES, GENERATE DBEFILES
- GENERATE DEFAULTSPACE, GENERATE DEFAULTSPACE
- GENERATE GROUPS, GENERATE GROUPS
- GENERATE INDEXES, GENERATE INDEXES
- GENERATE INSTALLAUTH, GENERATE INSTALLAUTH
- GENERATE LOAD, GENERATE LOAD
- GENERATE MODAUTH, GENERATE MODAUTH
- GENERATE MODOPTINFO, GENERATE MODOPTINFO
- GENERATE PARTITION, GENERATE PARTITION
- GENERATE PROCAUTH, GENERATE PROCAUTH
- GENERATE PROCEDURES, GENERATE PROCEDURES
- GENERATE PROCOPTINFO, GENERATE PROCOPTINFO
- GENERATE RULES, GENERATE RULES
- GENERATE SPACEAUTH, GENERATE SPACEAUTH
- GENERATE SPECAUTH, GENERATE SPECAUTH
- GENERATE STATISTICS, GENERATE STATISTICS
- GENERATE TABAUTH, GENERATE TABAUTH
- GENERATE TABLES, GENERATE TABLES
- GENERATE TEMPSPACES, GENERATE TEMPSPACES
- GENERATE VIEWAUTH, GENERATE VIEWAUTH
- GENERATE VIEWS, GENERATE VIEWS
- HELP, HELP
- RELEASE, RELEASE
- SET EDITOR, SET EDITOR
- SET SCHEMA, SET SCHEMA
- STARTDBE, STARTDBE
- SQLINSTL
- overview, Using SQLINSTL
- SQLMigrate
- nonreplicate DBE, Types of Forward Migration
- overview, Using SQLMigrate
- replicate DBE, Types of Forward Migration
- starting up, Running SQLMigrate
- SQLMigrate commands
- ADD DBEFile, ADD DBEFILE, CREATE DBEFILE
- EXIT, EXIT
- HELP, HELP
- MIGRATE, MIGRATE
- PREVIEW, PREVIEW
- QUIT, QUIT
- REPAIR, REPAIR
- SHOW 'DBEnvironmentName' VERSION, SHOW 'DBEnvironmentName' VERSION
- SHOW VERSIONS, SHOW VERSIONS
- SQLMON
- available DBEFileset space, Managing DBEFiles and DBEFileSets
- cluster count, Monitoring the Cluster Count
- examining DBEFilesets, Creating DBEFileSets
- hash structures, Dropping and Recreating Hash Structures
- index space, Monitoring Index Space
- monitoring the log, Monitoring the Log with SQLMON
- overview, Using SQLMON
- stored sections, Determining Available Space for Sections
- table information, Examining Table Attributes
- SQLUtil
- ATTACHFILE, Moving DBEFiles to Different Groups
- CHANGELOG, Using Console Message Files
- CHECKPOINT, Detaching and Attaching Database Files
- DETACHFILE, Moving DBEFiles to Different Groups
- example, Examining DBECon Parameters
- log file, Defining Additional Audit DBEnvironment Log Files
- MOVEFILE, DBEFiles in Different Groups and Volumes
- SQLUtil commands
- ADDLOG, Defining Additional Audit DBEnvironment Log Files, ADDLOG
- PURGELOG, PURGELOG
- RESCUELOG, RESCUELOG
- RESTORELOG, RESTORELOG
- SHOWLOG, SHOWLOG
- SHOWSET, SHOWSET
- WRAPDBE, WRAPDBE
- START
- in ISQL, Using ISQL
- START DBE, Managing DBEnvironment Sessions
- example, Starting a DBE Session in Single-User Mode
- single user, Using START DBE
- startup parameters, Starting a DBE Session in Single-User Mode
- syntax, Using START DBE
- START DBE NEW
- and dual log files, Sample Log Configuration
- configuring a DBE, Using START DBE NEW
- creating a log file, Log Files
- elements created, Supplying Startup Parameters with START DBE NEW
- example, Calculating Storage for the System Catalog, Supplying Startup Parameters with START DBE NEW
- wrapperDBE, Selecting Log Files when the DBECon File is Inaccessible
- START DBE NEWLOG
- changing dual logging, Starting a New Log
- creating a new log file, Starting a New Log
- example, Starting a New Log
- STARTDBE
- SQLGEN, STARTDBE
- starting DBE sessions
- with CONNECT, Starting and Stopping DBE Sessions
- with START DBE, Starting and Stopping DBE Sessions
- startup parameter, Using START DBE NEW
- adjusting in DBECon file, Adjusting Startup Values
- default, Using START DBE NEW
- defaults, Adjusting Startup Values
- in DBECon file, Using START DBE NEW
- statements
- dynamic, Module Related Authorities
- static backup
- in archive mode, Static Full or Partial Backup Procedures in Archive Mode
- with nonarchive logging, Nonarchive Backup Procedures
- statistical data
- updating, Using UPDATE STATISTICS on System Views
- STOP DBE, Managing DBEnvironment Sessions
- terminating DBE sessions, Using STOP DBE
- storage requirements
- for specific data types, Calculating Row Length
- overview, Physical Design
- stored section
- and validation, Invalidation and Revalidation of Sections
- when stored, Storage of Sections
- STOREDSECT
- as owner of system section tables, Changing System Table Lock Types
- reserved user, System Catalog
- STOREDSECT.SYSTEM
- defined, Storedsect.System
- STOREINFO
- list archived files, STOREINFO
- syntax
- WRAPDBE command, WRAPDBE
- syntax summary
- ISQL, ISQL Syntax Summary
- SQL statements, SQL Syntax Summary
- SYSTEM
- reserved user, Views owned by SYSTEM and CATALOG
- system catalog
- after configuration, Supplying Startup Parameters with START DBE NEW
- allocating disk space, Calculating Storage for the System Catalog
- CATALOG views, Views owned by SYSTEM and CATALOG
- complete information and tables, System Catalog
- disk space for, Calculating Storage for the System Catalog
- element in a DBEnvironment, Creating Logical and Physical Objects
- examining, Examining the System Catalog
- example, Examining the System Catalog
- locks, Sharing Modules Between DBEnvironments
- locks obtained by SQL statements, Locks Held on the System Catalog by SQL Statements
- locks on, Judging Maintenance Expenses
- monitoring space, Maintaining the DBEnvironment
- owners HPRDBSS, CATALOG, and SYSTEM, Views owned by SYSTEM and CATALOG
- pseudotable functions, Summary of System Catalog Views by Function
- pseudotables, Views owned by SYSTEM and CATALOG
- rule columns, System.RuleColumn
- rules, System.Rule
- sizeo, Storage of Definitions for Newly Created Objects
- statements that add to, Storage of Definitions for Newly Created Objects
- SYSTEM views, Views owned by SYSTEM and CATALOG
- updating, Updating System Catalog Statistics
- view constraint information store in, Creating Views
- view definitions stored in, Creating Views
- SYSTEM DBEFileSet
- adding space to, Maintaining the DBEnvironment
- defined, Calculating Storage for the System Catalog
- determining space in, Calculating Space Needed for Sections
- in a new DBEnvironment, Supplying Startup Parameters with START DBE NEW
- system table, System Catalog Views
- lock type changing, Changing System Table Lock Types
- system views
- containing security data, Using the WITH GRANT OPTION Clause and Authorization Groups
- in the system catalog, Views owned by SYSTEM and CATALOG
- listed, Examining the System Catalog
- restricting catalog access, Controlling Table Access with Views
- SYSTEM.ACCOUNT
- column definition and description, System.Account
- SYSTEM.CALL
- column definition and description, System.Call
- SYSTEM.CHECKDEF
- column definition and description, System.CheckDef
- view constraint information stored in, Creating Views
- SYSTEM.COLAUTH
- column definition and description, System.Colauth
- SYSTEM.COLDEFAULT
- column definition and description, System.Coldefault
- SYSTEM.COLUMN
- affected by UPDATE STATISTICS, Updating System Catalog Statistics
- column definition and description, System.Column
- querying, Examining Table Attributes
- SYSTEM.CONSTRAINT
- column definition and description, System.Constraint
- view constraint definitions stored in, Creating Views
- SYSTEM.CONSTRAINTCOL
- column definition and description, System.Constraintcol
- SYSTEM.CONSTRAINTINDEX
- column definition and description, System.ConstraintIndex
- SYSTEM.COUNTER
- column definition and description, System.Counter
- SYSTEM.DBEFILE
- affected by UPDATE STATISTICS, Updating System Catalog Statistics
- characteristics of files stored in, Creating DBEFiles
- column definition and description, System.DBEFile
- DBEFileSet names stored in, Adding DBEFiles to DBEFileSets
- names of files stored in, Creating DBEFiles
- SYSTEM.DBEFILESET
- affected by UPDATE STATISTICS, Updating System Catalog Statistics
- column definition and description, System.DBEFileSet
- names stored in, Creating DBEFileSets
- SYSTEM.GROUP
- column definition and description, System.Group
- SYSTEM.HASH
- column definition and description, System.Hash
- SYSTEM.IMAGEKEY
- column definition and description, System.Imagekey
- SYSTEM.INDEX
- affected by UPDATE STATISTICS, Updating System Catalog Statistics
- and cluster count, Monitoring the Cluster Count
- column definition and description, System.Index
- SYSTEM.INSTALLAUTH
- column definition and description, System.Installauth
- SYSTEM.MODAUTH
- column definition and description, System.Modauth
- SYSTEM.PARAMDEFAULT
- column definition and description, System.Paramdefault
- SYSTEM.PARAMETER
- column definition and description, System.Parameter
- SYSTEM.PLAN
- column definition and description, System.Plan
- SYSTEM.PROCAUTH
- column definition and description, System.Procauth
- SYSTEM.PROCEDURE
- column definition and description, System.Procedure
- SYSTEM.PROCEDUREDEF
- column definition and description, System.ProcedureDef
- SYSTEM.PROCRESULT
- column definition and description, System.ProcResult
- SYSTEM.RULE
- column definition and description, System.Rule
- SYSTEM.RULECOLUMN
- column definition and description, System.RuleColumn
- SYSTEM.SECTION
- column definition and description, System.Section
- monitoring stored sections in, Information in the System Catalog on Validity of Sections
- view definitions stored in, Creating Views
- SYSTEM.SETOPTINFO
- column definition and description, System.Setoptinfo
- SYSTEM.SPACEAUTH
- column definition and description, System.Spaceauth
- SYSTEM.SPACEDEFAULT
- column definition and description, System.Spacedefault
- SYSTEM.SPECAUTH
- column definition and description, System.Specauth
- SYSTEM.TABAUTH
- column definition and description, System.Tabauth
- SYSTEM.TABLE
- affected by UPDATE STATISTICS, Updating System Catalog Statistics
- column definition and description, System.Table
- examining table definitions in, Examining Table Attributes
- querying, Examining Table Attributes
- view definitions stored in, Creating Views
- SYSTEM.TEMPSPACE
- column definition and description, System.TempSpace
- SYSTEM.TPINDEX
- column definition and description, System.TPIndex
- SYSTEM.TRANSACTION
- column definition and description, System.Transaction
- SYSTEM.USER
- column definition and description, System.User
- monitoring, to show current users, Using TERMINATE USER
- SYSTEM.VIEWDEF
- column definition and description, System.ViewDef
T- table
- adding a column to, Adding Columns
- adding constraint to, Adding Constraints
- as type of DBEFile, Understanding DBEFile Characteristics
- authorities, Controlling Table Access with Authorities
- changing lock mode, Changing a Table's Locking Behavior
- creating, Creating Tables
- DBEFile, Using Separate DBEFiles for Tables and Indexes
- DBEFileSet, Grouping Tables in DBEFileSets
- DBEFileSet specification, DBEFileSet Name
- default DBEFileSet, Assigning Default DBEFileSets
- deleting a column to, Deleting Columns
- deleting all rows, Dropping Tables
- design, Arranging Data in Tables
- disk space for, Calculating Storage for Tables
- dividing, Dividing Tables
- double quotes, Owner and Table Name
- dropping, Dropping Tables
- dropping constraint from, Dropping Constraints
- examining definitions, Examining Table Attributes
- for sample database, Final Form of Sample Database Tables
- implicit locking, Table Type
- implied security, Table Type
- in DBEFileSet, Understanding DBEFile Characteristics, DBEFileSet Name
- loading, Loading Tables
- loading external files, Loading from an External File
- loading internal file, Loading from an Internal File
- locking, Table Type
- maximum column length, ALLBASE/SQL Limits
- maximum columns per, ALLBASE/SQL Limits
- maximum per DBEnvironment, ALLBASE/SQL Limits
- merging columns, Merging Tables
- name, Owner and Table Name
- organizing in DBEFileSets, Arranging Tables and Indexes in DBEFileSets
- owner, Owner and Table Name
- partition, Defining Partitions and Tables, System Catalog Views
- private, Table Type
- public, Table Type
- publicread, Table Type
- renaming, Renaming Tables or Columns
- restrictions, Defining Tables
- revoking authority for, Revoking Table and View Authorities
- separate disk drives, Grouping Tables in DBEFileSets
- stored in mixed DBEFile, Using a Single MIXED DBEFile
- system, System Catalog Views
- unloading, Deleting Columns
- TABLESPACE authority
- defined, Space Authorities
- granting, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- revoking, Granting/Revoking SECTIONSPACE or TABLESPACE Authority
- TABLESPACE default DBEFileSet, Assigning Default DBEFileSets
- tasks
- adding a column, Adding Columns
- adding a constraint to a table, Adding Constraints
- adding DBEFiles to DBEFileSets, Adding a New DBEFile
- adding log files with ADDLOG, Adding Log Files with ADDLOG
- backup and recovery, Backup and Recovery
- backup in nonarchive mode, Nonarchive Backup Procedures
- changing a table's lock mode, Changing a Table's Locking Behavior
- changing DBEFile type, Changing DBEFile Type
- cleanup after abnormal termination, Cleaning Up after Abnormal Termination
- creating a DBEnvironments, Using START DBE NEW
- creating a hash structure, Creating Hash Structures
- creating a new log file, Starting a New Log
- creating a procedure, Creating a Procedure
- creating a rule, Creating a Rule
- creating a table, Creating Tables
- creating a view, Creating Views
- creating an index, Creating Indexes
- creating DBEFiles and DBEFileSets, Creating DBEFileSets and DBEFiles
- creating DBEnvironment security scheme, Creating the DBEnvironment Security Scheme
- creating log files, Log Files
- creating logical and physical objects, Creating Logical and Physical Objects
- creating the database security scheme, Creating the Database Security Scheme
- defining a database schema, Creating a Database Schema
- deleting a column, Deleting Columns
- deleting table rows, Dropping Tables
- displaying log file information with SHOWLOG, Monitoring the Log with SHOWLOG
- dividing tables, Dividing Tables
- dropping a constraint from a table, Dropping Constraints
- dropping a DBEFile, Dropping a DBEFile
- dropping a table, Dropping Tables
- dropping and recreating hash structures, Dropping and Recreating Hash Structures
- dropping and recreating indexes, Dropping and Recreating an Index
- dropping and recreating procedures, Dropping and Recreating Rules and Procedures
- dropping and recreating rules, Dropping and Recreating Rules and Procedures
- dropping modules, Dropping Modules
- enabling and disabling data definition, Disabling Data Definition
- enabling and disabling rule operation, Determining Behavior of Rules in a DBEnvironment Session
- examining the system catalog, Examining the System Catalog
- granting and revoking procedure authorities, Granting and Revoking Procedure Authorities
- indexes, Maintaining Indexes
- loading tables, Loading Tables
- maintaining applications, Maintaining Applications
- maintaining rules and procedures, Maintaining Rules and Procedures
- maintenance, Maintenance
- managing log files, Managing Log Files
- merging tables, Merging Tables
- moving log files with MOVELOG, Moving Log Files with MOVELOG
- online backup in archive mode, Online Backup Procedures in Archive Mode
- purging log files with PURGELOG, Purging Log Files with PURGELOG
- recovering log files with RECOVERLOG, Restoring Log Files with RESTORELOG
- recovery in nonarchive mode, Nonarchive Full Recovery Procedures
- reloading tables, Reloading a Table to Improve Index Performance
- rescuing log files with RESCUELOG, Rescuing Log Files with RESCUELOG
- restoring log files with RESTORELOG, Restoring Log Files with RESTORELOG
- revalidating procedure sections, Validating Procedure Sections
- revoking table authorites, Revoking Table and View Authorities
- rollforward recovery in archive mode, Full Rollforward Recovery, Partial Rollforward Recovery
- starting and stopping DBE sessions, Starting and Stopping DBE Sessions
- static backup in archive mode, Static Full or Partial Backup Procedures in Archive Mode
- storing log files with STORELOG, Storing Log Files with STORELOG
- updating groups, Maintaining Security
- updating system catalog statistics, Updating System Catalog Statistics
- temporary index
- and performance, Dropping and Recreating an Index
- tempspace
- creating, Calculating Temporary Disk Space
- TERMINATE QUERY, Terminating Transactions and Queries
- TERMINATE TRANSACTION, Terminating Transactions and Queries
- TERMINATE USER, Using TERMINATE USER
- terminating a DBE session
- using RELEASE, Using RELEASE
- using STOP DBE, Using STOP DBE
- using TERMINATE USER, Using TERMINATE USER
- third normal form, Third Normal Form
- TIME
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- timeout value
- and DBECon file, Using START DBE NEW
- changing in SQLUtil, Adjusting Startup Values
- default in DBECon file, Adjusting Startup Values
- maximum, ALLBASE/SQL Limits
- maximum in DBECon file, Adjusting Startup Values
- transaction
- changing maximum in SQLUtil, Adjusting Startup Values
- concurrent, Example
- defined, Managing Transactions and Locks
- estimating number, Estimating the Number of Transactions
- implicitly begun, Log Records and Transactions
- priority, System.Transaction
- setting maximum number of, Adjusting Startup Values
- shared memory for block buffer, Estimating Shared Memory Requirements
- SYSTEM.TRANSACTION, System.Transaction
- TRANSFER OWNERSHIP, Avoiding the Need for Re-Preprocessing
- syntax, Managing Authorization Groups
- transfer ownership
- and CONNECT authority, Granting/Revoking CONNECT Authority
- transitive dependency, Second Normal Form
- TRUNCATE TABLE, Dropping Tables
- removing all rows, Making Changes to a New Log File
- tuple header, Defining Column Data Type
- types of DBEFile
- table and mixed, Using Separate DBEFiles for Tables and Indexes
U- unavailable DBECon file
- wrapperDBE, Dual Logs
- unique constraint
- creating, Unique Constraints
- entries in SYSTEM.CONSTRAINT, System.Constraint
- entries in SYSTEM.CONSTRAINTCOL, System.Constraintcol
- entries in SYSTEM.CONSTRAINTINDEX, System.ConstraintIndex
- unique index
- defined, Determining Index Type
- design, Defining Unique Indexes
- guidelines for, Defining Unique Indexes
- UNLOAD
- creating files from tables, Loading Tables
- for restructuring, Deleting Columns
- GENERATE LOAD, GENERATE LOAD
- in deleting columns, Deleting Columns
- in maintenance operations, Using Simple and Complex Maintenance Operations
- internal, Merging Tables
- unlock audit point
- audit tool, UNLOCK AUDITPOINT
- UPDATE authority
- and views, Controlling Table Access with Views
- explained, Controlling Table Access with Authorities
- listed in SYSTEM.COLAUTH, System.Colauth
- UPDATE STATISTICS
- example, Updating System Catalog Statistics
- invalidating sections, Causes for Invalidation of Sections
- on system views, Using UPDATE STATISTICS on System Views
- overview, Updating System Catalog Statistics
- updating cluster count, Monitoring the Cluster Count
- when to use, Updating System Catalog Statistics
- updates
- wrapperDBE, Selecting Log Files when the DBECon File is Inaccessible, Wrapping the DBEnvironment Around the Log Files
- usable log files
- wrapperDBE, Setting up a Wrapper DBEnvironment
- user mode
- adjusting parameter in DBECon file, Adjusting Startup Values
- changing with SQLUtil, Adjusting Startup Values
- setting in DBECon file, Adjusting Startup Values
- user timeout value
- changing in SQLUtil, Adjusting Startup Values
- setting in DBECon file, Adjusting Startup Values
V- VALIDATE, Information in the System Catalog on Validity of Sections, Causes for Invalidation of Sections
- revalidating procedure sections, Validating Procedure Sections
- validating
- application program sections, Invalidation and Revalidation of Sections
- modules, Avoiding the Need for Re-Preprocessing
- VARBINARY
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- VARCHAR
- defining columns as, Defining Column Data Type
- storage requirements, Calculating Row Length
- view
- and SYSTEM.SECTION, System.Section
- as a stored section, Creating Views
- authorities, Controlling Table Access with Authorities
- creating
- view, Creating Views
- data access, Designing Views
- design, Designing Views
- dropping, Dropping Tables
- granting authorities for, Controlling Table Access with Views
- maximum base tables per, ALLBASE/SQL Limits
- maximum columns per, ALLBASE/SQL Limits
- maximum per DBEnvironment, ALLBASE/SQL Limits
- name, Creating Views
- owner, Creating Views
- restructuring with, Merging Tables
- revoking authority for, Revoking Table and View Authorities
- security applications, Controlling Table Access with Views
- WITH CHECK OPTION, Creating Views
- virtual table, Designing Views
W- WITH CHECK OPTION
- view, Creating Views
- WITH GRANT OPTION clause
- examples, Using the GRANT OPTION Clause
- WRAPDBE
- syntax, WRAPDBE
- wrapperDBE, Setting up a Wrapper DBEnvironment, Creating a DBEnvironment, Wrapping the DBEnvironment Around the Log Files
- wrapperDBE
- archive logging, Setting up a Wrapper DBEnvironment
- audit information, Setting up a Wrapper DBEnvironment
- audit parameters, Selecting Log Files when the DBECon File is Inaccessible
- audit tool, Setting up a Wrapper DBEnvironment
- command mode, Wrapping the DBEnvironment Around the Log Files
- console log file, Dual Logs, Selecting Log Files when the DBECon File is Inaccessible
- DBECon file, Setting up a Wrapper DBEnvironment, Dual Logs
- DDL statements, Creating a DBEnvironment
- dual log files, Single Logs
- inactive log files, Creating a DBEnvironment
- log files, Setting up a Wrapper DBEnvironment, WRAPDBE
- log files, number of, Wrapping the DBEnvironment Around the Log Files
- not usable log files, Dual Logs
- orphaned log files, Setting up a Wrapper DBEnvironment
- roll forward, Setting up a Wrapper DBEnvironment
- sequence number, Single Logs, Wrapping the DBEnvironment Around the Log Files
- SHOWDBE command, Selecting Log Files when the DBECon File is Inaccessible, Wrapping the DBEnvironment Around the Log Files
- SHOWLOG command, Selecting Valid Log Files with SHOWLOG
- single log files, Selecting Valid Log Files with SHOWLOG
- START DBE NEW, Selecting Log Files when the DBECon File is Inaccessible
- unavailable DBECon file, Dual Logs
- updates, Selecting Log Files when the DBECon File is Inaccessible, Wrapping the DBEnvironment Around the Log Files
- usable log files, Setting up a Wrapper DBEnvironment
- WRAPDBE command, Setting up a Wrapper DBEnvironment, Creating a DBEnvironment
- writeahead logging
- explained, Managing ALLBASE/SQL Logs
|
