Striving for Optimal Journal Performance on DB2 Universal Database for iSeries

An IBM Redbooks publication

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

Published 03 May 2002

cover image

ISBN-10: 073842319X
ISBN-13: 9780738423197
IBM Form #: SG24-6286-00
(178 pages)

More options

Rate and comment

Authors: Hernando Bedoya, Larry Youngren, Monti Abrahams, Yuhko Asaeda, Jon Mathews, Adam Stallman, Valentin Sueiro

Abstract

Journaling is an inherent feature of OS/400 on the iSeries that has been around since the early releases of the System/38. The system employs journals to ensure data integrity and recoverability and this support can further be extended to reduce the duration of an abnormal system end. Journaling also serves as the cornerstone upon which many data replication and data warehouse refresh schemes are built.

The aim of this IBM Redbooks publication is to provide you with an understanding of the factors which influence journal performance on the iSeries and to help you identify which hardware options and software settings you can employ to minimize this impact. We will also share with you some ideas on how to minimize the impact of journaling on your iSeries from an application point of view.

We also explain the remote journal function on the OS/400, which offers a reliable and fast method to transfer journal entries to a remote iSeries server. We performed tests concerning remote journal performance and tested this function in different environments.

Table of contents

Chapter 1. An introduction to journaling performance
Chapter 2. The testing environment
Chapter 3. Hardware choices
Chapter 4. Journaling tuning
Chapter 5. Application and software environment tuning
Chapter 6. Remote journaling performance
Chapter 7. Conclusion
Appendix A. How to calculate the fast write percentage

Follow IBM Redbooks

Follow IBM Redbooks