Data group status in environments with journal cache or journal state - assure_mimix - 10.0

Assure MIMIX Operations Guide

Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software
Version
10.0
Language
English
Product name
Assure MIMIX
Title
Assure MIMIX Operations Guide
Copyright
2023
First publish date
1999
Last updated
2024-03-12
Published on
2024-03-12T11:06:36.794496

Additional information is reported within data group status configured to use MIMIX support for IBM’s High Availability Journal Performance IBM i option 42, Journal Standby feature and Journal caching. When these high availability journal performance enhancements are in use, conditions that require action or attention are reflected in these locations:

The Jrn State and Cache (Src and Tgt) fields reflect journal standby state and journal caching actual values for the journals when the IBM high availability performance enhancements are installed on the systems defined to the data group. These fields appear on database views 1 and 2 (Figure 18 and Figure 19). The target journal state and cache values are set on the journal when the database apply session is started.

For each system (Src or Tgt) status of the journal state is shown first, followed by the status of the journal cache. If a problem exists with journal state or journal cache, the data group name is also highlighted with the same color. For information about resolving journal cache or journal state problems, see Resolving a problem with journal cache or journal state.

Table 1. Possible status values for Journal State fields

Field

Color and Status

Description

Either system

White

U

Unknown. MIMIX was not able to retrieve values, possibly because the journal environment has not yet been built.

No color

A

Journal state is active

No color

X The required IBM feature, IBM i option 42 - High Availability Journal Performance, is not installed on this system

No color

S

Journal is in standby state as expected

Source

Red

S

Source journal is in standby state but that state is not expected.

Red I

Source journal in inactive state but that state is not expected.

Target

Yellow

S

Target journal state or cache is not as expected and the database apply session is active

Yellow I Target journal state is inactive but that state is not expected.
blank blank

The IBM feature is installed but the data group is configured to not journal on the target system.

Table 2. Possible status values for Journal Cache fields

Field

Color and Status

Description

White

U

Unknown. MIMIX was not able to retrieve values, possibly because the journal environment has not yet been built

Either System No color X The required IBM feature, IBM i option 42 - High Availability Journal Performance, is not installed on this system
No color Y Caching is active
No color N Caching is not active.
Source Yellow Y Source journal cache value is not as expected.
Yellow N Source journal cache value is not as expected.
Target Yellow Y Target journal cache value not as expected and the database apply session is active.
Yellow N Target journal cache value not as expected and the database apply session is active.
blank blank The IBM feature is installed but the data group is configured to not journal on the target system.