VLDB Properties at the Database Instance Level

The database instance level contains numerous VLDB properties. Those that are most commonly used are listed below:

• Maximum SQL/MDX Size
• SQL Date Format

For information on other database instance-level VLDB properties, refer to the System Administration Guide

Accessing Database Instance VLDB Properties

To set these properties, right-click a project within the database instance to be updated. Select Project Configuration. The Project Configuration Editor opens. Expand the Database instances folder. The Database instances - SQL Data warehouses pane displays. Click VLDB Properties. The VLDB Properties (Database Instance) dialog box opens.

The Maximum SQL/MDX Size property is contained in the Governing folder, while the SQL Date Format property is found in the Select/Insert folder.