Administer > Database administration > Data persistence > Database dictionary > Enable DDL logging of database dictionary changes

Enable DDL logging of database dictionary changes

Applies to User Roles:

System Administrator

You must have administrative access to the server operating system to use this procedure.

To enable DDL logging of database dictionary changes:

  1. Log on to the server running Service Manager.
  2. Stop the Service Manager server.
  3. Open the Service Manager initialization file (sm.ini) with a text editor.
  4. Add the following parameters to enable DDL logging of database dictionary changes:
    sqlddllogging:1
    sqlddldirectory:<path>
    For <path>, specify the relative path to the directory where you want Service Manager to save DDL files. This path is relative to the server's RUN directory.
  5. Save the Service Manager initialization file.
  6. Restart the Service Manager server.

Related topics

Database dictionary
Database dictionary records
Create an active database dictionary record
Create an inactive database dictionary record