Data Files

The Database branch of the Server Status Tool includes a Data Files category. This category shows information about the data files that belong to database items in Geo SCADA Expert.

The information about each data file is displayed under these categories:

• Object Id—The identifier of the database item with which the data file is associated.
• Table—The table in the database that contains the data file.
• Data File—The name of the data file.

NOTE: The values in the Object Id, Table, and Data File columns combine with the file path to define the name of the file on disk. The name of the file on the disk appears in the following format:

<path>\DataFile<objectid>\<table><datafile>.<extension>

The <objectid> is padded to a minimum of six digits.

 

C:\ProgramData\Schneider Electric\ClearSCADA\Database\DataFiles\DataFile000123\CCrystalReportDefinition.rpt

For more information, see Locations of the Database Folders.

• Flags—This is a bitmask. This column displays a hexadecimal value. When set, each bit indicates the following:
  • Bit 0— When this bit is set it indicates that the file is loaded (see Data File Cache). When this bit is clear, it indicates that the file is not loaded.
  • Bit 1—When this bit is set it indicates that the file has changed (and so requires flushing to disk). When this bit is clear, it indicates that the file has not changed.
  • Bit 2—When this bit is set it indicates that the file is being kept (this temporarily blocks the file from being deleted). When this bit is clear, it indicates that the file is not being retained.
  • Bit 8—When this bit it set it indicates that the file has changed and the changes have to be synchronized to Standby 1. When this bit is clear, it indicates there are no changes to be synchronized.
  • Bit 9—When this bit it set it indicates that the file has changed and the changes have to be synchronized to Standby 2. When this bit is clear, it indicates there are no changes to be synchronized.
  • Bit 10—When this bit it set it indicates that the file has changed and the changes have to be synchronized to Standby 3. When this bit is clear, it indicates there are no changes to be synchronized.
  • Bit 11—When this bit it set it indicates that the file has changed and the changes have to be synchronized to Standby 4. When this bit is clear, it indicates there are no changes to be synchronized.
  • Bit 12—When this bit it set it indicates that the file has changed and the changes have to be synchronized to Standby 5. When this bit is clear, it indicates there are no changes to be synchronized.
  • Bit 16—When this bit is set it indicates that the file has changed (this includes deletion) and the entire file has to be synchronized to Standby 1. When this bit is clear, it indicates that the entire file does not have to be synchronized.
  • Bit 17—When this bit is set it indicates that the file has changed and the entire file has to be synchronized to Standby 2. When this bit is clear, it indicates that the entire file does not have to be synchronized.
  • Bit 18—When this bit is set it indicates that the file has changed and the entire file has to be synchronized to Standby 3. When this bit is clear, it indicates that the entire file does not have to be synchronized.
  • Bit 19—When this bit is set it indicates that the file has changed and the entire file has to be synchronized to Standby 4. When this bit is clear, it indicates that the entire file does not have to be synchronized.
  • Bit 20—When this bit is set it indicates that the file has changed and the entire file has to be synchronized to Standby 5. When this bit is clear, it indicates that the entire file does not have to be synchronized.
  • Bits 3-7, 13-15, 21-31 are reserved for future use.
• Access Time—The time when the data file was last accessed. If the data file has never been accessed since the server started, the string value 'Never' is displayed.
• Loaded File Size—The size of the loaded data file.

NOTE: A combination of the Access Time, Loaded File Size and bit 0 of the Flags bitmask control which files are loaded into the data file cache (see Data File Cache).

• CRC—This indicates the Cyclic Redundancy Check (CRC) of the file's content, as a hexadecimal value. This column displays '-' if the CRC is not valid.

  This CRC is used by main-standby synchronization to detect differences between the data files on each server to determine which data files have to be synchronized.

• Disk File Lock—This indicates whether or not a data file is locked and if locked, the type of lock that is applied. The Disk File Lock column displays the following:
  • '-' if the file is not locked.
  • 'Writer' if a Write lock is applied to the file.
  • '<Number of Readers> Readers' to indicate the number of Read locks that are applied to the data file.