|
|
|
|
|
- Overview
- Data file JNL_FILES.FIC
- Data file JNL_OPERATION.FIC
- Data file JNL_USERS.FIC
- Data file *JNL.FIC (log file)
Structure of log files (HFSQL Client/Server)
Available only with this kind of connection
The following files are automatically created when logging an HFSQL Client/Server data file: | | JNL_FILES.FIC | Description of log data files. | JNL_OPERATION.FIC | Description of actions performed on a log data file. | JNL_USERS.FIC | Description of users performing an action on a log data file. | xxxJNL.FIC | File created for each log data file. Contains the value of records used before and after each operation. |
These files are created according to the following structure: | |  | 1. __JNL directory This directory contains:- The data file log file.
- The user log.
- The operation log.
- For each log data file in each database, the corresponding log file. The tree structure used corresponds to the tree structure of the data files associated with the database.
For exampleif DataApplicationA's Command data file is logged, the subdirectory __JNL\DataApplicationA will contain the data file CommandJNL.FIC.Another example If the Customer data file of DataApplicationB is jounalized, the subdirectory __JNL\DataApplicationA\Customer will contain the data file CustomerJNL.FIC. 2. Database directory DataApplicationA 3. Database directory DataApplicationB |
This page presents the structure of these files. The various fields in the JNL_FILES.FIC data file are as follows: | | JNLFile_ID | Data file identifier. | Source_DB_File_Location | Name of database + '\' + relative path of log file. | Source_File_GUID | GUID of log data file. | JNL_File_GUID | GUID of write-to-file log. |
Data file JNL_OPERATION.FIC The various fields in the JNL_OPERATION.FIC data file are as follows: | | Operation_ID | Identifier of the operation. | USER_ID | Identifier of user who performs the operation. This identifier corresponds to the identifier of the data file JNL_USER.Fic | JNLFile_ID | Identifier of logged file where the operation is performed. This identifier corresponds to the identifier of the data file JNL_FILES.Fic. | WLFunction_ID | Identifier of the WLanguage function used in the program. To find out the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of the product) | Server_Time | Date of operation on the server (in UTC format, universal time) | Record_Number | Number of the modified record | Source_Record_Backup_ID | Identifier in the file of values. Corresponds to the record value before the operation. | Modified_Record_Backup_ID | Identifier in the file of values. Corresponds to the record value after the operation. | HLogInfoMsg | Value defined by HLogInfo. | HComputer_ID | Text defined by HComputer. |
The various fields in the JNL_USERS.FIC data file are as follows: | | USER_ID | User identifier. | Login | Username. | Workstation_Name | Name of user computer. | Workstation_IPAddress | IP address of user computer. | Application | Application name |
Data file *JNL.FIC (log file) The data file *JNL.Fic contains: - the items found in the table below,
- all log fields in the corresponding HFSQL log data file.
| | USER_ID | Identifier of the user who performed the operation. This number identifies the record in the JNL_Users.Fic data file | Record_Number | Record number in original log file. | Record_Status | Record status (modified, deleted, added, ...) | WLFunction_ID | Identifier of the WLanguage function used in the program. To find out the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of the product used) | Server_Time | Date of operation on the server (in UTC format, universal time) | HLogInfoMsg | Value defined by HLogInfo. | HComputer_ID | Text defined by HComputer. | IDJNL | Identifier of the log |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|