DB2 z/OS Archive Logs Mounted Hundreds Of Times During Extracts (Doc ID 2115318.1)

Last updated on JANUARY 31, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.10 and later
Information in this document applies to any platform.
Customer stated that after Extract process has been shutdown for a long period of time, individual DB2 archive logs are mounted hundreds of times. Eventually the extract moves on to the next archive log, and then mounts that one multiple times. Eventually it does catch up, and uses the DB2 Active Logs. We thought OGG would mount each archive log one time, process it, and then move on to the next one.

Symptoms

MVS SYSLOG messages indicates that the archive log was being dismounted:

 

SYSLOG
=======
09.35.39 STC01228 *IEC501A M 04BE,C06689,SL,NOCOMP,DSNTMSTR,DSNTMSTR,DB2TEST.ARCHLOG1.A0111933
09.36.25 STC01228 IEF234E K 04BE,C06689,PVT,DSNTMSTR,DSNTMSTR      <=== demount
09.36.25 STC01228 *IEC501A M 04A6,C06689,SL,NOCOMP,DSNTMSTR,DSNTMSTR,DB2TEST.ARCHLOG1.A0111933
09.37.08 STC01228 IEF234E K 04A6,C06689,PVT,DSNTMSTR,DSNTMSTR      <=== demount
...
10.50.41 STC01228 IEF234E K 0485,C06689,PVT,DSNTMSTR,DSNTMSTR
10.50.41 STC01228 *IEC501A M 04B7,C06689,SL,NOCOMP,DSNTMSTR,DSNTMSTR,DB2TEST.ARCHLOG1.A0111933
10.51.04 STC01228 IEF234E K 04B7,C06689,PVT,DSNTMSTR,DSNTMSTR
10.51.04 STC01228 *IEC501A M 04B8,C06689,SL,NOCOMP,DSNTMSTR,DSNTMSTR,DB2TEST.ARCHLOG1.A0111933
10.51.26 STC01228 IEF234E K 04B8,C06689,PVT,DSNTMSTR,DSNTMSTR
10.51.26 STC01228 *IEC501A M 04A6,C06689,SL,NOCOMP,DSNTMSTR,DSNTMSTR,DB2TEST.ARCHLOG1.A0111933
10.51.33 STC01228 DSNJ002I + FULL ACTIVE LOG DATA SET 264
264 DSNAME=DB2TEST.LOGCOPY1.DS02, STARTRBA=12125DCC0000,
264 ENDRBA=12125FF33FFF

REF:
IEF234E K ==> The volume is to be demounted and returned to the library.
IEC501A -> IEC501E is issued by Open or EOV when the volume to be mounted is not needed immediately (this is referred to as a "look-ahead" mount). The volume indicated by ser is the next volume to be processed after the system finishes processing the current volume.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms