HP 3000 Manuals HP 3000 Manuals
Chapter 8 Maintaining the Database This chapter explains how to use DBChange Plus to do the following maintenance and performance tuning tasks on a TurboIMAGE/XL database: * Checking for structural integrity. * Fixing structural problems. * Improving database performance. * Managing database capacity. In this chapter, the section "Guidelines for Maintaining the Database" discusses when to use DBChange Plus to optimize the performance and integrity of the database. The remainder of this chapter combines the CHECK and FIX commands in several sections. For example, checking and fixing data sets are in the same section, and so on. However, your database maintenance tasks may be implemented differently than the method and order presented in this chapter, depending on your maintenance schedule and the size and activity of your database. For example, you may find it more efficient to create a job to be run on a regular basis to repack or check your database. Before reading this chapter, you should be familiar with the information in chapter 1, "Introduction to DBChange Plus." To learn how to do more DBChange Plus tasks, refer to chapters 2 through 7 and 9. If you understand DBChange Plus tasks and only want to see command syntax information, refer to chapter 10, "DBChange Plus Commands."