 |
» |
|
|
|
A- access mode
- change for DBEFiles, ATTACHFILE, MOVEFILE
- 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
- ALTDBE
- syntax, ALTDBE
- 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, Storing DBEFiles on Different Devices
- SQLUtil, Storing DBEFiles on Different Devices
- syntax, ATTACHFILE
- 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
- setting with SQLUtil, ALTDBE
- startup value, Using START DBE NEW
- autostart mode
- and user mode, Using Autostart
- changing in SQLUtil, Adjusting Startup Values, ALTDBE
- defined, Using Autostart
- displaying with SQLUtil, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- procedures, Using Autostart
- setting in DBECon file, Adjusting Startup Values
B- B-tree, Designing Indexes, Calculating Storage for Indexes
- backup
- creating with SQLUtil STORE, STORE
- creating with SQLUtil STOREONLINE, STOREONLINE
- 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
- SET BACKUP in SQLUtil, SET
- SQLUtil STORE, Nonarchive Backup Procedures
- SQLUtil STORE PARTIAL, STORE PARTIAL
- SQLUtil STOREONLINE PARTIAL, STOREONLINE PARTIAL
- 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 raw files, Calculating Disk Space Needed for the File
- 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
- syntax, CHANGELOG
- 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
- CHECKPOINTHELP
- syntax, CHKPTHLP
- 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
- 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
- changing number of pages, ALTDBE
- displaying number of pages, SHOWDBE-STARTPARMS
- pages displaying with SQLUtil, SHOWDBE-ALL
- 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 file
- raw file as, Creating a Database Object
- 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, ALTDBE
- 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
- purging, PURGEALL, PURGEDBE
- SHOWDBE-ALL, SHOWDBE-ALL
- 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 restoring, RESTORE
- and restoring partial, RESTORE PARTIAL
- 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
- access, DETACHFILE
- access mode change, ATTACHFILE, MOVEFILE
- 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
- device change, ATTACHFILE, CHANGELOG, MOVEFILE
- 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
- purging, PURGEALL, PURGEDBE, PURGEFILE
- 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
- using raw file as, Setting up Raw Files
- 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
- displaying name with SQLUtil, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- element in a DBEnvironment, Creating Logical and Physical Objects
- in a new DBEnvironment, Supplying Startup Parameters with START DBE NEW
- purging, PURGEALL, PURGEDBE, PURGEFILE
- setting in DBECon file, Adjusting Startup Values
- DBEFileSet, Understanding DBEFile Characteristics
- access, DETACHFILE
- 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
- naming, ALTDBE
- recovery, Archive Recovery Procedures
- recreating with SQLGEN, Using SQLGEN
- sample, Defining the DBEnvironment Scope
- starting, Using START DBE
- starting with SQLGEN, STARTDBE
- startup parameters, SHOWDBE-STARTPARMS
- 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, ALTDBE
- 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, Storing DBEFiles on Different Devices
- SQLUtil, Storing DBEFiles on Different Devices
- syntax, DETACHFILE
- device change for DBEFiles, ATTACHFILE, MOVEFILE
- 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
- setting up for a DBEnvironment, Setting Up the DBEnvironment Directory
- 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
- before purging, PURGEFILE
- 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- ECHO_ALL
- SET in SQLGEN, SET ECHO_ALL OFF
- SET in SQLUtil, SET
- EDITOR
- SQLGEN, EDITOR
- editor
- syntax, EDITOR
- ENDRECOVERY
- syntax, ENDRECOVERY
- 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
- from SQLUtil, EXIT
- exit on error
- SQLAudit, SET EXIT_ON_DBERR
- exit status
- checking, Checking the Exit Status
- setting, Checking the Exit Status
- EXIT_ON_DBERR
- SET in SQLUtil, SET
- EXIT_ON_DBERR OFF
- SET in SQLGEN, SET EXIT_ON_DBERR OFF
- 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
- SQLUtil, 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
- 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
- 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
L- LANG clause
- in CREATE TABLE, Owner and Table Name
- LANG variable
- setting and resetting, Native Language Support
- language
- current language, Native Language Support
- DBECon file setting, Adjusting Startup Values
- DBEnvironment and current, Specifying a Native Language Parameter
- displaying the DBE's, SHOWDBE-LANG
- in defining tables or columns, Owner and Table Name
- native language support, Native Language Support
- setting and resetting, 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
- changing number of pages, Parameters
- displaying number of pages, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- 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, PURGEALL, PURGEDBE
- purging with PURGELOG, Purging Log Files with PURGELOG, PURGELOG
- raw file as, Creating a Log with Raw Files
- 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
- change for DBEnvironment, CHANGELOG
- 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
- setting SQLUtil maintenance word, SHOWDBE-MAINT
- 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
- changing with SQLUtil, ALTDBE
- setting, SETDBEMAINT, SHOWDBE-MAINT
- 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
- maximum transactions
- changing with SQLUtil, Parameters
- displaying with SQLUtil, SHOWDBE-ALL, SHOWDBE-STARTPARMS
- maxpartitions parameter, Creating Audit DBEnvironments
- media failure
- recovery from, Archive Recovery Procedures
- 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
- syntax, MOVEFILE
- MOVELOG
- syntax, MOVELOG
- 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- n-computer
- defined, Native Language Support
- naming
- double quotes, Creating DBEFileSets
- native language
- current language, Native Language Support
- DBEnvironment and current, Specifying a Native Language Parameter
- defaults, Native Language Support
- displaying the DBE's, SHOWDBE-LANG
- in creating tables, Owner and Table Name
- in DBECon file, Specifying a Native Language Parameter
- in defining columns, Language Clause
- overview, Native Language Support
- setting and resetting, Native Language Support
- shown in SYSTEM.COLUMN, System.Column
- shown in SYSTEM.TABLE, System.Table
- 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
- OMNIBACK
- not supported, SET
- 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
- changing with SQLUtil, ALTDBE
- displaying with SQLUtil, SHOWDBE-ALL
- in DBECon file, Adjusting Startup Values
- startup, Using START DBE NEW
- startup in SQLUtil, SHOWDBE-STARTPARMS
- 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
- 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
- PURGEALL
- syntax, PURGEALL
- PURGEDBE
- syntax, PURGEDBE
- PURGEFILE, Starting a New Log, Dropping a DBEFile
- syntax, PURGEFILE
- PURGELOG
- syntax, PURGELOG
R- raw files
- compared with buffered files, Comparing Raw Files with HP-UX Buffered Files
- setting up, Setting up Raw Files
- using in ALLBASE/SQL, Using HP-UX Raw Files for DBEFiles and Logs
- 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
- RECOVERLOG
- syntax, RECOVERLOG
- 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
- RESTORE
- syntax, RESTORE
- RESTORE PARTIAL
- syntax, RESTORE PARTIAL
- 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
- restoring data
- to raw files, Restoring Data or Moving Data to Raw Files
- restoring logs
- to raw files, Restoring Data or Moving Data to Raw Files
- 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
|
