SAP Knowledge Base Article - Preview

3370061 - SUM hangs while executing task SYBSTATS in Phase MAIN_SHDRUN/SYB_UPDSTATS_ALTNTAB_FILL - SAP ASE for Business Suite


  • SUM upgrade is stuck in Phase MAIN_SHDRUN/SYB_UPDSTATS_ALTNTAB_FILL, while executing task SYBSTATS

  • Per the output of command: sp_monitor "connection" , executed in isql on the database, there are several SET SWITCH  spids which are stuck – each spid is executing below sql  --


if ((select ROW_COUNT(DB_ID(), OBJECT_ID('SAPSR3.TAB1'))) > 10000000)                                                                                                                                                                               


print 'Updating INDEX statistics for table [SAPSR3.TAB1] USING 20 VALUES WITH SAMPLING=30,HISTOGRAM_TUNING_FACTOR=20'                                                                                                                             

UPDATE INDEX STATISTICS [SAPSR3.TAB1] USING 20 VALUES WITH SAMPLING=30,HISTOGRAM_TUNING_FACTOR=20                                                                                                                                                  

EXEC sp_flushstats [SAPSR3.TAB1]                                                                                                                                                                                                                  




 print 'Updating INDEX statistics for table [SAPSR3.TAB1] USING 20 VALUES WITH HISTOGRAM_TUNING_FACTOR=20'                                                                                                                                                                                                 

 UPDATE INDEX STATISTICS [SAPSR3.TAB1] USING 20 VALUES WITH HISTOGRAM_TUNING_FACTOR=20                                                                                                                                                              

EXEC sp_flushstats [SAPSR3.TAB1]                                                                                                                                                                                                                   


  • ASE Auditing is enabled 




  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SUM 1.0 and 2.0 (latest SPs)


SUM, upgrade, SYBSTATS, "update index statistics", MAIN_SHDRUN/SYB_UPDSTATS_ALTNTAB_FILL, auditing, sysaudits, hanging, hangs, stuck , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.