• October 19, 2018



iCluster Journal Analysis Report Part 1 – Basics

In the last 4 posts we covered the basics of journaling, as journaling is the main mechanism used by iCluster and other logical software replication tools running on IBM i. Now that we know how to determine what files/objects are being journaled to which journal and how to see what entries are in the journal, […]


Journals for Dummies Part 4 – DSPJRN and Journal Entry Types

In our last post we talked about how to find all the objects that are journaled to a particular journal. In this post we will cover how to analyze what is in your journals by journal entry type using the DSPJRN command. Once you know what journal and file or object you are interested in […]


Journals for Dummies Part 3 – What’s in there?

In our last post we talked about how to find the journal that is used by your file of interest. In this post we will cover how to look into the journal. We will follow this up with a post on how to analyze what is in your journals. First up is determining what other […]


Journals for Dummies Part 2: Finding Your Journal

In our last post we talked about the basics of journaling. There are two types of journals, the system audit journal QAUDJRN in QSYS and database journals. In this post we will cover how to figure out what is in the database journal. First you need to find the journal! If you are using iCluster […]


Journaling for Dummies

Journaling is the primary mechanism used by logical software replication tools such as Rocket iCluster and other products. Products such as IBM SystemMirror for IBM i or PowerHA use a combination of disk level mirroring done by the SAN or operating system based mirroring at the page level using IASPs (Independent Auxiliary Storage Pools). So […]


The iCluster Files with Constraints Report

In our post on Tuesday March 10th, we covered the Files with Triggers Report, which is option 7 from the Reports Menu. In this post we will cover the next report, File with Constraints. Use the DMRPTCST command to access this report as below. The command will report on all files using the current node […]


Using DMMRKPOS SAVOBJ(*YES) to synchronize iCluster 7.1 TR2

At iCluster 7.1 TR2 we introduced a new capability to the DMMRKPOS command to allow objects in replication scope to be automatically saved as part of the command. What this new capability does is reduce or eliminate the OBS (Obsolete) objects on the backup reported as out of sync by a *CHKOBSLETE sync check. Prior […]

Leap Second TechTuesday

Are you ready for the “Leap Second?”

Did you know that a “leap second” will be added to our clocks at midnight on June 30th 2015? What is that all about? The rotation of the earth around its axis is slowing as time goes by, thus the length of the day is increasing. This is due to mostly to the gravitational effects […]

Rocket Software TechTuesday

iCluster 7.1 TR2 Interim Fix 3 is GA

Interim Fix pack 3 has now been released and is generally available for Rocket iCluster 7.1 TR2. The package can be found at https://support.rocketsoftware.com/rsp-portal/downloads/categoryDetail?category=Rocket+iCluster under RIC-4810 Rocket iCluster 7.1 TR2 and can be applied quickly to your iCluster installation through an FTP file transfer of  a save file to each node, ending replication, restoring all […]


Workaround for creating an output file for files with triggers/constraints reports

In our last post we covered the File with Triggers Report, which is option 7 from the Reports Menu. For those folks who don’t read comments or perhaps skipped this blog post, it was discovered that the command actually fails to create an output database file if it does not already exist! Ooops! There is […]