Enabling Change Capture

To capture changes to a table in a journal, you can run the STRJRNPF command on the OS/400 command line or run the ADD TRANDATA command from GGSCI. The ADD TRANDATA command calls STRJRNPF and is the recommended method to start journaling for tables, because it ensures that the required journal image attribute of Record Images (IMAGES): *BOTH is set on the STRJRNPF command.

To Run ADD TRANDATA

  1. Run GGSCI on the source system.
  2. Issue the DBLOGIN command.
    DBLOGIN SOURCEDB database USERID user, PASSWORD password [encryption_options]

    Where: SOURCEDB specifies the default DB 2 for i database, USERID specifies the Extract user profile, and PASSWORD specifies that profile's password.

  3. Issue the ADD TRANDATA command.
    ADD TRANDATA table_specification

    Where: table_specification is one of the following:

    • schema.table [JOURNAL library/journal]
    • library/file [JOURNAL  library/journal]