Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Data Archive Reference

EnableAudit tuning parameter

  • Last UpdatedSep 26, 2025
  • 2 minute read

You can enable auditing on individual database tables. Auditing is controlled through the EnableAudit tuning parameter. The value is a bitmask where each bit controls auditing to a specific database. A bit value of 1 enables auditing for the corresponding database.

Note: Changes to the EnableAudit tuning parameter do not take effect until you restart the affected subsystem.

The following table lists the Data Archive databases and the controlling bitmask value, in both hexadecimal and decimal format. See Examples of setting the bitmask value to enable auditing.

Database Table

Description

Subsystem

Value

Hexadecimal

Decimal

Point

Stores configuration information for each point as a list of point attributes

PI Base

0x1

1

Digital State

Contains the digital state sets. A state set has a name and a list of states (digital state strings). The system is limited to 16383 sets with up to 16383 states in each set.

0x2

2

Attribute Set (Point database schema)

Contains sets of attributes used to build point classes

0x4

4

Point Class (Point database schema)

Contains all the point classes defined on a Data Archive server. A point class defines the attributes of a PI point.

0x10

16

User

Defines users of AVEVA™ PI System™ and records their assignment to groups

0x20

32

Group

Defines groups to which users can be assigned

0x40

64

Trust

The PITRUST table allows a client application to connect to the Data Archive server as a specific user without requiring that the client application enter a user name and password

0x80

128

Modules

Contains information about PI Modules, which are fundamental objects used to add structure to Data Archive

0x100

256

Headings and HeadingSets

Contains information about PI Headings, which are objects that represent a hierarchical position or naming convention

0x200

512

Server

Contains Data Archive configuration and status information

0x4000

16384

Collective

Contains information about the Data Archive collective that the server belongs to, including the collective's name, description, and status.

0x8000

32768

Identity

Stores configuration data that defines PI identities

0x10000

65536

Identity Mapping

Stores the information that associates Windows users and groups to PI identities

0x20000

131072

Database Security

This is a general database security table; its structure applies to all databases. Database level security controls the access rights of users and groups to the various system databases; for example, create a point.

0x40000000

1073741824

Transfer Records

Contains information about PI TransferRecords, which are objects that represent a material transfer between a PI UnitBatch, PI Batch or PI Module

PI Archive

0x400

1024

Campaign

Contains information about PI Campaigns, which are objects that represent a logical group of PI Batch objects

0x800

2048

Batches

Contains PI Batch configuration and data from the Batch Database

0x1000

4096

Unit Batches

Contains PI Unit Batch information and configuration

0x2000

8192

Snapshot

Provides access to PI Snapshot Subsystem, both for listing or editing. The snapshot is the most recent event for a point.

PI Snapshot

0x10000000

268435456

Archive

Provides access to PI point data in the archives. The archives are records of values for each point in the PI point database. The archives store the time-stamped values in a set of files.

PI Snapshot and PI Archive

0x20000000

536870912

All Databases

0xFFFFFFFF

-1

TitleResults for “How to create a CRG?”Also Available in