SAP Knowledge Base Article - Preview

3259509 - DBCC CHECKSTORAGE hangs on archive database with single worker process - SAP ASE

Symptom

  • after loading a compressed database dump onto an archive database and running dbcc checkstorage against it, the command hangs
  • parallelism disabled
  • dbcc stacktrace (<checkstorage_spid>) on parent process reports the following calls :

    upyield
    pchk_pt_get_work_1   
    pchk_pt_work_done   
    pchk_pt_wait       
    pchk_pt_do_check     
    checkstorage    
    exec_dbcc          
    s_execute
    sequencer        
    tdsrecv_language
    conn_hdlr
  • dbcc stacktrace (<checkstorage_worker_thread>) reports the following calls:

    upsleepgeneric       
    uwrecv                   
    pchk_scan_main           
    pchk_wt_main         
    kw_exec                  
    kw_member 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 

Product

SAP Business Technology Platform all versions

Keywords

checkstorage hangs, uwrecv , pchk_pt_get_work_1, archivedb , 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.