Start or end a journal for a table

Once a journal is created, it must be started for a table. If you want to delete a journal, it must be stopped.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Journals container.
  5. Right-click the journal and select Starts and ends table journaling.
  6. To start journaling for a table, select the table that you want to journal from the Tables list and then click Add.
  7. To end journaling for a table, select the table that you no longer want to journal from the Tables already being journaled list, and then click Remove.
  8. To end journaling for all the tables at once, click Select all to select all the tables listed in the Tables already being journaled list, and then click Remove.
  9. Click OK.

You can also start and end journaling from the table object:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Tables container.
  5. Right-click a table and select Journaling.
  6. Select a journal to associate with the object. You may browse for the journal by selecting Browse.
  7. Select a schema that the journal is located in. This field is automatically filled in when you select a journal from Browse.
  8. To omit open and close entries from being journaled, select the Exclude open and close entries option.
  9. Click Start to start journaling for the selected object.