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 ONE Support launchpad (Login required).

Search for additional results

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