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.
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
isNo
, it means Journaling is not turned on.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.