Preface

This book presents a series of guidelines for use in monitoring and tuning the performance of your ALLBASE/SQL G.0 system. These guidelines are applicable for the MPE/iX 5.0 release.

The chapters in this book are listed below:

Chapter 1, "Basic Concepts in ALLBASE/SQL Performance" describes some very basic concepts to help you understand how to tune performance.
Chapter 2, "Guidelines on Logical and Physical Design" describes how your database design and file storage affect performance.
Chapter 3, "Guidelines on Query Design" shows how to write queries for best performance.
Chapter 4, "Guidelines on Transaction Design" describes techniques for obtaining the greatest concurrency.
Chapter 5, "Guidelines on System Administration" describes how to improve performance in the areas of database, network, and operating system administration.
Chapter 6, "Getting Started With SQLMON" describes the basic operations of SQLMON, the performance monitoring tool.
Chapter 7, "Troubleshooting with SQLMON" provides examples on how to use SQLMON to troubleshoot ALLBASE/SQL performance situations.
Chapter 8, "SQLMON Screen Reference" documents all of the SQLMON screens in alphabetical order.
Chapter 9, "SQLMON Command Reference" describes each of the SQLMON commands, with syntax and examples.
Appendix A, "Design for a High-Performance Interactive Table Editor," sketches an approach to table editing that avoids concurrency problems and promotes high performance through the use of BULK operations.

You can find additional basic information relating to database performance in the following chapters in the ALLBASE/SQL document set:

"Logical Design" and "Physical Design" in the ALLBASE/SQL Database Administration Guide.
"Concurrency Control" in the ALLBASE/SQL Reference Manual.
"Transaction Management with Multiple DBEnvironment Connections" in the ALLBASE/SQL Advanced Application Programming Guide.
"Processing with Cursors" in the ALLBASE/SQL application programming guide for your programming language.

Preface

Technical documentation

» Table of Contents

» Index