Activating Journaling

Note: This procedure is only applicable to DB2 for i JD Edwards EnterpriseOne databases running on IBM i machines.

As described by this procedure, for DB2 for i databases you must activate journaling on the Unique Sequence (F90730) table.

1. Verify that journaling is activated by entering this command on the IBM i machine:

   WRKOBJ OBJ(library_name/table_name)OBJTYPE(*FILE)

   Where table_name is F90730.

   Select option 8. Page down to see Journaling information. If Currently journaled is No, it means Journaling is not turned on.

2. To turn journaling on for the table enter this command:

   STRJRNPF FILE(library_name/table_name JRN(OWJRNL/OW_JRNL)

   Where table_name is F90730.