Log:
Assessments - 0, GPA: 0 ( )

Instruções de Operação HP, Modelo MPE/iX 6.0 Operating System

Fabricante : HP
Arquivo Tamanho: 1.66 mb
Arquivo Nome :
Língua de Ensino: svitenesfrdedaronn
Ir para baixar



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
  • 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
  • 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
  • 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

...

Este manual também é adequado para os modelos :
Software - MPE/iX 6.5 Operating System (1.66 mb)
Software - MPE/iX 7.0 Operating System (1.66 mb)
Software - MPE/iX 7.5 Operating System (1.66 mb)

Escreva a sua própria avaliação do dispositivo



Mensagem
Seu nome :
Introduza os dois dígitos :
capcha





categorias