Writing DB2 Archlog to tape

Discussion:

(too old to reply)

Gadi Ben-Avi

2019-07-10 06:59:07 UTC

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 ***@listserv.ua.edu with the message: INFO IBM-MAIN

Bill Bishop , TMNA

2019-07-10 13:09:14 UTC

Permalink

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
***@toyota.com
Office: (469) 292-5149
Cell: (502) 316-4386

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi
Sent: Wednesday, July 10, 2019 1:59 AM
To: IBM-***@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=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 ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

Gadi Ben-Avi

2019-07-10 13:16:18 UTC

Permalink

As far as I know, it was changed.
Gadi

-----Original Message-----
From: IBM Mainframe Discussion List <IBM-***@LISTSERV.UA.EDU> On Behalf Of Bill Bishop (TMNA)
Sent: Wednesday, July 10, 2019 4:09 PM
To: IBM-***@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 ***@toyota.com
Office: (469) 292-5149
Cell: (502) 316-4386

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi
Sent: Wednesday, July 10, 2019 1:59 AM
To: IBM-***@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=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 ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

Pommier, Rex

2019-07-10 13:26:10 UTC

Permalink

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-***@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi
Sent: Wednesday, July 10, 2019 1:59 AM
To: IBM-***@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=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 ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

Neubert, Kevin

2019-07-10 20:58:25 UTC

Permalink

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-***@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi
Sent: Tuesday, July 9, 2019 11:59 PM
To: IBM-***@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 ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

Gadi Ben-Avi

2019-07-11 04:15:18 UTC

Permalink

No,
Unit=work is not correct
Gadi

-----Original Message-----
From: IBM Mainframe Discussion List <IBM-***@LISTSERV.UA.EDU> On Behalf Of Neubert, Kevin
Sent: Wednesday, July 10, 2019 11:58 PM
To: IBM-***@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-***@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi
Sent: Tuesday, July 9, 2019 11:59 PM
To: IBM-***@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 ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

Neubert, Kevin

2019-07-11 14:34:51 UTC

Permalink

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-***@LISTSERV.UA.EDU] on behalf of Gadi Ben-Avi [***@MALAM.COM]
Sent: Wednesday, July 10, 2019 9:15 PM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: Writing DB2 Archlog to tape

No,
Unit=work is not correct
Gadi

-----Original Message-----
From: IBM Mainframe Discussion List <IBM-***@LISTSERV.UA.EDU> On Behalf Of Neubert, Kevin
Sent: Wednesday, July 10, 2019 11:58 PM
To: IBM-***@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-***@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi
Sent: Tuesday, July 9, 2019 11:59 PM
To: IBM-***@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 ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

Neubert, Kevin

2019-07-11 14:44:50 UTC

Permalink

My apologies, the macro is DSN6ARVP. CSQ is MQ.

Regards,

Kevin
________________________________________
From: IBM Mainframe Discussion List [IBM-***@LISTSERV.UA.EDU] on behalf of Neubert, Kevin
Sent: Thursday, July 11, 2019 7:34 AM
To: IBM-***@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-***@LISTSERV.UA.EDU] on behalf of Gadi Ben-Avi [***@MALAM.COM]
Sent: Wednesday, July 10, 2019 9:15 PM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: Writing DB2 Archlog to tape

No,
Unit=work is not correct
Gadi

-----Original Message-----
From: IBM Mainframe Discussion List <IBM-***@LISTSERV.UA.EDU> On Behalf Of Neubert, Kevin
Sent: Wednesday, July 10, 2019 11:58 PM
To: IBM-***@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-***@LISTSERV.UA.EDU] On Behalf Of Gadi Ben-Avi
Sent: Tuesday, July 9, 2019 11:59 PM
To: IBM-***@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 ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN

Ron Hesketh

2019-07-12 02:08:12 UTC

Permalink

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-***@LISTSERV.UA.EDU> On Behalf Of Gadi Ben-Avi
Sent: Wednesday, 10 July 2019 2:59 PM
To: IBM-***@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 ***@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 ***@listserv.ua.edu with the message: INFO IBM-MAIN