6 How to Use Operation Logs
6-8
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Operation Log recording timing
DB Connection
Service
0001 DB Connection
Service Started
When the start processing of the DB
Connection Service is completed
0002 DB Connection
Service Stopped
When the stop processing of the DB
Connection Service is completed
0003 DB Connection
Service Shutdown
When the shutdown processing of the DB
Connection Service is completed
DB Connection 0001 DB Connection
Established
When the establishment processing of a DB
Connection is completed (succeeded/failed)
after the establishment is commanded from
Sysmac Studio or the applicable instruction.
0002 DB Connection
Closed
When the close processing of a DB Connection
is completed (succeeded/failed) after the close
is commanded from Sysmac Studio or the
When disconnection from the DB is detected.
0004 DB Connection
When the DB Connection status changes from
Disconnected to Connected.
SQL 0001 INSERT When a response (succeeded/failed) is
returned to INSERT that is issued from DB
Connection Service to DB after execution of a
DB_Insert (Insert DB Record) instruction.
0002 UPDATE When a response (succeeded/failed) is
returned to UPDATE that is issued from DB
Connection Service to DB after execution of a
DB_Update (Update DB Record) instruction.
0003 SELECT When a response (succeeded/failed) is
returned to SELECT that is issued from DB
Connection Service to DB after execution of a
DB_Select (Retrieve DB Record) instruction.
0004 DELETE When a response (succeeded/failed) is
returned to DELETE that is issued from DB
Connection Service to DB after execution of a
DB_Delete (Delete DB Record) instruction.
SQL Resend 0001 INSERT When a response (succeeded/failed) is
returned to INSERT after resending the
INSERT statement stored in the Spool memory.
0002 UPDATE When a response (succeeded/failed) is
returned to UPDATE after resending the
UPDATE statement stored in the Spool
User-specified Log 0000 to
9999
(specified by
DB_PutLog
Instruction Executed
When a DB_PutLog (Record Operation Log)
instruction is executed