Show TOC

History Configurations (Netezza)Locate this document in the navigation structure

History configurations provide support for query history logging. PowerDesigner models history configurations as extended objects with a stereotype of <<HistoryConfiguration>>.

Creating an History Configuration

You can create an history configuration in any of the following ways:

  • Select Start of the navigation path Model Next navigation step History Configurations End of the navigation path to access the List of history configurations, and click the Add a Row tool.

  • Right-click the model or package in the Browser, and select Start of the navigation path New Next navigation step History Configuration End of the navigation path.

History Configuration Properties

You can modify an object's properties from its property sheet. To open an history configuration property sheet, double-click its Browser entry in the History Configurations folder.

The following extended attributes are available on the Options tab:

Name

Description

History type

Specifies the type of the database to create, which can be QUERY or NONE. Specify NONE to disable history collection. This is a required option which does not have a default value.

Scripting name: Histtype

Data to collect

Specifies the history data to collect. Specify multiple values using comma-separated values, or click the Select tool to the right of the field to select them.

Scripting name: Collect

Database / User / Password

Specifies the history database to which the captured data will be written, along with the user and password to use for accessing and inserting data.

Scripting name: Database, User, Password

Load interval

Specifies the number of minutes to wait before checking the staged area for history data to transfer to the loading area.

Scripting name: Loadinterval

Load retry

Specifies the number of times that the load operation will be retried. The valid values are 0 (no retry), 1 or 2.

Scripting name: Loadretry

Minimum / Maximum threshold

Specify the minimum and maximum amounts of history data in MB to collect before transferring the staged batch files to the loading area. Values of 0 disable these threshold checks.

Scripting name: Loadminthreshold, Loadmaxthreshold

Disk full threshold

This option is reserved for future use. Any value you specify will be ignored. The default value is 0.

Scripting name: Diskfullthreshold

Storage limit

Specifies the maximum size of the history data staging area in MB.

Scripting name: Storagelimit

Enable history

Specifies to log information about queries to the query history database.

Scripting name: Enablehist

Enable system

Specifies to log information about system queries. A system queries accesses at least one system table but no user tables.

Scripting name: Enablesystem

Version

Specifies the query history schema version of the configuration. The version must match the version number specified in the nzhistcreatedb command; otherwise, the loader process will fail.

Scripting name: Version

Definition

Specifies the attribute that stores the object definition.

Scripting name: ObjectDefn