CREATE DATABASE
Use the CREATE DATABASE command with the added COLLECT HISTORY clause.
Synopsis
Syntax for creating a DATABASE:
CREATE DATABASE <database-name> [<create-db-clause>]...
<create-db-clause> ::=
... existing clauses ...
| COLLECT HISTORY { ON | OFF | DEFAULT }
Inputs
The CREATE DATABASE command has the
following inputs:
Input | Description |
---|---|
COLLECT HISTORY [ ON | OFF | DEFAULT ] | Specifies whether history data is to be collected for sessions
attached to this database.
|
Outputs
The CREATE DATABASE command has
the following output:
Output | Description |
---|---|
ERROR: permission denied. | You must have Manage Security privilege to set a database history collection attribute. |
Description
For details about all the options
of the CREATE DATABASE command, see theIBM® Netezza® Database User’s Guide.
The CREATE DATABASE command has the following characteristics:
- Privileges required
- None.
- Common tasks
- In addition to its previous functions, the command assigns the collect history to the database object.
Usage
The following provides sample usage:
CREATE DATABASE SECRET COLLECT HISTORY ON;