SAP Knowledge Base Article - Preview

2172370 - Suspect granularity setting for a user database - SAP ASE

Symptom

  • The sp_helpdb ouput for a user database shows:

name        attribute_class   attribute           int_value char_value comments
 ---- ----------------- ------------------- --------- ---------- --------
 <db_name>  High Availability suspect granularity         2 NULL       NULL

  • And the following message are in the errorlog:

Recovering database '<db_name>'.
Recovery (Suspect Granularity): Settings for database '<db_name>'- Suspect Granularity: 'Page    ', Suspect Threshold: 20, Online Option: 'Read/Write'.
...
Recovery (Suspect Granularity): Database '<db_name>' is clean.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

isolation, mode, sp_setsuspect_granularity, page, level , 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 ONE Support launchpad (Login required).

Search for additional results

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