Sample Header Ad - 728x90

Meaning of FETCH_CURSOR jconnect_implicit_1 in Sybase

0 votes
1 answer
283 views
# Situation I am trying to troubleshoot performance when connecting to Sybase ASE Version 15.7 from Sqoop over JDBC. Though I cannot check things myself it appears to be 10x slower to extract data this way then with another tool (which uses ODBC). # Observation The DB team has observed the following: enter image description here # Question: ### What is the meaning of FETCH_SIZE jconnect_implicit_1:? Of course other hints on what may be causing the performance issue are welcome as well. ---- The DB team believes it means a cursor is made for each row, perhaps because of this link which contains something vaguely similar , but I suspect it means something else as I have not found any reference of Oozie causing this over JDBC (we enforce a larger fetch size in the oozie command).
Asked by Dennis Jaheruddin (103 rep)
Jan 16, 2020, 02:42 PM
Last activity: Jan 16, 2020, 05:28 PM