DB2 z/OS Archive Logs Mounted Hundreds Of Times During Extracts
(Doc ID 2115318.1)
Last updated on FEBRUARY 14, 2020
Applies to:Oracle GoldenGate - Version 18.104.22.168.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.
MVS SYSLOG messages indicates that the archive log was being dismounted:
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,
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document