SAP Knowledge Base Article - Preview

2487269 - Processes executing UPDATE STATISTICS may appear hang in the module ptn__datachange_reset

Symptom

Processes executing UPDATE STATISTICS on bound tables (des_bind) cannot be killed. The output of command 'dbcc stacktrace' reports the following functions:

kpsuspend
upsleepgeneric
ptn__datachange_reset
ptn_datachange_reset
sysstatistics_write
stat_write
ups_build
ups__updstats
ups__updstats_driver
update_statistics
ups_main
s_execute
sequencer
tdsrecv_language


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)  15.7 SP135
  • SAP Adaptive Server Enterprise (ASE)  16.0 SP02

Product

SAP Adaptive Server Enterprise 15.7

Keywords

update statistics ptn__datachange_reset sysstatistics_write stat_write des_bind bound bind kill killed 785196 790834 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.