- Advanced SQL Engine:
- To implement a feature, such as security access logging, client character sets, and calendar arithmetic.
- To store system information, such as PDE crashdumps, resource usage, query text, and error message text.
- To view the contents of the Data Dictionary (system catalog) tables.
- To generate system reports, such as resource usage statistics
DIP allows you to execute one, several, or all script files, which create a variety of database objects. The most commonly needed DIP scripts are executed during Advanced SQL Engine installation, but you can run the DIP utility at any time to add optional features.