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