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 <IBM-MAIN@LISTSERV.UA.EDU> 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=00000000001D99C2C000, 658 ENDRBA=00000000001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 1 ACTIVE LOG 659 659 DATA SET IS DSNAME=DB2P.LOGCOPY1.DS07, 659 STARTRBA=00000000001DA12F3000,ENDRBA=00000000001DD1862FFF 15.51.52 STC51072 DSNJ002I -DB2P FULL ACTIVE LOG DATA SET 660 660 DSNAME=DB2P.LOGCOPY2.DS06, STARTRBA=00000000001D99C2C000, 660 ENDRBA=00000000001DA12F2FFF 15.51.52 STC51072 DSNJ001I -DB2P DSNJW307 CURRENT COPY 2 ACTIVE LOG 661 661 DATA SET IS DSNAME=DB2P.LOGCOPY2.DS07, 661 STARTRBA=00000000001DA12F3000,ENDRBA=00000000001DD1862FFF 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=00000000001D99C2C000, 667 ENDRBA=00000000001DA12F2FFF, STARTTIME=00D6641E7BCEDF000000, 667 ENDTIME=00D664F4F153B4000000, 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=97100004, SMS REASON 672 CODE=000042CD 15.51.59 STC51072 DSNJ003I -DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 673 673 DSNAME=DB2P.ARCHLOG2.A0003034, STARTRBA=00000000001D99C2C000, 673 ENDRBA=00000000001DA12F2FFF, STARTTIME=00D6641E7BCEDF000000, 673 ENDTIME=00D664F4F153B4000000, 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=00000000001DA12F2FFF 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 ______________________________________________________________________ _______________________________________________________________________________ This email has been scanned by the Bankwest Email Security System. _______________________________________________________________________________ _______________________________________________________________________________ Unencrypted electronic mail is not secure and may not be authentic. If you have any doubts as to the contents please telephone to confirm. This electronic transmission including any attachments is intended only for those to whom it is addressed. It may contain copyright material or information that is confidential, privileged or exempt from disclosure by law. Any claim to privilege is not waived or lost by reason of mistaken transmission of this information. If you are not the intended recipient you must not distribute or copy this transmission and should please notify the sender. Your costs for doing this will be reimbursed by the sender. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. _______________________________________________________________________________ ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN