Assessments - 0, GPA: 0
(
)
)
|
por este dispositivo também tem outras instruções :
Facilidade de uso
Document Outline
- Contents
- DBA Tasks and Tools
- Tasks for the DBA
- Starting and Stopping DBE Sessions
- Establishing Multiple DBEnvironment Connections
- Managing ALLBASE/SQL Logs
- Maintaining Buffers for Data and Log Pages
- Managing Transactions and Locks
- Setting Parameters in the DBECon File
- Monitoring the System Catalog
- Managing Nonstop Production Systems
- Backing Up and Restoring DBEnvironments
- Migrating DBEnvironments Between Releases of ALLBASE/SQL
- Tools for the DBA
- Using ISQL
- Using SQLUtil
- Using SQLGEN
- Using SQLMigrate
- Using SQLINSTL
- Using SQLMON
- SQLVer
- SQLAudit
- Checking the Exit Status
- System Administration for ALLBASE/SQL
- Native Language Support
- Network Administration
- Tasks for the DBA
- Logical Design
- Identifying the Data for Tables
- Normalizing the Data
- First Normal Form
- Second Normal Form
- Third Normal Form
- Arranging Data in Tables
- Defining Tables
- Defining Columns
- Designing Views
- Designing Indexes
- Designing Hash Structures
- Understanding the Hash Function
- Choosing Hash Keys
- Choosing the Number of Primary Pages
- Designing Integrity Constraints
- Defining Security Levels
- Authority Types
- Special Authorities
- Owner Authority
- Table and View Authorities
- RUN Authority
- EXECUTE Authority
- Space Authorities
- Defining Authorization Groups
- Defining Classes
- Defining the DBEnvironment Scope
- Physical Design
- Calculating Storage for Database Objects
- Understanding DBEFile Characteristics
- Calculating Storage for Tables
- Calculating Storage for Indexes
- Arranging Tables and Indexes in DBEFileSets
- Calculating Storage for Hash Structures
- Calculating Storage for Integrity Constraints
- Calculating Storage for the System Catalog
- Calculating Storage for Logging
- Log Records and Transactions
- Using Archive or Nonarchive Logs
- Using Multiple Log Files
- Disk Space for the Log
- Calculating Temporary Disk Space
- Estimating Shared Memory Requirements
- Estimating the Number of Transactions
- Implementing the Design
- Calculating Storage for Database Objects
- DBEnvironment Configuration and Security
- Required MPE/iX Capabilities
- Using START DBE NEW
- Creating Audit DBEnvironments
- Creating DBEFileSets and DBEFiles
- Assigning Default DBEFileSets
- Creating DBEFiles
- Adding DBEFiles to DBEFileSets
- Allocating Expandable DBEFile Space
- Partial DBEFile Expansion
- Creating the DBEnvironment Security Scheme
- Using DBA Authority
- The DBECreator
- Granting/Revoking CONNECT Authority
- Managing DBEnvironment Sessions
- Using START DBE
- Connecting to a DBE
- Setting Timeout Values
- Remote Database Access
- Database Creation and Security
- Creating Tables
- Column Definition
- Constraint Definitions
- Defining Partitions and Tables
- Creating Views
- Creating Hash Structures
- Creating Indexes
- Creating Procedures and Rules
- Creating the Database Security Scheme
- Creating a Database Schema
- Loading Tables
- Creating Tables
- Backup and Recovery
- Choosing an Approach to Backup and Recovery
- Understanding Log File Types
- Choosing Full or Partial Backup Procedures
- Choosing Full or Partial Recovery Procedures
- Backup and Recovery Procedures for Nonarchive Logging
- Backup and Recovery Procedures for Archive Logging
- ALLBASE/SQL Interface to True Online Backup
- Managing Log Files
- Monitoring the Log with SQLMON
- Setting up a Wrapper DBEnvironment
- Maintenance
- Using
- Maintaining the DBEnvironment
- Maintaining Tables
- Dropping and Recreating Hash Structures
- Maintaining Indexes
- Maintaining Constraints
- Maintaining Rules and Procedures
- Maintaining Sets of Interrelated Objects
- Maintaining Applications
- Maintaining a Nonstop Production System
- Maintaining Security
- Disabling Data Definition
- Judging Maintenance Expenses
- Cleaning Up after Abnormal Termination
- System Catalog
- Views owned by SYSTEM and CATALOG
- Storedsect.System
- Storedsect. DBEFileSetName
- System.Account
- System.Call
- System.CheckDef
- System.Colauth
- System.Coldefault
- System.Column
- System.Constraint
- System.Constraintcol
- System.ConstraintIndex
- System.Counter
- System.DBEFile
- System.DBEFileSet
- System.Group
- System.Hash
- System.Imagekey
- System.Index
- System.Installauth
- System.Modauth
- System.Paramdefault
- System.Parameter
- System.Partition
- System.Plan
- System.Procauth
- System.Procedure
- System.ProcedureDef
- System.ProcResult
- System.Rule
- System.RuleColumn
- System.RuleDef
- System.Section
- System.Setoptinfo
- System.Spaceauth
- System.Spacedefault
- System.Specauth
- System.Tabauth
- System.Table
- System.TempSpace
- System.TPIndex
- System.Transaction
- System.User
- System.ViewDef
- ALLBASE/SQL Limits
- Authorities Required by ALLBASE/SQL Statements
- SQL Syntax Summary
- ISQL Syntax Summary
- Locks Held on the System Catalog by SQL Statements
- SQLUtil
- ADDLOG
- ALTDBE
- ATTACHFILE
- CHANGELOG
- DETACHFILE
- ENDRECOVERY
- EXIT
- HELP
- MOVEFILE
- MOVELOG
- PURGEALL
- PURGEDBE
- PURGEFILE
- PURGELOG
- QUIT
- RECOVERLOG
- RESCUELOG
- RESTORE
- RESTORELOG
- RESTORE PARTIAL
- SET
- SETDBEMAINT
- SETUPRECOVERY
- SETUPRECOVERY PARTIAL
- SHOWACCESS
- SHOWDBE
- SHOWDBE-ALL
- SHOWDBE-EXIT
- SHOWDBE-HELP
- SHOWDBE-LANG
- SHOWDBE-MAINT
- SHOWDBE-QUIT
- SHOWDBE-STARTPARMS
- SHOWLOG
- SHOWSET
- STORE
- STOREINFO
- STORELOG
- STOREONLINE
- STOREONLINE PARTIAL
- STORE PARTIAL
- SYSTEM
- WRAPDBE
- SQLGEN
- EDITOR
- EXIT
- GENERATE ALL
- GENERATE DBE
- GENERATE DBEFILES
- GENERATE DEFAULTSPACE
- GENERATE GROUPS
- GENERATE INDEXES
- GENERATE INSTALLAUTH
- GENERATE LOAD
- GENERATE MODAUTH
- GENERATE MODOPTINFO
- GENERATE PARTITION
- GENERATE PROCAUTH
- GENERATE PROCEDURES
- GENERATE PROCOPTINFO
- GENERATE RULES
- GENERATE SPACEAUTH
- GENERATE SPECAUTH
- GENERATE STATISTICS
- GENERATE TABAUTH
- GENERATE TABLES
- GENERATE TEMPSPACES
- GENERATE VIEWAUTH
- GENERATE VIEWS
- HELP
- RELEASE
- SET ECHO ALL OFF
- SET ECHO ALL ON
- SET EDITOR
- SET EXIT ON DBERR OFF
- SET EXIT ON DBERR ON
- SET SCHEMA
- STARTDBE
- :
- SQLMigrate
- ADD DBEFILE
- CREATE DBEFILE
- EXIT
- HELP
- MIGRATE
- PREVIEW
- QUIT
- REPAIR
- SET
- SHOW VERSIONS
- :
- SQLAudit
- AUDIT
- EDITOR
- EXIT
- GET AUDITPOINT
- HELP
- LOCK AUDITPOINT
- MODIFY AUDITPOINT
- QUIT
- SET
- SET DBENVIRONMENT
- SET ECHO ALL
- SET EDITOR
- SET EXIT ON DBERR
- SET RECOVERFILE
- SHOW AUDITPOINT
- UNLOCK AUDITPOINT
- Index