Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home
ALLBASE/SQL Performance and Monitoring Guidelines: HP 3000 MPE/iX Computer Systems

Chapter 1 Basic Concepts in ALLBASE/SQL Performance

» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Index

Before presenting specific tips and tricks for tuning your DBEnvironments, this chapter presents some information about how data is passed about in ALLBASE/SQL among files, buffers, applications, and other elements in a typical large-scale production environment. The following topics are included:

  • DBEFile organization.

  • Data Buffering.

  • System Catalog.

  • Log File Organization.

  • Log Buffering.

  • Locking and Latching.

  • Sorting.

  • Optimization.

  • Sections and Validation.

Before reading on, you may wish to review the material found in the "Physical Design" chapter of the ALLBASE/SQL Database Administration Guide and the "Concurrency Control" chapter of the ALLBASE/SQL Reference Manual.

Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© Hewlett-Packard Development Company, L.P.