Sequence for restoring related objects

Some objects depend on other objects. For example, SQL materialized query tables (MQTs) are physical database files, but like logical files and SQL views, have dependencies on other files. When related objects are in the same library or directory, the system restores them in the correct order. If related objects are in different libraries or directories, you must restore them in the correct order or perform additional recovery steps after they are restored.

If possible, restore objects in the following sequence:

• Journals before journaled objects. If you restore a journaled object when the journal is not on the system, you must start journaling again after the journal is restored. Use the Start Journal Physical File (STRJRNPF) command, the Start Journal Access Path (STRJRNAP) command, the Start Journal Object (STRJRNOBJ) command, the Start Journal (STRJRN) command, or the Start Journal Library (STRJRNLIB) command.
• Journals before journal receivers. If you restore a journal receiver when the journal is not on the system, you must associate the journal receivers with the journal after it is restored. Use the Work with Journal (WRKJRN) command.
• Physical files before logical files or MQTs. You cannot restore a logical file or MQT if the based-on physical files are not on the system.