Omron NX701-1620 - Page 10

CONTENTS
8
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
4-2 Establishing/Closing a DB Connection .......................................................... 4-6
4-3 Checking the Status of DB Connection Service and each DB Connection ........................ 4-7
4-3-1 Operation Status of the DB Connection Service ............................. 4-7
4-3-2 Checking the Status of the DB Connection Service ........................ 4-8
4-3-3 Connection Status of each DB Connection ................................... 4-11
4-3-4 Checking the Status of each DB Connection ................................ 4-12
5 Other Functions ............................................................................................... 5-1
5-1 Examples of Using Functions ........................................................................ 5-2
5-2 Spool Function .............................................................................................. 5-4
5-2-1 Overview .......................................................................................... 5-4
5-2-2 Spooling System .............................................................................. 5-4
5-2-3 Applicable Instructions and Spooling Execution Conditions ............ 5-4
5-2-4 Memory Area Used by the Spool Function ...................................... 5-6
5-2-5 Spool Function Settings ................................................................... 5-8
5-2-6 How to Resend the SQL Statements Stored in the Spool Memory . 5-9
5-2-7 Clearing the SQL Statements from the Spool Memory ................. 5-10
5-2-8 Relationship with the DB Connection Instructions ......................... 5-12
5-2-9 How to Estimate the Number of SQL Statements that Can be Spooled
....................................................................................................... 5-14
5-3 DB Connection Service Shutdown Function ................................................ 5-15
5-3-1 Overview ........................................................................................ 5-15
5-3-2 Shutdown System .......................................................................... 5-16
5-3-3 How to Execute the Shutdown Function ........................................ 5-16
5-3-4 How to Check the Shutdown of the DB Connection Service ......... 5-17
5-4 How to Prevent Losing SQL Statements at Power Interruption ................... 5-18
5-4-1 Overview ........................................................................................ 5-18
5-4-2 Procedures ..................................................................................... 5-18
5-5 Timeout Monitoring Functions ..................................................................... 5-22
5-5-1 Timeout Monitoring Functions ....................................................... 5-22
5-5-2 Login Timeout ................................................................................ 5-23
5-5-3 Query Execution Timeout .............................................................. 5-23
5-5-4 Communications Timeout .............................................................. 5-24
5-5-5 Instruction Execution Timeout ....................................................... 5-24
5-5-6 Keep Alive Monitoring Time ........................................................... 5-24
5-6 Other Functions ........................................................................................... 5-26
5-6-1 Backup/Restore Function in the DB Connection Service .............. 5-26
5-6-2 Operation Authority Verification in the DB Connection Service ..... 5-28
6 How to Use Operation Logs ............................................................................ 6-1
6-1 Operation Logs .............................................................................................. 6-3
6-2 Execution Log ................................................................................................ 6-4
6-2-1 Overview .......................................................................................... 6-4
6-2-2 Application Procedure ...................................................................... 6-4
6-2-3 Setting the Execution Log ................................................................ 6-5
6-2-4 Checking the Execution Log ............................................................ 6-5