As far as I know, it was changed.
Gadi

-----Original Message-----
From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> 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=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

----------------------------------------------------------------------
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

Reply via email to