SAP Knowledge Base Article - Preview

2436302 - alter database does not show enhanced performance status - SAP ASE

Symptom

  • in tempdb, the table is created with dml_logging = minimal, object_attr() returns dml_logging as full.
  • 1> create table t(a int) with dml_logging=minimal
    2> go

    1> dmltest
    2> go
                                    db_durability
             db_dml_logging
             tab_dml_logging                                                                                                                                    
    ------------------------------ ------------------------------
    utdb                           no_recovery
             minimal
             full                                                                                                                                               
    1 row affected)

    -----------
              86

    (1 row affected)
    Operating on the table 't', database 'utdb' (owner ID 1) in 'full' logging mode
    by user ID 1.
    Operating on the table 't', database 'utdb' (owner ID 1) in 'full' logging mode
    by user ID 1.

    -----------
             236

    (1 row affected)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver

 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

alter database, tempdb, dml_logging=minimal, object_attr(), dml_logging = full, CR762262, CR#762262, 762262 , KBA , 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.