Topic
1 reply Latest Post - ‏2013-01-21T22:06:51Z by SystemAdmin
SystemAdmin
SystemAdmin
6772 Posts
ACCEPTED ANSWER

Pinned topic Getting more delay for SQL response

‏2013-01-21T07:14:16Z |
Hi

We are using DataPower XI50 version 3.8.2.14 and ODBC version 6.0. We are getting more delay for some of the SQL response.
Then we enabled debug log in DataPower as well as Database side. The DBA has analyzed their log and found no issue at Database side.

But we found some logs in DataPower particular operating taking almost 2 min (Received SQL response message). CPU and memory utilization are very normal.

Can you advice what will be the issue

The log at DataPower side

Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192)http://10.20.228.23: Queueing new SQL query for execution
Sat Jan 19 2013 19:06:43 sqlinfo sql-source(ODS_PRD_DB_HK_3): tid(19340192)http://10.20.228.23: Beginning SQL query execution
Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192)http://10.20.228.23: Writing query data to the SQL endpoint
Sat Jan 19 2013 19:06:43 sqlinfo sql-source(ODS_PRD_DB_HK_3): tid(19340192)http://10.20.228.23: Query data successfully written to SQL endpoint
Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340672): Reading SQL query data
Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340672): SQL query data read complete
Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192): Reusing existing connection
Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192): Prepare SQL query: SELECT…

Sat Jan 19 2013 19:06:43 sqlinfo sql-source(ODS_PRD_DB_HK_3): tid(19340192): SQL query execution succeeded
Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192): Writing results
Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192): The full results of the SQL select statement have been read
Sat Jan 19 2013 19:06:43 sqlinfo sql-source(ODS_PRD_DB_HK_3): tid(19340192): Fetched 4 rows
Sat Jan 19 2013 19:06:43 sqlinfo sql-source(ODS_PRD_DB_HK_3): tid(19340192): No more result sets
Sat Jan 19 2013 19:06:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192): Query execution complete
*Sat Jan 19 2013 19:08:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192)http://10.20.228.23: Received SQL response message*Sat Jan 19 2013 19:08:43 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192)http://10.20.228.23: Cleaning up SQL transaction resources
Sat Jan 19 2013 19:08:44 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192): Reading SQL query data
Sat Jan 19 2013 19:08:44 sqldebug sql-source(ODS_PRD_DB_HK_3): tid(19340192): SQL query data read complete
Updated on 2013-01-21T22:06:51Z at 2013-01-21T22:06:51Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    6772 Posts
    ACCEPTED ANSWER

    Re: Getting more delay for SQL response

    ‏2013-01-21T22:06:51Z  in response to SystemAdmin
    Please work with DataPower L2 by openeing a PMR for this issue. Please provide logs after changing the log level to debug for sql. Thanks.