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
