Progress Database Administration Guide

Written by Dan Foreman, Current Edition: July 2015

progress database administration guide feb2015

A comprehensive guide to administering Progress databases. Progress V9-V11 are covered. Much of the information found in this publication cannot be found in the standard Progress documentation.

Topics include:

  • Storage Areas & Multi-Volume Databases
  • Monitoring/Controlling Database Growth
  • Dump and Reload Techniques
  • Index Rebuilding
  • Backups
  • Startup Options
  • After Imaging
  • Error Messages and Log Files
  • Troubleshooting
  • Database Repair
  • Database Security
  • Client/Server Configuration
  • Progress Internals
  • Database Repair Utility
  • Record Locking
  • Database Broker Startup and Shutdown
  • Progress Utilities
  • 24 X 7 Operation

Pages: 457

Buy Book

If you are interested in purchasing a publication, please contact the author.
Dan Foreman can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it.

Progress DBA Best Practices

Written by Dan Foreman, Current Edition: July 2015

progress dba best practices july2015

A list of widely accepted Best Practices for managing Progress databases.

You do not need this publication if you already have the Progress Database Administration Guide.

Pages: 15

Buy Book

If you are interested in purchasing a publication, please contact the author.
Dan Foreman can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it..

This email address is being protected from spambots. You need JavaScript enabled to view it.

Progress Performance Tuning Guide

Written by Dan Foreman, Current Edition: July 2015

progress performance tuning guide july2015

The Progress Performance Tuning Guide is a publication that covers all aspects of Progress performance for both Database Administrators and Programmers. The 470+ page volume has sold over 2,500 copies worldwide.

Topics Covered:

  • Database Design & Indexing
  • Efficient Coding Techniques
  • Covers versions 9, 10 and 11 (V6-V8 is available by special order)
  • Real Life Benchmarks
  • 4GL/ABL Performance
  • Client/Server
  • Performance Monitoring
  • System Administration & Disk Utilization
  • Quick Tune-Up Checklist
  • Database Startup Options
  • 4GL/ABL Client Startup Options
  • Debugging Application Performance
  • SQL

Pages: 469

Buy Book

If you are interested in purchasing a publication, please contact the author.
Dan Foreman can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it..

Progress System Tables Guide

Written by Dan Foreman, Current Edition: July 2015

progress system tables guide july2015

Virtual System Tables (VST's) were added in V8.2. VST's provide access to data that was previously only accessible through the promon utility. The Progress documentation gives a basic description of each Virtual System Table (VST) but is generally inadequate for anyone attempting to do so serious work with VST's. This publication also has information about the Metaschema, SQL Shadow Tables, and more.

Topics Covered:

  • VST Implementation
  • Performance Overhead of VST's
  • VST Bugs
  • VST Comparison: V8, V9, V10, and V11
  • Writing programs that use VST's
  • Undocumented VST fields
  • VST Indexes
  • VST Record Counts
  • VST's that can be updated
  • Stale VST Data
  • Metaschema Table definitions
  • SQL Tables and Shadow Tables

Pages: 226

Buy Book

If you are interested in purchasing a publication, please contact the author.
Dan Foreman can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it..

V9 DBA Jumpstart Guide

Written by Dan Foreman, Current Edition: November 2004

V9 represents some of the biggest changes to the Progress database in the history of Progress. With new features and improved flexibility comes an increased level of complexity. This publication is designed for experienced V6, V7 and V8 Progress Database Administrators who want to fully understand the impact of migrating to V9.

Topics Covered:

  • What's new in the V9 Database
  • Strategies for Migrating to V9
  • What to watch out for in V9
  • Storage Areas
  • Performance Enhancements
  • Changes to VST's and the Metaschema
  • Utilities: new and improved
  • New V9 Limits    

If you are interested in purchasing a publication, please contact the author.
Dan Foreman can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it..

V10 DBA Jumpstart Guide

Written by Dan Foreman, Current Edition: July 2008

OpenEdge 10 brings some interesting changes to the Progress database. With new features and improved flexibility comes an increased level of complexity. This publication is designed for experienced V6, V7, V8 and V9 Progress Database Administrators who want to fully understand the impact of migrating to OpenEdge 10.

Topics Covered:

  • What's new in the OE10 Database
  • Data Dictionary Changes
  • What to watch out for in OE10
  • Type 2 Storage Areas
  • Performance Enhancements
  • Changes to VST's and the Metaschema
  • New Online Utilities
  • New OE10 Limits
  • New Dump/Load Options

If you are interested in purchasing a publication, please contact the author.
Dan Foreman can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it..