Skip to main content

Journaling at object creation on DB2 for iSeries

Web Doc

Note: This is publication is now archived. For reference only.


Published on 17 May 2006, updated 28 November 2006

  1. View in HTML

Share this page:   

IBM Form #: TIPS0604

Authors: Hernando Bedoya

    menu icon


    There is often a time gap between the time a file is created and the time some person or product turns on journaling protection for this newly created object. In some environments, that time gap represents a risk: What if an application adds data to this new object before journal protection is enabled?

    For that reason, especially in environments that demand high availability, it is desirable to find a mechanism by which you can assure that no such time gap exists. What if you could assure that newly created objects, such as database files, had journaling enabled at creation?

    Is that possible?


    This has always been the default behavior for SQL tables. Now you can have similar behavior for native DB2® files as well as for data areas and data queues.



    Special Notices

    The material included in this document is in DRAFT form and is provided 'as is' without warranty of any kind. IBM is not responsible for the accuracy or completeness of the material, and may update the document at any time. The final, published document may not include any, or all, of the material included herein. Client assumes all risks associated with Client's use of this document.