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)                                                                                                                                                                               

BEGIN                                                                                                                               

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]                                                                                                                                                                                                                  

END                                                                                                                             

ELSE                                                                                                                                                                                                                                                         

BEGIN                                                                                                                                                                                                                                                        

 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]                                                                                                                                                                                                                   

 END                                        

• 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