History configurations provide support for query history logging. PowerDesigner models history configurations as extended objects with a stereotype of <<HistoryConfiguration>>.
You can create an history configuration in any of the following ways:
Select 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 .
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 |