Votes - 0, Average rating: 0
(
)
|
Other manuals for this model:
Software - MPE/iX 6.0 Operating System (52.62 kb)
Software - MPE/iX 6.0 Operating System (25.16 kb)
Software - MPE/iX 6.0 Operating System (38.33 kb)
Software - MPE/iX 6.0 Operating System (1.13 mb)
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
- DBEFile Organization
- 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
- Logical Data Design
- 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
- Avoiding Serial Scans Through Query Design
- 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
- DBA Guidelines
- 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
- Overview Subsystem
- 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