Symptom
- 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
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SUM 1.0 and 2.0 (latest SPs)
Keywords
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.