2000952 - Application and spid hangs with sp_who status in "send sleep" - SAP ASE

• User application hangs (typically Java jConnect) during large batch insert.
• spid remains stuck with status "send sleep" in sp_who
• dbcc stacktace(<hung_spid>) shows:

Start dbcc stacktrace...
upsleepgeneric()
ussflush()
sendbuffer()
sendhost()
s_i2Swap()
send_done()
senddone()
s_estmt_loopend()
s_xoltp_dml()
sequencer()
tdsrecv__process_batchparam()
tdsrecv__dynexec_batch()
tdsrecv__dynexec()
tdsrecv_dynamic()
conn_hdlr()
dbcc stacktrace finished.

Simllarly on AIX , a spid sending results to a client is hung in 'send sleep'

pthread_self
kpsuspend
upsleepgeneric
ussflush
sendbuffer
sendhost
sendichars
LeSendRow::_sendColsToClient

SAP Adaptive Server Enterprise (ASE) All Versions

IBM AIX Operating System only

CR790982, CR#790982, 788690,  CR#788690,  788690 , KBA , preparedstatement , statement.execute() , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed