!IIapi_initAPI: initializing API.
!IIapi_initialize: INGRES API initialized, envHndl = 090F9308
!IIapi_initialize: startup API
!IIapi_initialize: version = 6
!IIapi_initialize: INGRES API initialized, envHndl = 09078018
!IIapi_connect: connect to DBMS Server
!IIapi_connect: envHndl = 09078018, connHndl = 00000000, tranHndl= 00000000
!IIapi_connect: target = @server,tcp_ip,ii[user:secret]::dbname
!IIapi_thread(-1226205472): allocated local storage 091A5E78
!IIapi_uiDispatch: dispatching event IIAPI_EV_CONNECT_FUNC
!Dispatch(-1226205472): SQL Conn [091A5960] IDLE --> REQ, 2 action(s)
!Dispatch(-1226205472): action[1] REMC
!Dispatch(-1226205472): action[2] CONN
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> REQ, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_liDispatch: queueing event IIAPI_EV_CONNECT_CMPL
!IIapi_liDispatch: dispatching event IIAPI_EV_CONNECT_CMPL
!Dispatch(-1226205472): SQL Conn [091A5960] REQ --> WCR, 1 action(s)
!Dispatch(-1226205472): action[1] RECV
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_ACCEPT_RCVD
!IIapi_liDispatch: dispatching event IIAPI_EV_ACCEPT_RCVD
!Dispatch(-1226205472): SQL Conn [091A5960] WCR --> MOD, 1 action(s)
!Dispatch(-1226205472): action[1] SMDA
!IIapi_liDispatch: queueing event IIAPI_EV_SEND_CMPL
!IIapi_liDispatch: dispatching event IIAPI_EV_SEND_CMPL
!Dispatch(-1226205472): SQL Conn [091A5960] MOD --> WMR, 2 action(s)
!Dispatch(-1226205472): action[1] CPRM
!Dispatch(-1226205472): action[2] RECV
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_ACCEPT_RCVD
!IIapi_liDispatch: dispatching event IIAPI_EV_ACCEPT_RCVD
!Dispatch(-1226205472): SQL Conn [091A5960] WMR --> CONN, 1 action(s)
!Dispatch(-1226205472): action[1] CBOK
!IIapi_appCallback: request completed, status = SUCCESS
!IIapi_setEnvParam: set environment parameter
!IIapi_setEnvParam: envHndl = 09078018
!IIapi_setEnvParam: paramID = 24.
!IIapi_autocommit: set autocommit state
!IIapi_autocommit: connHndl = 091A5960, tranHndl = 00000000
!IIapi_uiDispatch: dispatching event IIAPI_EV_AUTO_FUNC
!Dispatch(-1226205472): SQL Tran [091A69B8] IDLE --> AON, 2 action(s)
!Dispatch(-1226205472): action[1] REMC
!Dispatch(-1226205472): action[2] SAON
!IIapi_liDispatch: queueing event IIAPI_EV_SEND_CMPL
!IIapi_liDispatch: dispatching event IIAPI_EV_SEND_CMPL
!Dispatch(-1226205472): SQL Tran [091A69B8] AON --> WONR, 1 action(s)
!Dispatch(-1226205472): action[1] RECV
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESPONSE_RCVD
!IIapi_liDispatch: dispatching event IIAPI_EV_RESPONSE_RCVD
!Dispatch(-1226205472): SQL Tran [091A69B8] WONR --> AUTO, 2 action(s)
!Dispatch(-1226205472): action[1] RRSP
!Dispatch(-1226205472): action[2] CBOK
!IIapi_appCallback: request completed, status = SUCCESS
!IIapi_query: starting a query
!IIapi_query: connHndl = 091A5960, tranHndl = 091A69B8, queryType = 0
!IIapi_query: queryText = set session with description='hello'
!IIapi_uiDispatch: dispatching event IIAPI_EV_QUERY_FUNC
!Dispatch(-1226205472): SQL Stmt [091A8070] INIT --> SQRY, 2 action(s)
!Dispatch(-1226205472): action[1] REMC
!Dispatch(-1226205472): action[2] SQRY
!IIapi_liDispatch: queueing event IIAPI_EV_SEND_CMPL
!IIapi_liDispatch: dispatching event IIAPI_EV_SEND_CMPL
!Dispatch(-1226205472): SQL Stmt [091A8070] SQRY --> SENT, 1 action(s)
!Dispatch(-1226205472): action[1] CBOK
!IIapi_appCallback: request completed, status = SUCCESS
!IIapi_close: closing a query
!IIapi_close: stmtHndl = 091A8070
!IIapi_uiDispatch: dispatching event IIAPI_EV_CLOSE_FUNC
!Dispatch(-1226205472): SQL Stmt [091A8070] SENT --> WQRC, 2 action(s)
!Dispatch(-1226205472): action[1] REMC
!Dispatch(-1226205472): action[2] RECV
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESPONSE_RCVD
!IIapi_liDispatch: dispatching event IIAPI_EV_RESPONSE_RCVD
!Dispatch(-1226205472): SQL Stmt [091A8070] WQRC --> IDLE, 3 action(s)
!Dispatch(-1226205472): action[1] DELH
!Dispatch(-1226205472): action[2] CNOK
!Dispatch(-1226205472): action[3] CBOK
!IIapi_appCallback: request completed, status = SUCCESS
!IIapi_query: starting a query
!IIapi_query: connHndl = 091A5960, tranHndl = 091A69B8, queryType = 0
!IIapi_query: queryText = set lockmode session where readlock=nolock
!IIapi_uiDispatch: dispatching event IIAPI_EV_QUERY_FUNC
!Dispatch(-1226205472): SQL Stmt [091A6580] INIT --> SQRY, 2 action(s)
!Dispatch(-1226205472): action[1] REMC
!Dispatch(-1226205472): action[2] SQRY
!IIapi_liDispatch: queueing event IIAPI_EV_SEND_CMPL
!IIapi_liDispatch: dispatching event IIAPI_EV_SEND_CMPL
!Dispatch(-1226205472): SQL Stmt [091A6580] SQRY --> SENT, 1 action(s)
!Dispatch(-1226205472): action[1] CBOK
!IIapi_appCallback: request completed, status = SUCCESS
!IIapi_close: closing a query
!IIapi_close: stmtHndl = 091A6580
!IIapi_uiDispatch: dispatching event IIAPI_EV_CLOSE_FUNC
!Dispatch(-1226205472): SQL Stmt [091A6580] SENT --> WQRC, 2 action(s)
!Dispatch(-1226205472): action[1] REMC
!Dispatch(-1226205472): action[2] RECV
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESPONSE_RCVD
!IIapi_liDispatch: dispatching event IIAPI_EV_RESPONSE_RCVD
!Dispatch(-1226205472): SQL Stmt [091A6580] WQRC --> IDLE, 3 action(s)
!Dispatch(-1226205472): action[1] DELH
!Dispatch(-1226205472): action[2] CNOK
!Dispatch(-1226205472): action[3] CBOK
!IIapi_appCallback: request completed, status = SUCCESS
!IIapi_cancel: cancelling a query
!IIapi_cancel: invalid handle
!IIapi_appCallback: request completed, status = INVALID_HANDLE
!IIapi_close: closing a query
!IIapi_close: invalid statement handle
!IIapi_appCallback: request completed, status = INVALID_HANDLE
!IIapi_autocommit: set autocommit state
!IIapi_autocommit: connHndl = 091A5960, tranHndl = 091A69B8
!IIapi_uiDispatch: dispatching event IIAPI_EV_AUTO_FUNC
!Dispatch(-1226205472): SQL Tran [091A69B8] AUTO --> AOFF, 2 action(s)
!Dispatch(-1226205472): action[1] REMC
!Dispatch(-1226205472): action[2] SAOF
!IIapi_liDispatch: queueing event IIAPI_EV_SEND_CMPL
!IIapi_liDispatch: dispatching event IIAPI_EV_SEND_CMPL
!Dispatch(-1226205472): SQL Tran [091A69B8] AOFF --> WOFR, 1 action(s)
!Dispatch(-1226205472): action[1] RECV
!IIapi_wait(-1226205472): waiting for next event
!IIapi_wait: timeout = -1
!IIapi_liDispatch: queueing event IIAPI_EV_RESPONSE_RCVD
!IIapi_liDispatch: dispatching event IIAPI_EV_RESPONSE_RCVD
!Dispatch(-1226205472): SQL Tran [091A69B8] WOFR --> IDLE, 3 action(s)
!Dispatch(-1226205472): action[1] RRSP
!Dispatch(-1226205472): action[2] DELH
!Dispatch(-1226205472): action[3] CBOK
!IIapi_appCallback: request completed, status = SUCCESS
!IIapi_disconnect: disconnecting a connection
!IIapi_disconnect: connHndl = 091A5960
!IIapi_uiDispatch: dispatching event IIAPI_EV_DISCONN_FUNC
!Dispatch(-1226205472): SQL Conn [091A5960] CONN --> RLS, 2 action(s)
!Dispatch(-1226205472): action[1] REMC
!Dispatch(-1226205472): action[2] SRLS
!IIapi_liDispatch: queueing event IIAPI_EV_SEND_CMPL
!IIapi_liDispatch: dispatching event IIAPI_EV_SEND_CMPL
!Dispatch(-1226205472): SQL Conn [091A5960] RLS --> DISC, 1 action(s)
!Dispatch(-1226205472): action[1] DISC
!IIapi_liDispatch: queueing event IIAPI_EV_RESUME
!IIapi_liDispatch: dispatching event IIAPI_EV_RESUME
!Dispatch(-1226205472): SQL Conn [091A5960] DISC --> DISC, 1 action(s)
!Dispatch(-1226205472): action[1] REDO
!IIapi_liDispatch: queueing event IIAPI_EV_DISCONN_CMPL
!IIapi_liDispatch: dispatching event IIAPI_EV_DISCONN_CMPL
!Dispatch(-1226205472): SQL Conn [091A5960] DISC --> IDLE, 3 action(s)
!Dispatch(-1226205472): action[1] PEND
!Dispatch(-1226205472): action[2] DELH
!Dispatch(-1226205472): action[3] CBOK
!IIapi_appCallback: request completed, status = SUCCESS
!IIapi_releaseEnv: Release Environment
!IIapi_releaseEnv: envHndl = 09078018
!IIapi_terminate: shutdown API
!IIapi_releaseEnv: Release Environment
!IIapi_releaseEnv: envHndl = 090F9308
!IIapi_terminate: shutdown API
!IIapi_termAPI: shutting down API completely.
!IIapi_termAPI: API shutdown.