Login:
Votes - 0, Average rating: 0 ( )

User manual HP, model MPE/iX 6.0 Operating System

Manafacture: HP
File size: 1.05 mb
File name:
Language of manual:itenesfrdept
Free link for this manual available at the bottom of the page



Other manuals for this model:

manual abstract


Document Outline

  • Contents
  • Basic Concepts in ALLBASE/SQL Performance
    • DBEFile Organization
      • Page Table Pages
      • Structure of a Page
      • Storage of Table Data on DBEFile Pages
      • Indirect Rows
      • Hash Storage
      • Storage of Index Data on DBEFile Pages
      • How Indexes are Used
      • How PCRs are Stored
      • Page Splitting
      • Data Buffering
    • System Catalog
    • Log File Organization
    • Log Buffering
      • No-Log Pages
    • Locking and Latching
      • Locks
      • Latches
      • Pins
      • Sequence of Events in Locking Data
    • Sorting
    • Optimization
      • How Optimization is Done
    • Sections and Validation
      • Section Caching
      • Validation
  • Guidelines on Logical and Physical Design
    • Logical Data Design
      • Normalization Issues
      • Including Calculated Data in Tables
      • B-Tree Index Design
      • Clustering Indexes
      • Choosing Appropriate Index Types
      • Authorization Design
      • Using a Duplicate Database
    • Physical Data Design
      • Creating DBEFileSets
      • Creating DBEFiles
      • Creating Tables
      • Initial Table Loads
      • Unloading Data
      • Unloading and Reloading to Remove Indirect Rows
      • Unloading and Reloading to Remove Overflow Pages
      • Tips on Deletions from Tables
  • Guidelines on Query Design
    • Avoiding Serial Scans Through Query Design
      • Data Conversions
      • Predicates with INTEGER = DECIMAL(n,0) Factors
    • Using Subqueries
      • When Not to Use DISTINCT in Subqueries
    • Using UNION
      • Defining Indexes for UNION Queries
    • Using MIN/MAX Functions in Predicates
    • Using OR Predicates
      • Choosing an Index for OR Factors
    • Using Predicates with LIKE
    • Using Predicates with BETWEEN
    • Using Fetch Unique Scans
    • Updating Key Columns
    • Avoiding User Propagation of Filters
    • Using TID Scans
    • Using Parallel Serial Scans
    • Using the BULK Option
    • Analyzing Queries with GENPLAN
    • Modifying the Access Optimization Plan with SETOPT
  • Guidelines on Transaction Design
    • General Tips on Managing Transactions
    • Controlling Locking
    • Using CS, RC, and RU Isolation Levels
    • Using Row Level Locking
      • Benefits of Row Level Locking
      • Shared Memory Considerations
      • Page Locking on PUBLICROW Tables
    • Using KEEP CURSOR
    • Removing Non-Database Processing from Transactions
    • Using Procedures and Rules
    • Tuning Performance of Dynamic Statements
  • Guidelines on System Administration
    • DBA Guidelines
      • Validating Your Applications Before Run Time
      • Developing Application Programs
      • Balancing System Load
      • Calculating Shared Memory Allocation
      • Choosing the Size of the Runtime Control Block
      • Sorting Operations
      • Using Multiconnect Functionality
      • Using Timeouts to Tune Performance
    • Network Guidelines
    • MPE/iX System Guidelines
      • Using Pseudomapped DBEFiles in MPE/iX
      • Using Memory-Resident Data Buffers
  • Getting Started With SQLMON
    • Starting SQLMON
    • Leaving SQLMON
    • Specifying the DBEnvironment
    • Invoking SQLMON Screens
    • Leaving an SQLMON Screen
    • Navigating SQLMON Subsystems
    • Setting SQLMON Variables
    • Accessing Online Help
    • Creating Batch Reports
    • Overhead Generated by SQLMON
    • Monitoring Tasks
  • Troubleshooting with SQLMON
    • Overview Subsystem
      • Transaction Limit Reached
      • Lock Contention
      • Memory Limit Reached
      • Log Full Condition
    • IO Subsystem
      • Insufficient Data Buffer Space
    • Lock Subsystem
      • Deadlocks
      • Lock Allocation Failures
      • Freezing DBEnvironment Sessions
      • Releasing DBEnvironment Sessions
    • SampleIO Subsystem
      • Using the SET SAMPLING Command
      • Using the SET DISPLAYSAMPLES Command
      • Understanding the Internals of Sampling
    • Static Subsystem
      • Poorly Clustered Indexes
      • Indirect Rows
      • Hash Overflow Pages
  • SQLMON Screen Reference
    • IO Screen
    • IO Data Program Screen
    • IO Data Session Screen
    • IO Log Program Screen
    • IO Log Session Screen
    • Load Screen
    • Load Program Screen
    • Load Session Screen
    • Lock Screen
    • Lock Impede Screen
    • Lock Memory Screen
    • Lock Object Screen
    • Lock Session Screen
    • Lock TabSummary Screen
    • Overview Screen
    • Overview Program Screen
    • Overview Session Screen
    • SampleIO Screen
    • SampleIO Indexes Screen
    • SampleIO Objects Screen
    • SampleIO TabIndex Screen
    • SampleIO Tables Screen
    • Static Screen
    • Static Cluster Screen
    • Static DBEFile Screen
    • Static Hash Screen
    • Static Indirect Screen
    • Static Size Screen
  • SQLMON Command Reference
    • EXIT
    • HELP
    • QUIT
    • SET
    • SET CYCLE
    • SET DBECONNECT
    • SET DBEFILESET
    • SET DBEINITPROG
    • SET DBENVIRONMENT
    • SET DISPLAYSAMPLES
    • SET ECHO
    • SET LOCKFILTER
    • SET LOCKOBJECT
    • SET LOCKTABFILTER
    • SET MENU
    • SET OUTPUT
    • SET REFRESH
    • SET SAMPLING
    • SET SORTIODATA
    • SET SORTIOLOG
    • SET SORTLOAD
    • SET SORTLOCK
    • SET SORTSAMPLEIO
    • SET USERTIMEOUT
  • Design for a High-Performance Interactive Table Editor
    • User Interface
    • Internal Algorithms
  • Index

...

Other models in this manual:
Software - MPE/iX 6.5 Operating System (1.05 mb)
Software - MPE/iX 7.0 Operating System (1.05 mb)
Software - MPE/iX 7.5 Operating System (1.05 mb)

Reviews



Your review
Your name:
Please, enter two numbers from picture:
capcha





Category