Removing journaled changes with the WRKJRN command

 

Remove journaled changes with the Work With Journal (WRKJRN) command by selecting Option 3 (Backout recovery).

After selecting Option 3 , a menu display gives you the option to select either physical files or data areas as the object type. Then, after selecting one of the object types, a list of the journaled objects of that type is displayed.

The Work with Backout Recovery display is useful because the system guides you through the process. However, it can be used for journaling access paths, database files, and data areas only.

The same options on the Work with Forward Recovery display are available on the Work with Backout Recovery display, except the option to restore the object. However, the option to restore the object is not valid for backout recovery. The status field that is shown on the Work with Backout Recovery display is either blank or it indicates the same status as for forward recovery, except for Restore Complete.

The status field for each object indicates the following:

• Not found

• Damaged

• Not synchronized

• Recovered

• Not journaled

• Different journal

 

Tasks with the Work With Backout Recovery display

You can use the Work With Backout Recovery display to perform the following tasks:

Add object to list

To add an object to the list select Option 1 (Add object to list).

Remove journaled changes

To remove journaled changes, select Option 2 (Remove journaled changes). Option 2 shows the Remove Journaled Changes (RMVJRNCHG) command prompt, removes the journaled changes, and changes the status to Recovered (if the operation was successful). If any required journal receivers are missing or damaged while the RMVJRNCHG command is running, the system displays prompts for the necessary restore procedures for the missing or damaged receivers. If the remove operation was not successful, messages appear indicating why the status remains the same.

If any objects in the list have a status of Not Found or Damaged when on the Work with Backout Recovery display, the operation is not allowed. These objects must be recovered in a forward fashion after they have been restored. Forward recovery of specific files must be used for this type of recovery.

Remove object from list

Use Option 4 (Remove object from list) to remove objects from the list.

 

Parent topic:

Removing journaled changes

Related tasks
Applying journaled changes with the WRKJRN command