Omron NX701-1620 User Manual

4 Basic Operations and Status Check
4-13
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
4
4-3 Checking the Status of DB Connection
Service and each DB Connection
Category
Item
Description
Values
Number of error
executions
Number of times when an SQL statement execution
failed.
This is the number of times when an SQL statement is
not spooled, but discarded. The number of times when a
statement is spooled is not included.
This value is cleared when the DB Connection Service is
started.
Number of error
executions
Response time Time elapsed since the CPU Unit sent the SQL statement
until the CPU Unit received its SQL execution result in the
latest execution of SQL statement
*2
.
The response time is stored only when normal response
is returned from the DB.
If a DB Connection Instruction Execution Timeout has
occurred, the response time is not stored when the
execution of the instruction is completed (i.e. when the
Error output variable changes from FALSE to TRUE).
The response time is stored when a normal response is
returned from the DB after the DB Connection Instruction
Execution Timeout occurred.
This value is cleared when the DB Connection Service is
started.
Duration
(Unit: d:h:m:s.ms)
Spooling Number of spool data Number of SQL statements stored in the Spool memory. Number of spool data
Spool usage Use rate of the Spool memory for each DB Connection. Spool usage in percentage
(%)
Connection
Error
SQL status Error code defined in SQL Standards (ISO/IEC 9075) to
be shown when a network failure or an SQL Execution
Error occurred.
*3
The value of the latest error in the connection is stored.
This value is cleared when the DB Connection Service is
started.
---
Error code Error code that is specific to DB vendor to be shown
when a network failure or an SQL Execution Error
occurred.
*3
When a network error has occurred, 0 is displayed for
error code in some cases. When 0 is displayed, check its
SQL status.
The code of the latest error in the connection is stored.
This value is cleared when the DB Connection Service is
started.
---
Error message Error message that is specific to DB vendor to be shown
when a network failure or an SQL Execution Error
occurred.
*3
The message of the latest error in the connection is
stored.
This value is cleared when the DB Connection Service is
started.
---
*1 The date and time information follows the time zone set when the power supply to the Controller is
turned ON. After you change the time zone, cycle the power supply.
*2 Execution of SQL statement refers to the execution of DB_Insert (Insert DB Record), DB_Update
(Update DB Record), DB_Select (Retrieve DB Record), or DB_Delete (Delete DB Record)
instruction, or resending of Spool data (automatically or manually by executing a DB_ControlSpool
instruction).
*3 The value may differ by unit version of the CPU Unit.
The value of connection error to SQL Server was changed in the unit version 1.08 of the CPU Units.
4-3-4 Checking the Status of each DB Connection

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English