DB2 z/OS Archive Logs Mounted Hundreds Of Times During Extracts
Last updated on JANUARY 31, 2017
Applies to:Oracle GoldenGate - Version 220.127.116.11.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms