2361809 - js_history and js_output table in sybmgmtdb growth issue - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2361809 - js_history and js_output table in sybmgmtdb growth issue - SAP ASE

Symptom

If the Job Scheduler is used in ASE(ex. ATM, DBA Planning Calender and DCF in DBA Cockpit is using it), it might be stopped by out of space the data or log segment of ​​the sybmgmtdb.
In many cases, the cause is that js_history and js_output table that to store the execution history and output is increased.

Typically, the data in these tables will be truncated by the threshold procedure "sp_js_history_thresh" on the "default" segment.
This threshold is set to 10% of the initial size of sybmgmtdb, if the Job Scheduler has been executed, such as dbcc checkdb to output a lot of results, the threshold procedure may not work correctly.

(ASE Errorlog)
server  background task error 19099: Procedure sp_js_history_thresh, Warning the free data space threshold in database sybmgmtdb has been exceeded. Segment default has 947 free pages, attempting to create space by cleaning job history and output.
server  background task error 19103: Procedure sp_js_history_thresh, History (rows): current 4423, target 3096. Output (rows): current 276576, target 138288. Free space (pages): current 947, target 1076.
server  The transaction log in database sybmgmtdb is almost full. Your transaction is being suspended until space is made available in the log.

If you are adding a job such as the following to the DBA Planning Calendar, you need to pay attention to the increase in history and output.

  • DBCC CHECKDB.
  • UPDATE STATISTICS to a lot of tables.

Please check, "Database<SID>" > "Space" > "Show Growth" for sybmgmtdb in DBA Cockpit.


Read more...

Environment

  • SAP Adaptive Server Enterprise 16.0
  • SAP Adaptive Server Enterprise 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

1105, Automatic Table Maintainance, SQL1105, js_output, js_history, "Error: 1105", sp_addthreshold, sp_modifythreshold , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.