Turning on Supplemental Logging at Database Level and Turning off Supplemental Logging at Table Level

Turn off supplemental logging at table level and turn on supplemental logging at database level..

  1. Run:
    ra_admin supplemental_logging_level, database
    The command generates an SQL script at this location:

    $SYBASE/RAX-15_5/<instance_name>/script/prepare/prepare_pdb_for_db_level.sql

    Note: You must have a database administrator role to perform step 2.
  2. Run the SQL script:
    $SYBASE/RAX-15_5/<instance_name>/script/prepare/prepare_pdb_for_db_level.sql
    The script turns on database level primary key and unique supplemental logging.