SAP Knowledge Base Article - Preview

2224578 - DDLGen execution generates thousands of transaction log records - SAP ASE

Symptom

  • The high number of transaction log records (as shown below) happens the first time that DDLGen is executed after an ASE startup.

  • If the volume exceeds the Last Chance Threshold (LCT) it may cause an Error 1105  or in the extreme Error 3475.

    • Rowcount from syslogs before DDLGen:
      select count(*) from sybsystemprocs..syslogs
       -----------

                24

    • syslogs rowcounts after
      select count(*) from sybsystemprocs..syslogs
       -----------

          15239


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)  15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

DDLGEN, execute , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.