In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |   qad.com




Database Management
The system provides utilities for monitoring database size, performing dumps and loads, reloading archive files, managing database sequences, registering applications, and monitoring license compliance.
Managing Database Size
Explains how to manage database size by determining disk usage and freeing disk space.
Dumping and Loading Data
Outlines the dump/load procedures.
Deleting and Archiving Data
Lists transactions that can be deleted/archived and explains how to use Audit Detail Delete/Archive (36.23.1) and restore archive files.
Managing Database Sequences
Discusses how database sequences are used and outlines how to initialize sequences, maintain sequences manually, maintain sequences using CIM, maintain audit trails, and maintain sequences in Oracle.
Registering Licenses
Gives an overview of licensing, lists violation types and error messages, explains how to use License Registration (36.16.10.1), and how license reporting works.
Setting Up Multiple Time Zones
Discusses how to use Multiple Time Zones Maintenance (36.16.22.1) and MTZ Load Utility (36.16.22.13).
Defining Database Control Settings
Explains how to use Database Control (36.24).
Managing Database Size
Several utilities help you manage the size of your database.
Determining Disk Usage
Use Database Table Size Inquiry (36.16.1) to dump selected tables and review their sizes. Reported table sizes may be understated since indexing overhead is not taken into account.
Note: The program requires adequate free disk space to run.
Use Disk Space Inquiry (36.22.13) to display free space for each available disk, in blocks. For most UNIX environments, a block is typically 1024 bytes. For Windows environments, blocks range from 1024 to 8192 bytes. Consult your hardware manuals for exact specifications.
Note: These programs must be run from a character user interface.

Disk Space Inquiry (36.22.13)
Freeing Disk Space
There are three ways to reduce the size of a Progress database:
Use dump/load programs to compact your data. Compacting data can increase disk access speeds significantly. To do this, dump all data from your database, and reload it into an empty database. You need free disk space amounting to about 70% of the total size of your data (.d) files. Progress recommends that you dump/load once a year.
Use delete/archive programs to create free database space. Typically, the largest tables in a database contain history, sales order, and purchase order data. The amount of disk space may decrease if you store the archived data on the same disk. See Deleting and Archiving Data.
Use both dump/load and archive/delete programs. To do this, remove records from the database, dump the remaining data, and reload it into an empty database. You need plenty of free disk space to do this.