Ending journaling
This topic provides information about how to end journaling and why ending journaling might be necessary.
You may need to end journaling for several reasons:
- If a journal is damaged and you need to delete it, first end journaling for all objects assigned to the journal.
- In some situations, you might want to end journaling before running a large batch application, if that application has exclusive use of the object. This is done either to improve the speed of the batch application or to reduce the auxiliary storage needed for the journal receiver. If you do this, use this method:
- End journaling for the objects.
- If journaling physical files save them specifying ACCPTH(*YES).
- If journaling other object types, save them.
- Run the batch application.
- Start journaling for the objects.
- Save the physical files, specifying ACCPTH(*YES).
- Save the other journaled objects.
To end journaling, proceed as follows:
- End journaling for access paths with the End Journal Access Path (ENDJRNAP) command
- In iSeries™ Navigator expand the system with the object that you want stop journaling.
- If the object is a database file, proceed as follows:
- Expand Databases and the database with the journal that you want to end journaling.
- Expand Schemas.
- Click the schema with the table (file) you are journaling.
- Click Tables.
- Right-click table and select Journaling.
- Click End to end journaling.
- If the object is an integrated file system object proceed as follows:
- Expand File Systems.
- Expand Integrated File System.
- Expand the file system with the object you are ending journaling.
- If you are ending journaling for a directory, right click that directory. If you are ending journaling for an object in a directory, open the directory and right click the object.
- Right-click the object or directory and select Journaling
- Click End to end journaling.
- If the object is a data area or data queue, proceed as follows:
- Expand File Systems.
- Expand Integrated File System.
- Expand QSYS.LIB.
- Select the library with the data area or data queue.
- Right-click the data area or data queue you want to end journaling and select Journaling.
- Click End to end journaling.
Or, use the following commands or API to end journaling:
- End Journal Access Path (ENDJRNAP) command for access paths
- End Journal Physical File (ENDJRNPF) command for database files
- End Journal (ENDJRN) command for integrated file system objects
- End Journal Object (ENDJRNOBJ) command for other objects
- End Journal (QjoEndJournal) API for integrated file system objects, data areas, and data queues.
You must end journaling for any access paths based on a physical file before you can end journaling for the physical file.
In the following cases, the system implicitly ends journaling:
- When you delete an object, journaling is ended for the object.
- When you remove a physical file member, journaling is ended for the member.
- When you remove a physical file member, journaling is ended for any access paths associated with the member unless an access path is shared and journaled by another file member.
- When you delete a file, journaling is ended for any access paths associated with the file unless an access path is shared and journaled by another file.
When you successfully end journaling on a distributed file, the system distributes the end journal request to the other systems in the node group. All systems are attempted even if there is a failure at any one system. Once journaling is ended on a system in the node group, it stays ended even if there is a failure at any of the other systems.
Even if a distributed file is not locally journaled, and if you specify the file name and the journal name on the ENDJRNPF command, the system will still attempt to distribute the end-journal request to the other systems in the file node group.
Parent topic:
Starting and ending journaling and changing journaling attributesRelated concepts
Distributed database administration