| DBILOGENTRY |
Nick West
This table records significant changes in other database tables. It does not record updates produced automatically by systems such as the DBU and the DCS.
The table is informational only; it is not directly use by any software.
Entries can be created as other tables are updated using DbiWriter or manually using the dbmjob executable. In the case of DbiWriter all the information, appart from LOG_REASON is collected from the table being updated, so should be valid. When using dbmjob, the system checks to see if the update referred to exits but, having asked for confirmation, will allow a user to create a DBILOGENTRY for a non-existent update. In either case there is no attempt to "validate" LOG_REASON.
Table not updated automatically or info not available.
To examine DBILOGENTRYs use Database Updates Search
| Field | Type | Description |
|---|---|---|
| SEQNO | int(11) | |
| ROW_COUNTER | int(11) | |
| TABLENAME | text | The name of the table updated |
| SEQNOMIN | int(11) | The lowest SEQNO updated |
| SEQNOMAX | int(11) | The highest SEQNO updated |
| NUMSEQNO | int(11) | The number of SEQNOs updated |
| USERNAME | text | The user who ran the job (either DbiWriter or dbmjob) |
| PROCESSNAME | text | The name of the job |
| HOSTNAME | text | The name of the host on which the job ran |
| SERVERNAME | text | The database server the job was connected to. |
| LOG_REASON | text | The reason for the update |
| Detector | Responsible | Frequency | Method | |
|---|---|---|---|---|
| caldet | data | N/A | N/A | N/A |
| MC | N/A | N/A | N/A | |
| neardet | data | the table updater or Nick West | As required | either manually (dbmjob) or via DBI (DbiWriter) |
| MC | the table updater or Nick West | As required | either manually (dbmjob) or via DBI (DbiWriter) | |
| fardet | data | the table updater or Nick West | As required | either manually (dbmjob) or via DBI (DbiWriter) |
| MC | the table updater or Nick West | As required | either manually (dbmjob) or via DBI (DbiWriter) | |