Administration: Database Documentation Changes

Read about updates to Administration: Database.

These changes affect Manage Data Storage.

Manage Data Storage
Topic Section Correction
Types of Dbspaces Table

In the row for Other main dbspaces (also called user dbspaces), the column Number of Dbspaces should read:

One or more. You must be licensed for the IQ_VLDBMGMT option to create more than one user dbspace.

Other User Main Dbspaces n/a

The following was omitted:

Note: You must be licensed for the IQ_VLDBMGMT option to create more than one user dbspace.

These changes affect Appendix: SQL Statements and Options Reference.

SQL Statements
Topic Section Correction
ALTER TABLE Statement Parameters: ALTER OWNER clause The truncated final bullet should read:
  • Enabled materialized views that depend on the original table exist.
CREATE DATABASE Statement Syntax: ENCRYPTED clause The ENCRYPTED clause incorrectly includes a reference to [ TABLE ]. The correct syntax for the clause is:
 … [ ENCRYPTED {algorithm-key-spec 
   | OFF } ]