SAP Knowledge Base Article - Preview

2064858 - Table-level attribute 'plldegree' not retained between statistics updates - SAP ASE for BS

Symptom

  • Apply the "plldegree" table-level attribute on individual SAP ASE tables and indexes at the database-level via the sp_chgattribute stored procedure.
    sp_chgattribute tab_name, "plldegree", degree_no will set the parallel degree 
     
  • Subsequently, though, when either update statistics is run, or if housekeeper flushes the table level stats, then the systabstats.plldegree for the respective table is reset to 0.
  • This disables consideration of parallelism for that table until the sp_chgattribute is re-executed.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite (BS)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.