Omron NX701-1620

6 How to Use Operation Logs
6-9
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
6
6-2-5 Execution Log File Specifications
6-2 Execution Log
*4 Log Name
Category
Operation
Log name
DB Connection
Service
DB Connection Service Started
Start
DB Connection Service Stopped
Stop
DB Connection Service Shutdown
Shutdown
DB Connection
DB Connection Established
Connect
DB Connection Closed
Close
DB Connection Disconnected
Disconnect
DB Connection Reestablished
Reconnect
SQL
INSERT
INSERT
UPDATE
UPDATE
SELECT
SELECT
DELETE
DELETE
SQL Resend
INSERT
INSERT
UPDATE
UPDATE
User-specified
Log
DB_PutLog Instruction Executed Text string specified in the
LogName input variable of the
DB_PutLog instruction.
Record examples:
 DB Connection Service Started:
1 2012-07-24 21:29:45 267 DB_SERVICE 0001 Start 0x0000
 INSERT (Failed):
1 2012-07-24 21:29:45 267 SQL 0001 INSERT 0x1234 DBConnection1 45 TableX VarY 100 17026
 User-specified Log:
1 2012-07-24 21:29:45 267 USER 9876 LineA1 0x0000 ”ProductionStarted”
 Log file example:
0 2012-07-24 08:29:45 267 DB_SERVICE 0001 Start 0x0000
1 2012-07-24 08:31:52 002 DB_CONNECTION 0001 Connect 0x0000 MyDatabase1
2 2012-07-24 08:31:53 959 DB_CONNECTION 0001 Connect 0x0000 MyDatabase2
3 2012-07-24 09:00:00 052 USER 0001 LineA1 0x0000 “ProductionStarted"
4 2012-07-24 09:00:00 150 SQL 0001 INSERT 0x0000 MyDatabase1 0 TABLE_Production Production 100 0
5 2012-07-24 09:10:00 150 SQL 0001 INSERT 0x0000 MyDatabase1 1 TABLE_Production Production 100 0
6 2012-07-24 09:20:00 151 SQL 0001 INSERT 0x0000 MyDatabase1 2 TABLE_Production Production 100 0
7 2012-07-24 09:30:00 150 SQL 0001 INSERT 0x0000 MyDatabase1 3 TABLE_Production Production 100 0
8 2012-07-24 09:55:23 422 USER 0002 LIneA1 0x0000 “ProductionFinished"
9 2012-07-24 10:15:00 549 SQL 0003 SELECT 0x0000 MyDatabase2 4 TABLE_MPS ProductionSchedule 200 0
Precautions for Correct Use
Do not delete the latest log file (DB_ExecutionLog.log) and the log control file
(DB_ExecutionLog.fjc) from the SD Memory Card. If they are deleted, the log files are not
saved correctly, for example, the Execution Log data are lost.