Re: Writing DB2 Archlog to tape
Hi Gadi, We had this issue once a while back when moving ARCHLOG2 to virtual tape. The SMS rules were changed to direct the archlog2 files to the virtual tape, but the UNIT2 parm in DSN6ARVP was still set to SYSDA. Once UNIT2 was set to the correct value, we no longer had the problem. Regards, Ron -Original Message- From: IBM Mainframe Discussion List On Behalf Of Gadi Ben-Avi Sent: Wednesday, 10 July 2019 2:59 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Writing DB2 Archlog to tape Hi, I was asked by our DB2 DBA to direct one of the DB2 ARCHLOGS to tape - Virtual tape on a TS7760. I changed our SMS STORCLAS routine to direct the correct files to the TAPE Storage class. That DATACLAS routine was also changed to associate the correct DATACLAS to the file. I tested using ISMF and saw that the changes did what I wanted. When we told DB2 to create a new ARCHLOG we saw that one of the ARCHLOGs is created ok and cataloged, and the other one is not cataloged. Further investigation showed that both files were created on the same virtual tape. These are the messages we saw in DB2: 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 658 658 DSNAME=DB2P.LOGCOPY1.DS06, STARTRBA=001D99C2C000, 658 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=001D99C2C000, 660 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ311I -DB2P DSNJC005 ASYNCHRONOUS LOG ARCHIVE 662 662 (OFFLOAD) TASK INITIATED 15.51.52 STC51072 DSN9022I -DB2P DSNJC001 '-ARCHIVE LOG' NORMAL COMPLETION 15.51.53 STC51072 CTT100A M 0B0C,PRIVAT,SL,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034, 664 664 OR RESPOND TO IEF455D MESSAGE 15.51.56 STC51072 IEC705I TAPE ON 0B0C,P09079,SL,COMP,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034,MEDIA2 15.51.56 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=1, COMPLETE VOLUME LIST, 666 666 DSN=DB2P.ARCHLOG2.B0003034,VOLS=P09079,TOTALBLOCKS=130 15.51.58 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 667 667 DSNAME=DB2P.ARCHLOG1.A0003034, STARTRBA=001D99C2C000, 667 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 667 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY1VOL=DB2BB3, VOLSPAN=00, 667 CATLG=YES 15.51.58 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=2, COMPLETE VOLUME LIST, 668 668 DSN=DB2P.ARCHLOG2.A0003034,VOLS=P09079,TOTALBLOCKS=5068 15.51.59 STC51072 IEF234E K 0B0C,P09079,PVT,DB2PMSTR,DB2PMSTR 15.51.59 STC51072 IKJ56893I FILE SYS00188 NOT UNALLOCATED+ 15.51.59 STC51072 IGD17101I DATA SET DB2P.ARCHLOG2.A0003034 671 671 NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG 671 RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH 15.51.59 STC51072 DSNJ228I -DB2P DSNJDS01 LOG DEALLOCATION ERROR 672 672 DSNAME=DB2P.ARCHLOG2.A0003034, ERROR STATUS=9714, SMS REASON 672 CODE=42CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=001D99C2C000, 673 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 673 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY2VOL=P09079, VOLSPAN=00, 673 CATLG=YES 15.51.59 STC51072 DSNJ138I -DB2P DSNJOFF1 OFFLOAD COMPLETE FOR LOG 674 674 TRUNCATION FROM AN ARCHIVE LOG COMMAND, ENDRBA=001DA12F2FFF 15.51.59 STC51072 DSNJ139I -DB2P LOG OFFLOAD TASK ENDED After the command completed DB2P.ARCHLOG2.A0003034 and DB2P.ARCHLOG2.B0003034 were on the same virtual volume (P09079), but only DB2P.ARCHLOG2.A0003034 was cataloged. Can this be solved using DB2? Can this be solved using SMS? This is running on z/OS v2.3 and DB2 v11 Thanks Gadi -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN __ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com __
Re: Writing DB2 Archlog to tape
My apologies, the macro is DSN6ARVP. CSQ is MQ. Regards, Kevin From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Neubert, Kevin Sent: Thursday, July 11, 2019 7:34 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Writing DB2 Archlog to tape I don't believe this can be changed dynamically like MQ (SET ARCHIVE). Revisit the the CSQ6ARVP macro. Regards, Kevin From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Gadi Ben-Avi [gad...@malam.com] Sent: Wednesday, July 10, 2019 9:15 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Writing DB2 Archlog to tape No, Unit=work is not correct Gadi -Original Message- From: IBM Mainframe Discussion List On Behalf Of Neubert, Kevin Sent: Wednesday, July 10, 2019 11:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Writing DB2 Archlog to tape DB2P.ARCHLOG2.B0003034 and DB2P.ARCHLOG2.A0003034 should be one tape. The prior is the BSDS copy and latter is the archive log. In the DSNJ003I message associated with DB2P.ARCHLOG2.A0003034 is UNIT=WORK correct? Do you see a catalog entry for DB2P.ARCHLOG2.A0003034 related to disk? Regards, Kevin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi Sent: Tuesday, July 9, 2019 11:59 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Writing DB2 Archlog to tape Hi, I was asked by our DB2 DBA to direct one of the DB2 ARCHLOGS to tape - Virtual tape on a TS7760. I changed our SMS STORCLAS routine to direct the correct files to the TAPE Storage class. That DATACLAS routine was also changed to associate the correct DATACLAS to the file. I tested using ISMF and saw that the changes did what I wanted. When we told DB2 to create a new ARCHLOG we saw that one of the ARCHLOGs is created ok and cataloged, and the other one is not cataloged. Further investigation showed that both files were created on the same virtual tape. These are the messages we saw in DB2: 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 658 658 DSNAME=DB2P.LOGCOPY1.DS06, STARTRBA=001D99C2C000, 658 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=001D99C2C000, 660 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ311I -DB2P DSNJC005 ASYNCHRONOUS LOG ARCHIVE 662 662 (OFFLOAD) TASK INITIATED 15.51.52 STC51072 DSN9022I -DB2P DSNJC001 '-ARCHIVE LOG' NORMAL COMPLETION 15.51.53 STC51072 CTT100A M 0B0C,PRIVAT,SL,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034, 664 664 OR RESPOND TO IEF455D MESSAGE 15.51.56 STC51072 IEC705I TAPE ON 0B0C,P09079,SL,COMP,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034,MEDIA2 15.51.56 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=1, COMPLETE VOLUME LIST, 666 666 DSN=DB2P.ARCHLOG2.B0003034,VOLS=P09079,TOTALBLOCKS=130 15.51.58 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 667 667 DSNAME=DB2P.ARCHLOG1.A0003034, STARTRBA=001D99C2C000, 667 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 667 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY1VOL=DB2BB3, VOLSPAN=00, 667 CATLG=YES 15.51.58 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=2, COMPLETE VOLUME LIST, 668 668 DSN=DB2P.ARCHLOG2.A0003034,VOLS=P09079,TOTALBLOCKS=5068 15.51.59 STC51072 IEF234E K 0B0C,P09079,PVT,DB2PMSTR,DB2PMSTR 15.51.59 STC51072 IKJ56893I FILE SYS00188 NOT UNALLOCATED+ 15.51.59 STC51072 IGD17101I DATA SET DB2P.ARCHLOG2.A0003034 671 671 NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG 671 RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH 15.51.59 STC51072 DSNJ228I -DB2P DSNJDS01 LOG DEALLOCATION ERROR 672 672 DSNAME=DB2P.ARCHLOG2.A0003034, ERROR STATUS=9714, SMS REASON 672 CODE=42CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=001D99C2C000, 673 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 673 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY2VOL=P09079, VOLSPAN=00, 673 CATLG=YES 15.51.59 STC51072 DSNJ138I -DB2P DSNJOFF1 OFFLOAD COMPLETE FOR LOG 674 674
Re: Writing DB2 Archlog to tape
I don't believe this can be changed dynamically like MQ (SET ARCHIVE). Revisit the the CSQ6ARVP macro. Regards, Kevin From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Gadi Ben-Avi [gad...@malam.com] Sent: Wednesday, July 10, 2019 9:15 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Writing DB2 Archlog to tape No, Unit=work is not correct Gadi -Original Message- From: IBM Mainframe Discussion List On Behalf Of Neubert, Kevin Sent: Wednesday, July 10, 2019 11:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Writing DB2 Archlog to tape DB2P.ARCHLOG2.B0003034 and DB2P.ARCHLOG2.A0003034 should be one tape. The prior is the BSDS copy and latter is the archive log. In the DSNJ003I message associated with DB2P.ARCHLOG2.A0003034 is UNIT=WORK correct? Do you see a catalog entry for DB2P.ARCHLOG2.A0003034 related to disk? Regards, Kevin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi Sent: Tuesday, July 9, 2019 11:59 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Writing DB2 Archlog to tape Hi, I was asked by our DB2 DBA to direct one of the DB2 ARCHLOGS to tape - Virtual tape on a TS7760. I changed our SMS STORCLAS routine to direct the correct files to the TAPE Storage class. That DATACLAS routine was also changed to associate the correct DATACLAS to the file. I tested using ISMF and saw that the changes did what I wanted. When we told DB2 to create a new ARCHLOG we saw that one of the ARCHLOGs is created ok and cataloged, and the other one is not cataloged. Further investigation showed that both files were created on the same virtual tape. These are the messages we saw in DB2: 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 658 658 DSNAME=DB2P.LOGCOPY1.DS06, STARTRBA=001D99C2C000, 658 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=001D99C2C000, 660 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ311I -DB2P DSNJC005 ASYNCHRONOUS LOG ARCHIVE 662 662 (OFFLOAD) TASK INITIATED 15.51.52 STC51072 DSN9022I -DB2P DSNJC001 '-ARCHIVE LOG' NORMAL COMPLETION 15.51.53 STC51072 CTT100A M 0B0C,PRIVAT,SL,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034, 664 664 OR RESPOND TO IEF455D MESSAGE 15.51.56 STC51072 IEC705I TAPE ON 0B0C,P09079,SL,COMP,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034,MEDIA2 15.51.56 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=1, COMPLETE VOLUME LIST, 666 666 DSN=DB2P.ARCHLOG2.B0003034,VOLS=P09079,TOTALBLOCKS=130 15.51.58 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 667 667 DSNAME=DB2P.ARCHLOG1.A0003034, STARTRBA=001D99C2C000, 667 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 667 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY1VOL=DB2BB3, VOLSPAN=00, 667 CATLG=YES 15.51.58 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=2, COMPLETE VOLUME LIST, 668 668 DSN=DB2P.ARCHLOG2.A0003034,VOLS=P09079,TOTALBLOCKS=5068 15.51.59 STC51072 IEF234E K 0B0C,P09079,PVT,DB2PMSTR,DB2PMSTR 15.51.59 STC51072 IKJ56893I FILE SYS00188 NOT UNALLOCATED+ 15.51.59 STC51072 IGD17101I DATA SET DB2P.ARCHLOG2.A0003034 671 671 NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG 671 RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH 15.51.59 STC51072 DSNJ228I -DB2P DSNJDS01 LOG DEALLOCATION ERROR 672 672 DSNAME=DB2P.ARCHLOG2.A0003034, ERROR STATUS=9714, SMS REASON 672 CODE=42CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=001D99C2C000, 673 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 673 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY2VOL=P09079, VOLSPAN=00, 673 CATLG=YES 15.51.59 STC51072 DSNJ138I -DB2P DSNJOFF1 OFFLOAD COMPLETE FOR LOG 674 674 TRUNCATION FROM AN ARCHIVE LOG COMMAND, ENDRBA=001DA12F2FFF 15.51.59 STC51072 DSNJ139I -DB2P LOG OFFLOAD TASK ENDED After the command completed DB2P.ARCHLOG2.A0003034 and DB2P.ARCHLOG2.B0003034 were on the same virtual volume (P09079), but only DB2P.ARCHLOG2.A0003034 was cataloged. Can
Re: Writing DB2 Archlog to tape
No, Unit=work is not correct Gadi -Original Message- From: IBM Mainframe Discussion List On Behalf Of Neubert, Kevin Sent: Wednesday, July 10, 2019 11:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Writing DB2 Archlog to tape DB2P.ARCHLOG2.B0003034 and DB2P.ARCHLOG2.A0003034 should be one tape. The prior is the BSDS copy and latter is the archive log. In the DSNJ003I message associated with DB2P.ARCHLOG2.A0003034 is UNIT=WORK correct? Do you see a catalog entry for DB2P.ARCHLOG2.A0003034 related to disk? Regards, Kevin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi Sent: Tuesday, July 9, 2019 11:59 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Writing DB2 Archlog to tape Hi, I was asked by our DB2 DBA to direct one of the DB2 ARCHLOGS to tape - Virtual tape on a TS7760. I changed our SMS STORCLAS routine to direct the correct files to the TAPE Storage class. That DATACLAS routine was also changed to associate the correct DATACLAS to the file. I tested using ISMF and saw that the changes did what I wanted. When we told DB2 to create a new ARCHLOG we saw that one of the ARCHLOGs is created ok and cataloged, and the other one is not cataloged. Further investigation showed that both files were created on the same virtual tape. These are the messages we saw in DB2: 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 658 658 DSNAME=DB2P.LOGCOPY1.DS06, STARTRBA=001D99C2C000, 658 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=001D99C2C000, 660 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ311I -DB2P DSNJC005 ASYNCHRONOUS LOG ARCHIVE 662 662 (OFFLOAD) TASK INITIATED 15.51.52 STC51072 DSN9022I -DB2P DSNJC001 '-ARCHIVE LOG' NORMAL COMPLETION 15.51.53 STC51072 CTT100A M 0B0C,PRIVAT,SL,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034, 664 664 OR RESPOND TO IEF455D MESSAGE 15.51.56 STC51072 IEC705I TAPE ON 0B0C,P09079,SL,COMP,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034,MEDIA2 15.51.56 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=1, COMPLETE VOLUME LIST, 666 666 DSN=DB2P.ARCHLOG2.B0003034,VOLS=P09079,TOTALBLOCKS=130 15.51.58 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 667 667 DSNAME=DB2P.ARCHLOG1.A0003034, STARTRBA=001D99C2C000, 667 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 667 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY1VOL=DB2BB3, VOLSPAN=00, 667 CATLG=YES 15.51.58 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=2, COMPLETE VOLUME LIST, 668 668 DSN=DB2P.ARCHLOG2.A0003034,VOLS=P09079,TOTALBLOCKS=5068 15.51.59 STC51072 IEF234E K 0B0C,P09079,PVT,DB2PMSTR,DB2PMSTR 15.51.59 STC51072 IKJ56893I FILE SYS00188 NOT UNALLOCATED+ 15.51.59 STC51072 IGD17101I DATA SET DB2P.ARCHLOG2.A0003034 671 671 NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG 671 RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH 15.51.59 STC51072 DSNJ228I -DB2P DSNJDS01 LOG DEALLOCATION ERROR 672 672 DSNAME=DB2P.ARCHLOG2.A0003034, ERROR STATUS=9714, SMS REASON 672 CODE=42CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=001D99C2C000, 673 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 673 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY2VOL=P09079, VOLSPAN=00, 673 CATLG=YES 15.51.59 STC51072 DSNJ138I -DB2P DSNJOFF1 OFFLOAD COMPLETE FOR LOG 674 674 TRUNCATION FROM AN ARCHIVE LOG COMMAND, ENDRBA=001DA12F2FFF 15.51.59 STC51072 DSNJ139I -DB2P LOG OFFLOAD TASK ENDED After the command completed DB2P.ARCHLOG2.A0003034 and DB2P.ARCHLOG2.B0003034 were on the same virtual volume (P09079), but only DB2P.ARCHLOG2.A0003034 was cataloged. Can this be solved using DB2? Can this be solved using SMS? This is running on z/OS v2.3 and DB2 v11 Thanks Gadi -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Writing DB2 Archlog to tape
DB2P.ARCHLOG2.B0003034 and DB2P.ARCHLOG2.A0003034 should be one tape. The prior is the BSDS copy and latter is the archive log. In the DSNJ003I message associated with DB2P.ARCHLOG2.A0003034 is UNIT=WORK correct? Do you see a catalog entry for DB2P.ARCHLOG2.A0003034 related to disk? Regards, Kevin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi Sent: Tuesday, July 9, 2019 11:59 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Writing DB2 Archlog to tape Hi, I was asked by our DB2 DBA to direct one of the DB2 ARCHLOGS to tape - Virtual tape on a TS7760. I changed our SMS STORCLAS routine to direct the correct files to the TAPE Storage class. That DATACLAS routine was also changed to associate the correct DATACLAS to the file. I tested using ISMF and saw that the changes did what I wanted. When we told DB2 to create a new ARCHLOG we saw that one of the ARCHLOGs is created ok and cataloged, and the other one is not cataloged. Further investigation showed that both files were created on the same virtual tape. These are the messages we saw in DB2: 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 658 658 DSNAME=DB2P.LOGCOPY1.DS06, STARTRBA=001D99C2C000, 658 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=001D99C2C000, 660 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ311I -DB2P DSNJC005 ASYNCHRONOUS LOG ARCHIVE 662 662 (OFFLOAD) TASK INITIATED 15.51.52 STC51072 DSN9022I -DB2P DSNJC001 '-ARCHIVE LOG' NORMAL COMPLETION 15.51.53 STC51072 CTT100A M 0B0C,PRIVAT,SL,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034, 664 664 OR RESPOND TO IEF455D MESSAGE 15.51.56 STC51072 IEC705I TAPE ON 0B0C,P09079,SL,COMP,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034,MEDIA2 15.51.56 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=1, COMPLETE VOLUME LIST, 666 666 DSN=DB2P.ARCHLOG2.B0003034,VOLS=P09079,TOTALBLOCKS=130 15.51.58 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 667 667 DSNAME=DB2P.ARCHLOG1.A0003034, STARTRBA=001D99C2C000, 667 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 667 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY1VOL=DB2BB3, VOLSPAN=00, 667 CATLG=YES 15.51.58 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=2, COMPLETE VOLUME LIST, 668 668 DSN=DB2P.ARCHLOG2.A0003034,VOLS=P09079,TOTALBLOCKS=5068 15.51.59 STC51072 IEF234E K 0B0C,P09079,PVT,DB2PMSTR,DB2PMSTR 15.51.59 STC51072 IKJ56893I FILE SYS00188 NOT UNALLOCATED+ 15.51.59 STC51072 IGD17101I DATA SET DB2P.ARCHLOG2.A0003034 671 671 NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG 671 RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH 15.51.59 STC51072 DSNJ228I -DB2P DSNJDS01 LOG DEALLOCATION ERROR 672 672 DSNAME=DB2P.ARCHLOG2.A0003034, ERROR STATUS=9714, SMS REASON 672 CODE=42CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=001D99C2C000, 673 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 673 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY2VOL=P09079, VOLSPAN=00, 673 CATLG=YES 15.51.59 STC51072 DSNJ138I -DB2P DSNJOFF1 OFFLOAD COMPLETE FOR LOG 674 674 TRUNCATION FROM AN ARCHIVE LOG COMMAND, ENDRBA=001DA12F2FFF 15.51.59 STC51072 DSNJ139I -DB2P LOG OFFLOAD TASK ENDED After the command completed DB2P.ARCHLOG2.A0003034 and DB2P.ARCHLOG2.B0003034 were on the same virtual volume (P09079), but only DB2P.ARCHLOG2.A0003034 was cataloged. Can this be solved using DB2? Can this be solved using SMS? This is running on z/OS v2.3 and DB2 v11 Thanks Gadi -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Writing DB2 Archlog to tape
Gadi, I'm not sure where to look because somebody else set it up here, but what you're trying to do is definitely doable - because that's how it is set up here. Second copy of archlogs go to a tape and "filea" is label 1 on the tape and "fileb" is label 2, both cataloged. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi Sent: Wednesday, July 10, 2019 1:59 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Writing DB2 Archlog to tape Hi, I was asked by our DB2 DBA to direct one of the DB2 ARCHLOGS to tape - Virtual tape on a TS7760. I changed our SMS STORCLAS routine to direct the correct files to the TAPE Storage class. That DATACLAS routine was also changed to associate the correct DATACLAS to the file. I tested using ISMF and saw that the changes did what I wanted. When we told DB2 to create a new ARCHLOG we saw that one of the ARCHLOGs is created ok and cataloged, and the other one is not cataloged. Further investigation showed that both files were created on the same virtual tape. These are the messages we saw in DB2: 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 658 658 DSNAME=DB2P.LOGCOPY1.DS06, STARTRBA=001D99C2C000, 658 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=001D99C2C000, 660 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ311I -DB2P DSNJC005 ASYNCHRONOUS LOG ARCHIVE 662 662 (OFFLOAD) TASK INITIATED 15.51.52 STC51072 DSN9022I -DB2P DSNJC001 '-ARCHIVE LOG' NORMAL COMPLETION 15.51.53 STC51072 CTT100A M 0B0C,PRIVAT,SL,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034, 664 664 OR RESPOND TO IEF455D MESSAGE 15.51.56 STC51072 IEC705I TAPE ON 0B0C,P09079,SL,COMP,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034,MEDIA2 15.51.56 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=1, COMPLETE VOLUME LIST, 666 666 DSN=DB2P.ARCHLOG2.B0003034,VOLS=P09079,TOTALBLOCKS=130 15.51.58 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 667 667 DSNAME=DB2P.ARCHLOG1.A0003034, STARTRBA=001D99C2C000, 667 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 667 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY1VOL=DB2BB3, VOLSPAN=00, 667 CATLG=YES 15.51.58 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=2, COMPLETE VOLUME LIST, 668 668 DSN=DB2P.ARCHLOG2.A0003034,VOLS=P09079,TOTALBLOCKS=5068 15.51.59 STC51072 IEF234E K 0B0C,P09079,PVT,DB2PMSTR,DB2PMSTR 15.51.59 STC51072 IKJ56893I FILE SYS00188 NOT UNALLOCATED+ 15.51.59 STC51072 IGD17101I DATA SET DB2P.ARCHLOG2.A0003034 671 671 NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG 671 RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH 15.51.59 STC51072 DSNJ228I -DB2P DSNJDS01 LOG DEALLOCATION ERROR 672 672 DSNAME=DB2P.ARCHLOG2.A0003034, ERROR STATUS=9714, SMS REASON 672 CODE=42CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=001D99C2C000, 673 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 673 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY2VOL=P09079, VOLSPAN=00, 673 CATLG=YES 15.51.59 STC51072 DSNJ138I -DB2P DSNJOFF1 OFFLOAD COMPLETE FOR LOG 674 674 TRUNCATION FROM AN ARCHIVE LOG COMMAND, ENDRBA=001DA12F2FFF 15.51.59 STC51072 DSNJ139I -DB2P LOG OFFLOAD TASK ENDED After the command completed DB2P.ARCHLOG2.A0003034 and DB2P.ARCHLOG2.B0003034 were on the same virtual volume (P09079), but only DB2P.ARCHLOG2.A0003034 was cataloged. Can this be solved using DB2? Can this be solved using SMS? This is running on z/OS v2.3 and DB2 v11 Thanks Gadi -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff /
Re: Writing DB2 Archlog to tape
As far as I know, it was changed. Gadi -Original Message- From: IBM Mainframe Discussion List On Behalf Of Bill Bishop (TMNA) Sent: Wednesday, July 10, 2019 4:09 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Writing DB2 Archlog to tape Does DSNZPARM for the DB2 system need to be changed to reflect the unit type and other information? Thanks Bill Bishop Consultant, Mainframe Engineer Mainframe and Scheduling | Infrastructure Technology Services Toyota Motor North America bill.bis...@toyota.com Office: (469) 292-5149 Cell: (502) 316-4386 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi Sent: Wednesday, July 10, 2019 1:59 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Writing DB2 Archlog to tape Hi, I was asked by our DB2 DBA to direct one of the DB2 ARCHLOGS to tape - Virtual tape on a TS7760. I changed our SMS STORCLAS routine to direct the correct files to the TAPE Storage class. That DATACLAS routine was also changed to associate the correct DATACLAS to the file. I tested using ISMF and saw that the changes did what I wanted. When we told DB2 to create a new ARCHLOG we saw that one of the ARCHLOGs is created ok and cataloged, and the other one is not cataloged. Further investigation showed that both files were created on the same virtual tape. These are the messages we saw in DB2: 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 658 658 DSNAME=DB2P.LOGCOPY1.DS06, STARTRBA=001D99C2C000, 658 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=001D99C2C000, 660 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ311I -DB2P DSNJC005 ASYNCHRONOUS LOG ARCHIVE 662 662 (OFFLOAD) TASK INITIATED 15.51.52 STC51072 DSN9022I -DB2P DSNJC001 '-ARCHIVE LOG' NORMAL COMPLETION 15.51.53 STC51072 CTT100A M 0B0C,PRIVAT,SL,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034, 664 664 OR RESPOND TO IEF455D MESSAGE 15.51.56 STC51072 IEC705I TAPE ON 0B0C,P09079,SL,COMP,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034,MEDIA2 15.51.56 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=1, COMPLETE VOLUME LIST, 666 666 DSN=DB2P.ARCHLOG2.B0003034,VOLS=P09079,TOTALBLOCKS=130 15.51.58 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 667 667 DSNAME=DB2P.ARCHLOG1.A0003034, STARTRBA=001D99C2C000, 667 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 667 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY1VOL=DB2BB3, VOLSPAN=00, 667 CATLG=YES 15.51.58 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=2, COMPLETE VOLUME LIST, 668 668 DSN=DB2P.ARCHLOG2.A0003034,VOLS=P09079,TOTALBLOCKS=5068 15.51.59 STC51072 IEF234E K 0B0C,P09079,PVT,DB2PMSTR,DB2PMSTR 15.51.59 STC51072 IKJ56893I FILE SYS00188 NOT UNALLOCATED+ 15.51.59 STC51072 IGD17101I DATA SET DB2P.ARCHLOG2.A0003034 671 671 NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG 671 RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH 15.51.59 STC51072 DSNJ228I -DB2P DSNJDS01 LOG DEALLOCATION ERROR 672 672 DSNAME=DB2P.ARCHLOG2.A0003034, ERROR STATUS=9714, SMS REASON 672 CODE=42CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=001D99C2C000, 673 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 673 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY2VOL=P09079, VOLSPAN=00, 673 CATLG=YES 15.51.59 STC51072 DSNJ138I -DB2P DSNJOFF1 OFFLOAD COMPLETE FOR LOG 674 674 TRUNCATION FROM AN ARCHIVE LOG COMMAND, ENDRBA=001DA12F2FFF 15.51.59 STC51072 DSNJ139I -DB2P LOG OFFLOAD TASK ENDED After the command completed DB2P.ARCHLOG2.A0003034 and DB2P.ARCHLOG2.B0003034 were on the same virtual volume (P09079), but only DB2P.ARCHLOG2.A0003034 was cataloged. Can this be solved using DB2? Can this be solved using SMS? This is running on z/OS v2.3 and DB2 v11 Thanks Gadi -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Writing DB2 Archlog to tape
Does DSNZPARM for the DB2 system need to be changed to reflect the unit type and other information? Thanks Bill Bishop Consultant, Mainframe Engineer Mainframe and Scheduling | Infrastructure Technology Services Toyota Motor North America bill.bis...@toyota.com Office: (469) 292-5149 Cell: (502) 316-4386 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi Sent: Wednesday, July 10, 2019 1:59 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Writing DB2 Archlog to tape Hi, I was asked by our DB2 DBA to direct one of the DB2 ARCHLOGS to tape - Virtual tape on a TS7760. I changed our SMS STORCLAS routine to direct the correct files to the TAPE Storage class. That DATACLAS routine was also changed to associate the correct DATACLAS to the file. I tested using ISMF and saw that the changes did what I wanted. When we told DB2 to create a new ARCHLOG we saw that one of the ARCHLOGs is created ok and cataloged, and the other one is not cataloged. Further investigation showed that both files were created on the same virtual tape. These are the messages we saw in DB2: 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 658 658 DSNAME=DB2P.LOGCOPY1.DS06, STARTRBA=001D99C2C000, 658 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=001D99C2C000, 660 ENDRBA=001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=001DA12F3000,ENDRBA=001DD1862FFF 15.51.52 STC51072 DSNJ311I -DB2P DSNJC005 ASYNCHRONOUS LOG ARCHIVE 662 662 (OFFLOAD) TASK INITIATED 15.51.52 STC51072 DSN9022I -DB2P DSNJC001 '-ARCHIVE LOG' NORMAL COMPLETION 15.51.53 STC51072 CTT100A M 0B0C,PRIVAT,SL,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034, 664 664 OR RESPOND TO IEF455D MESSAGE 15.51.56 STC51072 IEC705I TAPE ON 0B0C,P09079,SL,COMP,DB2PMSTR,DB2PMSTR,DB2P.ARCHLOG2.B0003034,MEDIA2 15.51.56 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=1, COMPLETE VOLUME LIST, 666 666 DSN=DB2P.ARCHLOG2.B0003034,VOLS=P09079,TOTALBLOCKS=130 15.51.58 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 667 667 DSNAME=DB2P.ARCHLOG1.A0003034, STARTRBA=001D99C2C000, 667 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 667 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY1VOL=DB2BB3, VOLSPAN=00, 667 CATLG=YES 15.51.58 STC51072 IEC205I SYS00188,DB2PMSTR,DB2PMSTR,FILESEQ=2, COMPLETE VOLUME LIST, 668 668 DSN=DB2P.ARCHLOG2.A0003034,VOLS=P09079,TOTALBLOCKS=5068 15.51.59 STC51072 IEF234E K 0B0C,P09079,PVT,DB2PMSTR,DB2PMSTR 15.51.59 STC51072 IKJ56893I FILE SYS00188 NOT UNALLOCATED+ 15.51.59 STC51072 IGD17101I DATA SET DB2P.ARCHLOG2.A0003034 671 671 NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG 671 RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH 15.51.59 STC51072 DSNJ228I -DB2P DSNJDS01 LOG DEALLOCATION ERROR 672 672 DSNAME=DB2P.ARCHLOG2.A0003034, ERROR STATUS=9714, SMS REASON 672 CODE=42CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=001D99C2C000, 673 ENDRBA=001DA12F2FFF, STARTTIME=00D6641E7BCEDF00, 673 ENDTIME=00D664F4F153B400, UNIT=WORK, COPY2VOL=P09079, VOLSPAN=00, 673 CATLG=YES 15.51.59 STC51072 DSNJ138I -DB2P DSNJOFF1 OFFLOAD COMPLETE FOR LOG 674 674 TRUNCATION FROM AN ARCHIVE LOG COMMAND, ENDRBA=001DA12F2FFF 15.51.59 STC51072 DSNJ139I -DB2P LOG OFFLOAD TASK ENDED After the command completed DB2P.ARCHLOG2.A0003034 and DB2P.ARCHLOG2.B0003034 were on the same virtual volume (P09079), but only DB2P.ARCHLOG2.A0003034 was cataloged. Can this be solved using DB2? Can this be solved using SMS? This is running on z/OS v2.3 and DB2 v11 Thanks Gadi -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
