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.