Using FDREPORT for Tape Migration with FATSCOPY
Contents
1. FINAL TOTALS TVUSEBYT 991977 606M Media Type Media Tvpe VALUE SUMMARY OF TVMEDRFM TOTAL NUMBER l Undefined TVMEDREM b Cartridge Svstem Tape Been EAETC Enterprise ANSeS Economy Tape EFMT4 p v Tap TOSTRACK EE 256TRACK EATC nen ES Tape Cartridge 36TRACK 78 VALUE SUMMARY OF TVMEDTYP TOTAL NUMBER EAWTC ETE Advanced WORM Tape TVMEDTYP Cartridge JY EATC ECCST Enhanced Capacity Cartridge System INC Sil Tape i EREC EETC Enterprise Economy Tape Cartridge EXE JI HPET EEWTC Enterprise Economv WORM Tape Cartridge JR EHPCT Extended High Performance Cartridge Tape K Enterprise Tape Cartridge JA Enterprise WORM Tape Cartridge JW EXTC Enterprise Extended Tape Cartridge JB See section 2 4 on page 9 for a sample checklist Ta E O O Ten of FDREPORT jobs you can run to help you plan for a High Performance Cartridge Tape successful migration PLANNING FOR THE MIGRATION 2 2 FDREPORT support of DFSMSrmm tape management system FDREPORT 5 4L78 or higher is able to extract information from IBM s DFSMSrmm product and process it just as it does for DASD related information This information can be formatted filtered sorted and summarized using FDREPORT s existing facilities DFSMSrmm Tape Volume Fields DFSMSrmm Tape Data Set Fields The DFSMSrmm fields related to tape volumes The DFSMSrmm fields related to tape data sets include include e Basic information2. FATSCOPY amp FDREPORT Using FDREPORT for Tape Migration with FATSCOPY lt Using FDREPORT For TAPE MIGRATION WITH FATSCOPY FDREPORT LICENSE FDREPORT is a separately licensed product from Innovation but is available to FATSCOPY customers at no charge for 90 days Audience This document is written to be used by either a customer directly by consultants VAR s or the manufacturers Using FDREPORT For TAPE MIGRATION WITH FATSCOPY Contents Part 1 1 1 1 2 Part 2 2 1 2 2 2 3 2 4 Part 3 3 1 3 2 3 3 3 4 3 5 3 6 3 7 3 8 3 9 3 10 3 11 3 12 3 13 3 14 3 15 Part 4 4 1 4 2 4 3 4 4 4 5 4 6 Introduction AE E O AA 5 Whati FDOREPORT venerar recorrer aser RENESTE das 5 Planning for the Migration What Do We Need to Know Before We Start the Migration T FDREPORT support of DFSMSrmm tape management systeM 8 FDREPORT support of CA 1 tape management SysteM o oooo 8 Tape Migration Checklist 2 0 0 0 0 ccc ee ee eee eens 9 Run the Reports Produce Extract FIG u 4 fin oe Owe REESE RARAS 11 Tape Library Inventory na nn annaa aaa nennen 12 Tape Library Inventory Excluding Tapes in INIT and SCRATCH Status 13 Tapes Excluded from Migration eee 14 Tapes Eligible for Migration 00 15 Tapes Requiring Image COpy o o oooor eee ee ee 16 ALIEHNE TODES aa san anna
3. SYSIN DD XEXCLUDE TVSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 XSELECT TVDSNCNT 1 TVNXTVOL TVPRVVOL TITLE LINE SINGLE VOLUME SINGLE FILE EXTRACT FILE lt TVXTDATE gt SORT FIELD TVVOLSER REPORT FIELD TVFIDSN TVVOLSER TVDSNCNT SUMMARY FITELD TVVOLSER PRINT DATATYPE RMMVOL DISABLE SUMVALUES BYTE FORMAT MEGABYTES JE FTP member name Single_Volume_Single_File_Tapes txt Sample Output SINGLE VOLUME SINGLE FILE EXTRACT FILE 2013 326 FIRST FILE DATASET VOLSER DSCOUNT A00155 STREAM NORMAL RRX7AEBF A00155 STREAM NORMAL VCDORFH3 Lo OO LS KO Qal SS e 2200 1 557 ASE OS AOS A03 OAM OAM OAM AO3 FINAL TOTALS A00155 STREAM STREAM STREAM STREAM STREAM STREAM PRIMARY DATA PRIMARY DATA PRIMARY DATA A04345 RSDGRL6 C102059 T0413141 E2099365 TVVOLSER DIOTE DTC TR DARSE DTO TE DISTR IDAS as YANOT6R7 NOW RS YJVHDCAX YESW7UMB EOW MIC YESW80ED 144060 151002 1a T005 5 2005 151008 ESO IL SLO Ie 5037206 SoSe SO dl SAr2 ILS PRR PEPRRRRARRA 2 RUN THE REPORTS 3 15 Create FATSCOPY JOB amp Control Statements with FDREPORT All of the previous examples have shown FDREPORT being used to produce reports that would be useful during both the planning and execution phases of a tape migration project with FATSCOPY In that context the FATSCOPY jobs would be created manually based on information provided in the various report
4. 6 7 CREATE EXTRACT FILE FOR FDREPORT CA 1 REPORTING 1 2 3 4 4 4 5 4 6 7 EXTRACT EXEC PGM FDREPORT SYSIN DD DEFAULT SORTALLOC YES CAITMC CA1 TMC EXTRACT PRODUCT CA1 STORCLAS TSTDATA DSN extract data set name DISP RETAIN 1 FTP Member Name Create CA1 Extract File txt Sample Output FDRABR VIOC REPORT CREATE PRINT FDREPORT VER 5 4 80P INNOVATION DATA PROCESSING CART IMAGE DEFAULT STORCLAS YES CALTMC CA1 TMC CARD IMAGE EXTRACT PRODUCT CA1 STORCLAS TSTDATA DSN extract data set name CARD IMAGE BSP REM RMM EXTRACT PUNTOS TARA AS ILL gt FMM EPGHSKP Extract Elapsed Time 40 38 Seconds DSN extract data set name EMM EXTRACT FUNCTION ENDED 1952232 FDREPORT 5 4 80P PROCESSING COMPLETED RUN THE REPORTS 3 2 Tape Library Inventory This first example report produces an inventory of our entire tape library We ve used TVXTDATE and TVXTTIME to include in the title the date and time that the extract file we re reporting against was created The report is sorted in tape volser order Other information displayed in this report includes the retention and expiration dates of the tape the current location of the tape and the amount of data contained on the tape This consolidated list of tape volumes provides an ideal point in time record of all the tape volumes currently held within the tape library As you can see from the 1 line summa
5. FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN oo Excludes INIT and SCRATCH tapes XEXCLUDE TVSTATUS 1 XEXCLUDE TVEXDAYS fet Excludes lapes bitak will expire within 90 days TITLE LINE TAPES WI SORT FIELD TVEXDAYS REPORT FIELD TVVOLSER TVEXDAYS TVEXDATE TVRTVALU TVUSEBYT SUMMARY FIELD TVVOLSER TVUSEBYT PRINT DATATYPE RMMVOL DISABLE SUMVALUES BYTEFORMAT MEGABYTES FTP member name Tapes Eligible for Migration txt Sample Output VOLUME USAGE OF TAPES WITH RETPD gt 90 EXTRACT FILE 2013 326 VOLSER EXDAY EXP DAL RETENTYALU VOLUSEBY TES 502556 20227 302634 0003 Sl 503100 65535 Da DOS Tas 300 lee alle 0 10275589 SS A 6 AS gt 0 210976559 306 1002 50 05555 ISO je DA MUS IO 75859 53066 8720 50 10 9555 2225 O AE Oe FINAL TOTALS TVVOLSER RUN THE REPORTS 3 6 Tapes Requiring Image Copy In some situations there may be tapes that require migration but are externally managed such as OAM and 3 party applications These tapes require special handling and would require a FATSCOPY image copy rather than a file by file copy See the FATSCOPY user documentation for a full description of the image copy process In our example report we have included several XSELECT statements to identify OAM data sets that we know will require special handling In the 1 line summary you will see that we have 1 178 tape volumes containing one or more such data se
6. amp NOT SCRATCH FINAL TOTALS TDAPRSIZ 59 704T TDVOLSER FDR400 FDRABR REPORT STANDARD SUMMARIES FDREPORT VER 5 4 80 INNOVATION DATA PROCESSING RMM REPORT APPROX SIZE OF ALL DATA SETS NOT EXPIRED amp NOT SCRATCH FINAL TOTALS TDAPRSIZ 102 286T TDVOLSER EXAMPLES AND ADDITIONAL RESOURCES 4 3 Sample FDREPORT Summary Reports Using Grouping Here we show a simple FDREPORT example of GROUPING on the VOLUME STATUS MASTER SCRATCH etc Grouping can be used with many other fields such as expiration date creating program job last reference date and more With groupings you can get an overview of the groups MASTER SCRATCH etc by looking at the subtotals per group and the final totals LIST ALL TAPES GROUPED PER VOLUME STATUS SCRATCH EXTRACT FILE 2013 329 VOLSER VOLSTAT EXPDAT LRDATE LOCATION 100029 SCRATCH 2009 190 AWAATLI 100060 SCRATCH 2011 274 AWAATLI 104610 SCRATCH AWAATLI SUBTOTAL TVSTATUS SCRATCH TVVOLSER 94 LIST ALL TAPES GROUPED PER VOLUME STATUS MASTER EXTRACT FILE 2013 329 VOLSER VOLSTAT EXPDAT LRDATE LOCATION 100048 MASTER 2010 062 2010 057 AWAATLI 100049 MASTER 2007 310 2013 239 AWAATLI 100050 MASTER 2009 295 2009 290 DISTANT SUBTOTAL TVSTATUS MASTER 4518 FINAL TOTALS TVVOLSER Total for both SCRATCH and MASTER VOLUME USAGE REPORT EXTRACT FILE 2013 326 VOLSER VOLUSEBYTES SFU 200002 3 200003 Oe Sl 0 2000027 770
7. e g volume serial volume e Basic information e g data set name owner label media type density volume serial blocksize e Location information e g home current old e Historical information e g when was the required type data set created and by what job step and e Status information e g retention expiration program when and by what job step and values date last accessed date last written program was the data set read or written last drive used volume capacity error counts Size information e g block counts e Access information e g last changing Operating system information e g is the data user owner owner access authority volume set cataloged is it SMS managed access authority Management information DFSMSrmm s Vital Record constructs 2 3 FDREPORT support of CA 1 tape management system FDREPORT 5 4L80 or higher is able to extract information from CA Technologies CA 1 product and process it just as it does for DASD related information This information can be formatted filtered sorted and summarized using FDREPORT s existing facilities CA 1 Tape Volume Fields e CA 1 Tape Data Set Fields The CA 1 fields related to tape volumes include l Aichi 1 fields related to tape data sets e Basic information e g volume serial volume label recording technique density e Location information e g out of area date and code e Status information e g retention expiration values date la
8. just change the SORT statement to FIELD TV FULL And if you add TV FULL to the list of SUMMARY fields you ll get a summary percentage full value across all selected reported tapes to give an idea of how much on average each of your eligible tapes are being used JCL and Control Statements 1 2 4 3 4 4 4 5 4 6 7 TAPE VOLUME USAGE REPORT 4 4 4 4 4 4 4 4 4 4 4 4 4 7 FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD XEXCLUDE TVSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 XSELECT TVVOLSER TITLE LINE VOLUME USAGE REPORT EXTRACT FILE lt TVXTDATE gt SORT FIELD TVVOLSER REPORT FIELD TVVOLSER TVUSEBYT TVSFULL SUMMARY FIELD TVVOLSER TVUSEBYT PRINT DATATYPE RMMVOL DISABLE SUMVALUES BYTEFORMAT MEGABYTES TITLE LEFT FTP member name Volume_Usage_Report txt Tapes with status INIT and SCRATCH and tapes to be excluded in our example tapes that will expire in 90 days are excluded from the list Sample Output VOLUME USAGE REPORT EXTRACT FILE 2013 326 VOLSER VOLUSEBYTES FU 200002 200003 200002 ANOS 200007 ZA MONON AL ANOS 2001077 200021 200072 200024 200025 23002 AD MS Zoe ert A 25o OS Loy FINAL TOTALS TVVOLSER RUN THE REPORTS 3 10 Inventory of All Tapes Grouped by Location If all the tapes that will be involved in the
9. 4 3 4 4 4 5 4 6 7 DEFAULT NAME ABR ARCHIVE FDRABR V B DEFAULT NAME HSM MIGRATE HSM HMIGTAPE CONTROL CARDS SET FOR REPORTING ON ABR ARCHIVE TAPES TO GET HSM MIGRATED TAPES SWITCH THE XSELECT AND TITLE STATEMENTS 1 4 2 4 3 4 4 4 5 6 7 FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name STSIN DD XEXCLUDE TDSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 XSELECT TDDSNAME FDRABR V B XSELECT TDDSNAME HSM HMIGTAPE TITLE LINE TAPES WITH ABR ARCHIVED DATA EXTRACT DATE lt TDXTDATE gt TITLE LINE TAPES WITH HSM MIGRATED DATA EXTRACT DATE lt TDXTDATE gt REPORT FTELD TDVOLSER TDDSNAME TDEXDATE TDAPRSIZ SORT FTELD TDVOLSER TDDSNAME BREAK SSP NO SUMMARY FIELD TDVOLSER TDDSNAME TDAPRSIZ PRINT DATATYPE RMMDSN DISABLE SUMVALUES BYTEFORMAT MEGABYTES FTP member name Archive_Tapes txt RUN THE REPORTS Sample Outputs XSELECT TDDSNAME FDRABR V B TAPES WITH ABR ARCHIVED DATA EXTRACT DATE 2014 035 VOLSER DATA SET NAME ADA B BROX SITZE BA0124 FDRABR VIDPBKO B197338A BA0124 FDRABR VIDPBKO B198008A BAUT247EDRABR VIDPBRO B198008B oM BA0124 FDRABR VTSOWK1 B297338A 4 096M SUBTOTAL TDVOLSER BA0124 TDVOLSER TDDSNAME 21 TDAPRSIZ 355683 328K 003213 FDRABR VTSOWK1 B198071A 200135 124 149 419M 003212 PDRABR VTSOWF I Br9S07TA AOS 124 MISS Mi SUB
10. Download directory then Tech Support Samples then e FDREPORT Tape Migration with FATSCOPY Examples for examples in this document e FDREPORT FATSCOPV Examples for additional FDREPORT FATSCOPY examples e FATSCOPY Examples Feb2014 forthe Feb 2014 Newsletter examples FRANCE 191 avenue Aristide Briand 94230 Cachan Tel 33 1 49 69 94 02 Fax 33 1 49 69 90 98 frsales fdrinnovation com INNOVATION DATA PROCESSING Corporate Headquarters Innovation Plaza 2 5 Paterson Avenue Little Falls New Jersey 07424 1658 Tel 973 890 7300 Fax 973 890 7147 support fdrinnovation com wwwWw fdr com European Offices GERMANY Orleansstra e 4a 81669 M nchen Tel 49 089 489 0210 Fax 49 089 489 1355 desales fdrinnovation com frsupport fdrinnovation com desupport fdrinnovation com NETHERLANDS 8 Nordic Countries Brouwerstraat 8 1315 BP Almere Tel 31 036 534 1660 Fax 31 036 533 7308 nisales fdrinnovation com nisupport fdrinnovation com sales fdrinnovation com UNITED KINGDOM Clarendon House 125 Shenley Road Borehamwood Herts WD6 1AG Tel 44 0208 905 1266 Fax 44 0208 905 1428 uksales fdrinnovation com uksupport fdrinnovation com Using FDREPORT for Tape Migration with FATSCOPY
11. Volume Multi File Tapes While there may be many tapes in the library with a single and very large data set spanning multiple tape volumes see previous example there may also be a number of tapes in the library that contain lots of small data sets and which are not part of a multi volume tape set This next report shows us all of our tape volumes that are self contained single volume not part of a multi volume set and which contain more than one tape data set multi file The selection drivers for this report are once again TVNXTVOL and TVPRVVOL which we used in the last report but this time we are checking to make sure that both values are empty and TVDSNCNT is checked to see that the data set count on the volume is greater than 1 The sample output shows us the tape volser the number of data sets on the tape and the name of the first data set contained on that tape In our sample we have 4 316 single volume multi file tapes in our library JCL and Control Statements I 1 2 3 4 4 5 6 7 SINGLE VOLUME AND MULTIPLE FILES 7 FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD XEXCLUDE TVSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 XSELECT TVDSNCNT gt 1 TVNXTVOL TVPRVVOL TITLE LINE SINGLE VOLUME MULTIPLE FILES EXTRACT
12. migration are stored in the same place then the migration process will be straight forward If however the tapes are stored in different locations either on site or off site then the locations of these tapes will need to be taken into account when planning out the practicalities of the physical handling of the tapes during the migration process We saw the LOCATION field TVLOCAT included as an informative column in examples 3 2 3 3 and 3 4 but in this next report we are focusing on the location as a key value and we are grouping the selected eligible tapes by their location As you can see from the sample outputs we re using the BREAK option on the SORT statement to create a separate summary list and a summary of the eligible tapes at each location JCL and Control Statements E i ES E T A GR Sa INVENTORY OF ALL TAPES GROUPED BY LOCATION ff SSS SS ee a ee eee ee FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD XEXCLUDE TVSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 TITLE LINE ALL TAPES GROUPED BY LOCATION lt TVLOCAT gt EXTRACT FILE lt TVXTDATE gt SORT FTELD TVLOCAT TVVOLSER BREAK SEJ NO REPORT FIELD TVVOLSER TVLOCAT TVSTATUS SUMMARY FIELD TVVOLSER PRINT DATATYPE RMMVOL DISABLE SUMVALUES TITLE LEFT SORTALLOC CYL SORTCORE 8000000 FTP member name Tapes_Grouped_by_Location txt This is an inventory of the tapes grouped by location
13. with totals by location Sample Output ALL TAPES GROUPED BY LOCATION DOSS EXTRACT FILE 2013 326 alrededor ee ae ALL TAPES GROUPED BY LOCATION DUMP EXTRACT FILE 2013 326 250023 DOSS MASTER 250036 DOSS MASTER VOLSER LOCATION VOLSTAT SUBTOTAL TVLOCAT Doss 200116 DUMP MASTER TVVOLSER 13 200234 DUMP MASTER SUBTOTAL TVLOCAT DUMP TVVOLSER 95 ALL TAPES GROUPED BY LOCATION MART EXTRACT FILE 2013 326 VOLSER LOCATION VOLSTAT 200378 MART ee ee ns SUBTOTAL TVLOCAT SHELF SUBTOTAL TVLOCAT MART TVVOLSER 52580 A FINAL TOTALS TVVOLSER 2 RUN THE REPORTS 3 11 Last Reference Report When planning out the migration another useful factor to keep in mind is the regularity with which each target migration tape has been used It might be desirable for example to separate out the most recently used tapes from those that are used less frequently and handle the migration of the two sets of tapes separately As an example it might be prudent to migrate the often used tapes out of prime working hours to avoid possible contention with the jobs wishing to use those tapes but migrate the infrequently used tapes during the working day as there is less likelihood that they will be needed while the migration job is executing There may be other client specific reasons why migrating the tapes in an order dependent on their usage pattern may be required It may even b
14. 2170 50M zz 79 ZU USE ZEV 2 2000 07 Ie SIM 0 ZONAL 0 000M 1 ANON 7 22052 M Sl 200017 20815 544M 7 200021 5612 85 o il 200022 6952 00 26 200024 0 000M 3 P0025 seca re 253102 7 082M 1 253188 0 029M 0 a Di oa iz Dis B18 5 197 869M 8 FINAL TOTALS TVVOLSER 5203 TVUSEBYT 38548 80 046G Kai Ke t 10 ele 173 A ate 8 Total Volumes TAPES WITH PERMANENT ERRORS EXTRACT FILE 2013 326 VOLS EIR LWRDAT LRDATE PERMRDERR PERMWTERR AOS 2 0220 204 20107239 2012 25 EL 0 Diada 201450720 10825272010 271 IONS 0 0 0 0210720205 22 20102212 AO r 7 il 20270 See section 4 6 on page 33 on how to access these sample FDREPORT jobs A EXAMPLES AND ADDITIONAL RESOURCES 44 Additional FATSCOPY Resources February 2014 FYI Newsletter focusing on FATS FATAR FATSCOPY FATS FATAR FATSCOPY User Manual FATSCOPY How To Build A Job Guide FATSCOPY Quick Start Guide FATSCOPY Concepts 4 Facilities Guide FATSCOPY Product Demo 4 5 Additional FDREPORT Resources FDREPORT User Manual FDREPORT Concepts amp Facilities Guide 4 6 How to Access Jobstreams and Output The jobstreams and output for examples shown in this guide as well as additional FATSCOPY FDREPORT examples are available from the INNOVATION DATA PROCESSING FTP site e Go to www fdr com e Click on FTP login and Enter your access code if you don t have one you can request one on this webpage e Click on the
15. CA 1 RMM REPORT LIST OF VOLUMES DATA SETS NOT EXPIRED IN VOLSER ORDER VOLSER DATA SET NAME EXE DATE DAA UER TAE As A ds IAS IZ 200154 A03 A04345 RSDGRO7 C109244 T023014 E2014338 2014 345 12619 874M 12619 612M 643825 664K 200159 203 204345 RSDBER07 C109244 70230715 E20143538 2014 345 12619 874M_ 12619 612MmM 13631 488K 200161 ANICO1 SMF ESA JAN12 2014 032 25410 199M_ 23409 45 9M 5249 171M RMM REPORT VOLUMES NOT IN SCRATCH STATUS VOLSER VOLSTAT CRDATE EXPDAT RTDATE RETENTVALU DSCOUNT PREVOL NXTVOL OWNER AAA Sie MAME 200800 80009657002 MIRO IMA TERT 200 700660 Loo 6570 FOLOL OO MSI 20022 227 AOS 20147022 297 03 7457 17 00094722040 FOR CA1 LIST OF VOLUMES DATA SETS NOT EXPIRED amp NOT EDM IN VOLSER ORDER VOLSER VOLSTAT NDSNB SFU CRDATE CRDAY EXPDATZEXDAY CA I ZDENSTEY 800034 OU 207033 LIE 2002 20 a alae TODAS 90 ART TAPE 800041 TOO AI BIO IS Ys WO Score So 00 16 Neo 800044 Ir 201 22 2 88 Ma ZG 102 87253590 CART TARE FDR400 FDRABR REPORT STANDARD SUMMARIES FDREPORT VER 5 4 80 INNOVATION DATA PROCESSING RMM REPORT TOTAL VOLUMES NOT IN SCRATCH STATUS FINAL TOTALS TVVOLSER FDR400 FDRABR REPORT STANDARD SUMMARIES FDREPORT VER 5 4 80 INNOVATION DATA PROCESSING RMM REPORT TOTAL VOLUMES IN SCRATCH STATUS FPFLINAL TOTALS TVVOLSER FDR400 FDRABR REPORT STANDARD SUMMARIES FDREPORT VER 5 4 80 INNOVATION DATA PROCESSING RMM REPORT APPROX SIZE OF ALL EXPIRED DATA SETS
16. D MORE THAN 430 DAYS AGO EXTRACT FILE lt TVXTDATE gt REPORT FIELD TVVOLSER TVLRDATE TVCRDATE TVRTVALU TVEXDATE TVF1DSN SORT FTELD TVLRDATE TVVOLSER SUMMARY FIELD TVVOLSER TVUSEBYT PRINT DATATYPE RMMVOL DISABLE SUMVALUES FTP member name Last_Reference_Report txt RUN THE REPORTS Simple changes can be made in the example above using Creation Date or Last Reference Date Use any number of days that suits your needs You can also use EXCLUDE or SELECT as you might want to exclude or select tapes that are in another location or tapes created by certain jobs e XSELECT KEXCLUDE TVHOMLOC location e XSELECT KEXCLUDE TVCRJOB jobname Sample Output TAPE VOLUMES LAST REFERENCED MORE THAN 430 DAYS AGO EXTRACT FILE 2013 326 VOLSER SOOO SO OLE 20 0220 gt 01 815 Sii 301640 202289 200 Il L 0 201130 2049 474764 474766 474768 474791 LRDATE Lon 7996 236 115 16 336 FINAL TOTALS TVVOLSER CRDATE 074 000 000 000 000 RETENTVALU WHILECATLG WHILECATLG WHILECATLG WHILECATLG WHILECATLG WHILECATLG WHILECATLG WHILECATLG WHILECATLG POSADA 97 Sl 341 oda 2330 FIRST FILE DATASET DOS DOS D06 A03 A03 A06 A03 A03 A03 A03 A03 A03 74220 TVUSEBYT 67734 916G A04077 A04050 A04726 A04050 A04077 A04234 A04077 A04077 A04077 AAO242 AAO242 AAO242 A04540 ADEA Hw Meee OAS SOR LO U CAVE INE RESATRT LCJD601M EQ
17. FILE lt TVXTDATE gt SORT FTELD TVVOLSER REPORT FIELD TVFIDSN TVVOLSER TVDSNCNT SUMMARY FIELD TVVOLSER PRINT DATATYPE RMMVOL DISABLE SUMVALUES BYTEFORMAT MEGABYTES FTP member name Single Volume Multi File Tapes txt Sample Output SINGLE VOLUME MULTIPLE FILES EXTRACT FILE 2013 326 FIRST FILE DATASET VOLSER DSCOUNT AMOS DIS AP DE ASIT AERIS C TCTONEVOL bed eye AOC So bits ose RIAS UNS Ws CIO NE Volk Iza 2001 DS AP BIASSO MANS CLONEVOL ek 206 HAA G JIDDO P TO OTe TDD e272 Ez OW UZ 0107 50001 6 80 CID OUND IS DD es GS Ok Ue 01011 025600 SO l 9901 O HAA E DIO 722 AO DOZ 107 14157000 520 0117 504 5 97 CNS JIDDONME C OJI RION M2648 SOI 9725 SROs CSIRO O AS Das 00016007 SOI ais CUINA 716 7015 52006 M292A DOI SS EBD IS DDO Gal l 1 TOOU TM AA SOT 6 0 FINAL TOTALS TVVOLSER RUN THE REPORTS 3 14 Single Volume Single File Tapes As a continuation to the previous report we are now looking for all self contained tapes in the library that contain only 1 data set single volume single file tapes The report is identical to the previous one except that we now have TVDSNCNT set to equal 1 In our sample output we have 144 060 tapes in our library that currently each contain just a single data set JCL and Control Statements yt Hr ae Zee pS A ee szene SINGLE VOLUME AND SINGLE FILE een ee en a FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name
18. INAL TOTALS TVVOLSER 200287 TVUSEBYT 161990 466G RUN THE REPORTS 3 4 Tapes Excluded from Migration In most client shops there will be various categories of tapes that will be excluded from or handled separately from the main migration process This next example report can be used to provide a list of the tapes that you may wish to exclude from the migration project The variables within this example report can be adjusted to meet your own specific criteria In the supplied example TVEXDAYS lt 90 is used to identify tapes that have 90 or less days to their expiry as these tapes can be allowed to expire naturally and may not need to be migrated In our summary report we have identified 28 481 tapes that will expire within the next 90 days There may of course be other site specific criteria that determines that a tape would be excluded from your migration and these tapes can be included in the migration exclusion report by adding additional XEXCLUDE orXSELECT statements as required JCL and Control Statements 4 1 2 4 3 4 4 4 5 4 6 7 LIST TAPES THAT WILL EXPIRE WITHIN 90 DAYS 4 44 444444447 FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN E Excludes INIT and SCRATCH tapes XEXCLUDE TVSTATUS INIT RA H XSELECT TVEXDAYS lt 90 IKaallel apiji A jeteta tal UA ILU KO Sol IKA idee late INES TIT
19. LE LINE LIST TAPES HA N i a mer AY EXTRACT FILE lt TVXTDATE gt SORT FIELD TVEXDAYS REPORT FIELD TVVOLSER TVOWNER TVRIVALU TVEXDATE TVLOCAT TVUSEBYT SUMMARY FIELD TVVOLSER TVUSEBYT PRINT DATATYPE RMMVOL DISABLE SUMVALUES BYTEFORMAT MEGABYTES FTP member name Tapes Excluded From Migration txt Sample Output LIST TAPES THAT WILL EXPIRE WITHIN 90 DAYS EXTRACT FILE 2013 326 TAPES PER STATUS VOLSER OWNER RETENTVALU EXPDAT LOCATION VOLUSEBYTES Veto ee SCRATCH 424494 AD9I62 A SHE LE 472525229162 A SA EIRE 5 4255398 ADJME E SHE LE x FINAL TOTALS Pe TVVOLSER 358986 CK2U02 P SEIE 3620391 CKZ2UOQ1 z SHELF A TAPES PER LOCATION 62 10 EU i SHELF SUBTOTAL es FINAL TOTALS TVVOLSER gt TVUSEBYT 16391 711G PINAL TOTAL gt TVVOLSER Getting Summary Information VOLUME USAGE REPORT a 4518 TVUSEBYT 128609 105G All the example reports we ve looked at so far include the REFERENCED gt 430 DAYS AGO detailed information for each tape that matches the selection or FINAL TOTALS 2 O 0033 TYUSEBYT 13581 056G exclusion criteria If you need to run a report that only reflects the number of tapes and other summary information rather than the specific details of each tape simply add the RPTYPE NONE option to the PRINT statement If you want a report that contains the detail and summary information but you want the summary information separate from the main report add an ABRSUM DD to SYSOUT to
20. TOTAL TDVOLSER 003213 EDVOESER TDDSNAME 257 TDAPRSIZ 13318 666M FINAL TOTALS TDVOLSER 21675 TDAPRSIZ 570176 670M XSELECT TDDSNAME HSM HMIGTAPE TAPES WITH HSM MIGRATED DATA EXTRACT DATE 2013 326 VOLSER DATA SET NAME EXPDAT APPROXSIZE 2302 04 HMIGTAPE DATASET ZONAL Z10 HMIGTAPE DATASET 2o TL96 HMIGTAPE DATASET A BS oI HMIGTAPE DATASET gt 03 499787 HMIGTAPE DATASET 265 499814 HMIGTAPE DATASET AGS FINAL TOTALS TDVOLSER RUN THE REPORTS 3 8 Tapes with Permanent Errors In order for the tape migration to run smoothly it is a good idea to identify ahead of time any tapes that might present a problem when they are read as part of the migration process Ideally you would like to remove these tapes from the main migration process and deal with them separately so that they don t interrupt the smooth running of the main migration process This next example report uses field TVPRDERR to select tapes that have had more than 10 permanent read errors recorded against them by the tape management system Using the TVPRDERR value you can tailor the report to set the lower limit of read errors that you want a tape to exceed before being included in the report In the sample report we are showing the tape volume and the number of permanent read errors We ve also added other useful information such as when the tape was last written to and when it was last read from plus the unit address of the t
21. UAL SOS UI ODIA WES TRES RARO ID ESAS TORN LO ECJCOOZ P BACKAMITGO422 0100 TARREMSEMORCONVASAMVE ler COS ZO CED 60 O0VOO EOS EU PROD YED CO7 TVOU TKE ne OOP BACrALE G01412000 TAT EKEMBEE TATO ECR CO 32108 TAL BRKEMNER TATER IS COICO VOO TAT BKPMTA TAIBHOT 60103 00 FEE ZOD VAN 1 2777200 RUN THE REPORTS 3 12 Identify Tapes that are Part of Multi Volume Sets One of the key areas often requiring special note or attention during a tape media migration project is the handling of multi volume sets i e tape data sets that span more than one tape volume Generally if one of the tape volumes in the set is migrated to new media it is advisable to migrate all of the other volumes at the same time or as soon after as possible This next example report uses a simple selection test on the existence of either a previous tape volume TVPRVVOL or a next tape volume TVNXTVOL Ifeither of the values is non blank this indicates that the volume is part of a multi volume tape set and that a data set contained on this volume is also on either the previous volume and or the next volume in the sequence The sample report is sorted in tape volume order and shows the sequence number of that tape volume together with the volsers of the previous and next tapes in the sequence The number of data sets on each volume is also shown In the first section of our sample output we can see the existence of a very large data set that sp
22. ans at least 118 tape volumes 5 of which are displayed in the abridged report We can see that the NXTVOL for tape 498681 VSQ 4 is 498686 and this tallies with the PREVOL for 498686 VSQ 5 The 1 line summary at the end of our sample report shows that we have 51 911 tapes in the current library that are not self contained and are part of a multi volume set JCL and Control Statements 1 2 4 3 4 4 4 5 4 6 7 TAPES THAT ARE PART OF MULTI VOLUME SETS 4 44 444444447 FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD XEXCLUDE TVSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 LE TVNXTVOL NE OR TVPRVVOL NE THEN SELECT TITLE LINE TAPES IN MULTI VOLUME SETS EXTRACT FILE lt TVXTDATE gt SORT FIELD TVVOLSER REPORT FIELD TVVOLSER TVVOLSEQ TVDSNCNT TVPRVVOL TVNXTVOL SUMMARY FIELD TVVOLSER TVDSNCNT PRINT DATATYPE RMMVOL DISABLE SUMVALUES FTP member name Tapes_in_Multivolume_Sets txt Sample Output TAPES THAT ARE PART OF MULTI VOLUME SET EXTRACT FILE 2013 326 VOLSER VSO DSCOUNT PREVOL NXTVOL ASAS yA Oo Sirs 10960 AS 4 498681 498682 498684 498686 303002 SUs0Gs 503064 202 002 510 SAS 498443 498444 498616 498681 ISO 019 50 SL 2 498686 4198689 498734 498688 02055 203061 ols IB FINAL TOTALS TVVOLSER RUN THE REPORTS 3 13 Single
23. ape device onto where this tape was last mounted JCL and Control Statements 1 2 3 4 5 6 7 FDREPORT RUN AGAINST EXTRACTED FILE SELECTING ALL THE TAPES WITH PERMANENT READ ERRORS 1 2 3 4 5 6 7 REPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD XEXCLUDE TVSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 TITLE LINE TAPES WITH PERMANENT READ ERRORS EXTRACT FILE lt TVXTDATE gt IF TVPRDERR gt 10 THEN SELECT REPORT FIELDS TVLRUN4B TVVOLSER TVIWDATE TVLRDATE TVPRDERR SORT FIELD TVPWTERR SEQUENCE D PRINT DATATYPE RMMVOL PAGEWIDTH 52 FTP member name Tapes_with_Permanent_Read_Errors txt Any value can be used for the read error limit Sample Output TAPES WITH PERMANENT READ ERRORS EXTRACT FILE 2013 326 VOLSER LWRDAT LRDATE PERMRDERR 710 16 4 200202 AMA SO 202082 2072720 RUN THE REPORTS 3 9 Volume Usage Report This next simple report repeats the list of all eligible tapes i e excluding the soon to expire and SCRATCH and INIT tapes we identified in examples 3 3 and 3 4 and it uses TVUSEBYT and TV FULL to show us the amount of data and the percentage full status of each of those eligible tapes Our sample report is sorted by tape volser but if you would prefer to see the report sorted by the full figures FU
24. ate a permanent extract file FDREPORT can create a tape management extract file in a few minutes FDREPORT supports more field names selection criteria than FATSCOPY and is also able to create the SELECT statements for the FATSCOPY job This makes FDREPORT FATSCOPY a very powerful combination PLANNING FOR THE MIGRATION 2 1 What Do We Need to Know Before We Start the Migration e How many tapes are involved e 500 25 000 75 000 e How many files e 100 000 300 000 700 000 1 million e How much data is on the tapes e Where are the tapes located e How much of the data is still active e How much of the data has expired e How many volumes and data sets will expire shortly and will not need to be migrated to the new tape library e Do you have tapes managed by proprietary products like CA View that maintain information about the tapes in an external database e What is the total capacity and type of tape For example Media Recording Format AE T Undefined EEFMT2 Enterprise Encrypted Format 2 MDREFORM EEFMT3 Enterprise Encrypted Format 3 B E a E AS EEFMT4 Enterprise Encrypted Format 4 D00002 861M 36TRACK ECCST EFIMl Enterprise Format 1 D00146 l ON 82 0 OLM ORA r Bere SPRIT 2 D00147 1 0 308 M 838 861M 36TRACK ECCST a a Sample Output DFSMSRMIM ASIA UI 2013 345 AT 09 M30806 128TRACK HPCT ST0006 19 13258 621M 39996 883M 256TRACK HPCT 900008 22 HPCT
25. ation in lower case with values appropriate for your shop MASK DD DATA DLM TL PREFIX jobname JOB jobcard lt MOD FATSCOPY EXEC PGM FATSCOPY REGION 0M STEPLIB DD DISP SHR DSN fatscopy load library lt MOD AUDIT DD DISP NEW CATLG UNIT SYSALLDA SPACE TRK 5 5 7 DSN my auditdsn D lt RUNDATE gt T lt RUNTIME gt S lt SSCNT6 gt lt MOD DSNTABLE DD DISP NEW CATLG UNIT SYSALLDA SPACE TRK 5 5 ard DSN my restart D lt RUNDATE gt T lt RUNTIME gt S lt SSCNT6 gt lt MOD ERRORRPT DD SYSOUT SYSABEND DD SYSOUT TAPEOUT DD DSN DUMMY1 DISP NEW KEEP UNIT yourunit lt MOD SYSIN DD SIM ENDPREFIX DUPCHECK SELECT ALLDSN VOL lt VOL gt ENDUPCHECK SUFFIX iii FTP member name Create FATSCOPV Job with FDREPORT This page intentionally left blank EXAMPLES AND ADDITIONAL RESOURCES FDREPORT is a planning tool that can be used with DFSMSrmm or CA 1 to query the tape management database using a broad range of powerful selection parameters FDREPORT is available to FATSCOPY customers at no charge for 90 days FDREPORT generates reports on the tape environment that you can use to determine which volumes you need to copy The examples in this section are excerpts from the February 2014 FYI Newsletter Please review the newsletter for descriptions and more information regarding these reports 4 1 Sample FDREPORT Volume Usage Reports for RMM and
26. e decided that tapes that haven t been used for a specific period of time may not require migration at all In our example we are interested in tapes that have not been referenced in the past 430 days We ve sorted the report by ascending Last Reference Date TVLRDATE so that the tapes that have not been referenced for the longest period of time appear first in the list We have included TVF1DSN to show the name of the first data set on the tape this will give us an idea of what sort of data might be contained on the tape and we have also included the creation date TVCRDATE so that we can see when the tape was first created As you can see from our sample report many of the tapes at the beginning of our list appear to have been created some time ago and were only referenced on that same day or a few days after but have not been referenced again since Depending on the number of tapes in our case it s 74 220 that haven t been used for at least 430 days a decision may be made to handle the migration of these tapes separately from the main migration project JCL and Control Statements y Sp SSA SS Y SS SO Y SS SS Y SS O A SR ee LIST TAPES LAST REFERENCED MORE THAN 430 DAYS AGO ff Baa Se Sa SS l a a FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD XEXCLUDE TVSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 XSELECT TVLRDAYS gt 430 PITTE LINE TAPE VOLUMES LAST REFERENCE
27. ifv archive tapes created bv products l such as ABR and HSM Identify tapes with read errors so they can be processed separately sa Determine the total number of bytes Tapes Requiring Image Copvetxt Archive Tapes txt Tapes with Permanent Read Errors txt Volume Usage Report txt DE 3 8 of each tape in the tape library to be migrated Inventory of off site tapes 3 10 Tapes_Grouped_by_Location txt y A l NO ON JI Oo Last_Reference_Report txt Identify tapes with highest lowest priority in migration process This may be tapes ie a used by a specific application or heavily used tapes Identify multi volume tape sets Tapes_in_Multivolume_Sets txt i 12 a i u l 1 en nu egies Wel E E TG 13 Single Volume Multi File Tapes txt multiple files Identifv tapes that are single volume Single Volume Single File Tapes 14 0 14 single file txt 15 0 Example of FDREPORT punching out 15 Create FATSCOPY Job with control cards for FATSCOPY gt FDREPORT txt U pa jemmal pl 3 2 3 3 10 RUN THE REPORTS 3 1 Produce Extract File In our first example we are going to create an extract file that will provide us with a point in time reference source for our initial pre migration and during migration reporting The use of this extract file speeds up the reporting process as the detailed data can be extracted from the tape management system once only and then subsequent
28. k from the tape management extract file The resulting data is sorted into volume serial number sequence and used in conjunction with the SELPCH mask below to create a FATSCOPY job stream to copy all the datasets on the selected volumes to another media Note that the generated job is by default placed on the DD name SYSPUNCH which is directed to SYSOUT Once you are satisfied with the resulting job please change the SYSPUNCH DD statement SYSOUT B INTRDR It is also suggested that you add TYPRUN HOLD to the job card so you will have an additional opportunity to review the generated job prior to execution 1 4 2 3 4 4 4 5 4 6 7 RMMXTR DD DSN extract data set name DISP SHR L MOD The SYSIN DD contains the FDREPORT selection and reporting statements In this example we are selecting all the data sets that match a specific DSN mask JAT and that reside on volumes with VOLSERs that match either of two masks CCR or ABC will create UCL and control statements each of which contains 1 SELECT ALLDSN statement SYSIN DD REPORT FIELD TDDSNAME TDVOLSER PUNCH FDRLIB MASK ECHO SORT FIELD TDVOLSER XSELECT TDDSNAME JAT EE TDVOLSER CCR ABC lt MOD PRINT DATATYPE RMMDSN RPTYPE SELPCH The MASK DD contains the skeleton of the FATSCOPY job that will be built by FDREPORT Replace the inform
29. nen cs crepas caera ae i hd 17 Tapes with Permanent Errors 2 22 22 cm ooo 19 Volume Usage Report 22222 n onen anne eee es 20 Inventory of All Tapes Grouped by Location seen 21 Last Reference Report nanana 22 Identify Tapes that are Part of Multi Volume Sets o o ooooooooooooo 24 Single Volume Multi File Tapes 00 25 Single Volume Single File Tapes 2 0 eee 26 Create FATSCOPY JOB amp Control Statements with FDREPORT 27 Examples and Additional Resources Sample FDREPORT Volume Usage Reports for RMM and CA1 31 Sample FDREPORT Summary Reports 0 eee 31 Sample FDREPORT Summary Reports Using Grouping o 32 Additional FATSCOPY Resources 33 Additional FDREPORT Resources eee 33 How to Access Jobstreams and Output nanna anana ee es 33 INTRODUCTION 1 1 What is FATSCOPY FATSCOPY offers a high performance and automated process for moving and re cataloging tape based data sets Whether you re consolidating tape data to higher capacity tapes converting to new tape media or implementing or replacing a Virtual Tape System FATSCOPY is an ideal tool for the mass re location of data from one tape media to another FATSCOPY can copy individual files or the entire contents of one or more tape volumes either to a new tape or to a VTS FATSCOPY can select the data sets to be copied or migrated fr
30. om your system catalogs or from your tape management database You can specify the data sets by e data set name prefixes or masks such as JAT DATA e tape volume serial prefixes or ranges e catalog tape device type 3480 3490E or 3590 Additionally filtering can be done on the data sets to be copied based on tape management system information including e creation date e expiration date e creating job name and or step name e data set size FATSCOPY also supports an image copy of the tape volume including the volume label header labels and trailer labels 1 2 What is FDREPORT FDREPORT is a generalized report writer that can generate custom reports on DASD and TAPE related data Using simple control statements you can generate both simple and complex reports You can generate reports on a few data sets large numbers of data sets whole DASD volumes or your entire installation You can select data through the system catalogs or directly from DASD volumes or from IBM s DFSMSrmm and CA Technologies CA 1 tape management systems You can generate a data file for further reporting or pass the data to other programs for further analysis You can even punch JCL or control statements for other programs using the report data FDREPORT is a planning tool that can be used with DFSMSrmm or CA 1 tape management systems to query the tape management databases FDREPORT can run against the active DFSMSrmm or CA 1 database and or you can cre
31. rchive or migration policy using tools such as FDRABR or DFSMShsm to move infrequently used data from prime disk to a less expensive medium If that medium is tape the tape migration process may need to handle the tapes containing archived migrated data separately from other tapes in the library Both FDRABR and DFSMShsm use standard naming conventions for their archive migration data sets so it is very easy to run a report to identify those tape files In our example we are using an XSELECT statement to find all the tape volumes that contain one or more data sets starting with the standard identifier of FDRABR V B An additional XSELECT statement is provided in the example job for HSM HMIGTAPE simply switch the commenting asterisk if you wish to run the report to identify HSM migration tape files The sample report lists each tape volser that has been found to contain at least one ABR archive data set and the individual tape files contained on that tape are displayed We ve added a BREAK operand to the SORT statement so that we get a summary after each tape volume and a final summary at the end which shows that we have 55 tapes in total containing 21 675 ABR archive data sets The second sample report shows similar output for DFSMShsm data sets JCL and Control Statements 1 2 4 3 4 4 4 5 4 6 7 IDENTIFY TAPES WITH ABR OR HSM ARCHIVED MIGRATED DATA 1 2
32. reports can be run quicker and more efficiently against the extracted data Once the migration process has been completed another extract file can be created and the reporting process re run to ensure that all tapes involved in the migration process have been successfully moved to the new media This second extract file will help to identify any new tapes that may have been created after the first extract file was taken and during the migration These tapes can then be converted as required Refer to Section 54 16 FDREPORT EXTRACT Statement in the FDR documentation for information on creating the extract file JCL and Control Statements RMM 1 2 3 4 5 6 7 CREATE EXTRACT FILE FOR FDREPORT RMM REPORTING A A Al EXTRACT EXEC PGM FDREPORT F SXSIN DD EXTRACT PRODUCT RMM STORCLAS TSTDATA DSN extract data set name DISP RETAIN PR FTP Member Name Create RMM Extract File txt Sample Output FDRABR VTOC REPORT CREATE PRINT FDREPORT VER 5 4 80P INNOVATION DATA PROCESSING CARD IMAGE EXTRACT PRODUCT RMM STORCLAS TSTDATA DSN extract data set name CARD IMAGE DISP RETAIN RMM EXTRACT FUNG RON SS TARDE DE een gt RMM EDGHSKP Extract Elapsed Time 40 38 Seconds DSN extract data set name RMM EXTRACT EUNGCTTON ENDED 04 21 42 FDREPORT 5 4 80P PROCESSING COMPLETED JCL and Control Statements CA 1 1 2 3 4 4 5 4
33. ry at the end of the sample we have 261 698 tapes in the library currently holding 170Tb of data JCL and Control Statements a a O EA a a ee GENERATE REPORT ON ALL TAPE VOLUMES ff ee ee een FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD TITLE LINE REPORT ON ALL TAPE VOLUMES EXTRACT FILE lt TVXTDATE gt AT lt TVXTTIME gt SORT FIELD TVVOLSER REPORT FIELD TVVOLSER TVOWNER TVRTVALU TVEXDATE TVLOCAT TVUSEBXT SUMMARY FIELD TVVOLSER TVUSEBYT PRINT DATATYPE RMMVOL DISABLE SUMVALUES SORTALLOC CYL SORTCORE 8000000 FTP Member Name Tape Library Inventorv txt Sample Output REPORT ON ALL TAPE VOLUMES EXTRACT FILE 2013 326 AT 14 25 19 VOLSER OWNER RETENTVALU HAPDAT LOCATION VOLUSEBY LES ILO 0 eA 1197970 Teea Too Tonon 151000 SOVMEROS CMC 2933 202 SHELF IIS O EROS O ESA SHELF TOOT OVER C AOS DOSS LS IOS SOVIPIROC ZONES DOSS 806073 RUE DIE Sonor CRECE Oil ION SI ASS SUAASS Ido A AWS 263 EII sa FINAL TOTALS TVVOLSER 261698 TVUSEBYT 175322 512G RUN THE REPORTS 3 3 Tape Library Inventory Excluding Tapes in INIT and SCRATCH Status This report is a variation of example 3 2 in that it uses an XEXCLUDE statement and TVSTATUS field variable to exclude any tapes in INIT and SCRATCH status This report may prove to be more useful than example 3 2 since it provides a better idea of the number of tapes in the librar
34. s Our final example is an illustration of using FDREPORT to automatically create a FATSCOPY job that can be used as part of the actual migration process itself The example job is divided into two sections e RMMXTR this is the FDREPORT selection part of the process In our example we are selecting all tape volumes beginning with CCR or ABC which contain one or more data sets with a high level qualifier of JAT The resulting data is sorted into volume serial number sequence and used in conjunction with the FDREPORT SELPCH feature to create FATSCOPY job streams e MASK this is the template FATSCOPY JCL and control cards that will be used by SELPCH to create the FATSCOPY job Each separate step within the created job will contain an execution of FATSCOPY with a single SELECT ALLDSN VOL vvvvvv statement to copy the entire contents of the selected tape volume to the new media Note that the generated job is by default placed on the DD name SYSPUNCH which is directed to SYSOUT Once you are satisfied with the resulting job all you need to do is change the SYSPUNCH DD statement SYSOUT B INTRDR You should also consider adding TYPRUN HOLD to the job card so that you will have an additional opportunity to review the generated job prior to its execution JCL and Control Statements on next page RUN THE REPORTS JCL and Control Statements This is a sample job designed to select tape volumes by data set name mas
35. st accessed last drive used volume capacity error counts Basic information e g data set name volume serial blocksize e Historical information e g when was the data set created and by what job step and program when and by what job and program was the data set read or written e Size information e g block counts Operating system information e g is the data set cataloged is it SMS managed PLANNING FOR THE MIGRATION 2 4 Tape Migration Checklist Atape migration checklist similar to this should be created to ensure a successful migration is done Section 1 y Producing an extract file of your tape Create_RMM_Extract_File txt inventory using FDREPORT Create CA1 Extract File txt Tape librarv inventorv report of all tapes 3 Tape librarv inventorv report excluding tapes in INIT and SCRATCH status EJ 1 2 Tape Library_Inventory txt Tape Inventory Excluding INIT eN 3 3 and_SCRATCH txt U Report of tapes to be excluded from migration that are not in INIT and SCRATCH status This example excludes tapes that expire in the next NN days Inventory of all tapes to be migrated a This excludes the tapes identified in steps 3 and 4 This criteria is used for all 1 Tapes Excluded From Migration 4 txt re a Tapes Eligible for Migration txt subsequent jobs Identifv those tapes that require Image Copy such as OAM See user manual for restrictions 70 Ident
36. the report JCL RUN THE REPORTS 3 5 Tapes Eligible for Migration This example report is the opposite of example 3 4 in that we are now listing all the tapes that will be included in the migration process excluding the tapes that are not eligible Our report will list all the non INIT and non SCRATCH tapes that have an expiry date greater than 90 days As you can see from the 1 line summary our total of tapes to migrate has now decreased from 200 287 in example 3 3 to 171 819 The report is sorted in ascending Expiry Date EXDATE order so that the tapes in the report are listed in the order that they would eventually expire right through to the tapes with a 65535 expiry date Tapes that are to be retained for as long as they remain cataloged are displayed with a WHILECATLG in the RETENTVALU column The report also shows the amount of data on each tape and the 1 line summary shows that the amount of data to be migrated has decreased from 170Tb in our original inventory example 3 2 to 142Tb a 16 reduction JCL and Control Statements A aa a A O lo al a LIST TAPE VOLUME USAGE OF TAPES WITH RETPD gt 90 AND ARE NOT IN INIT OR SCRATCH STATUS YOU MAY WANT TO ADD OTHER SELECTION CRITERIA TO FURTHER LIMIT THE VOLUMES WHICH YOU WANT TO MIGRATE a a ee ISA G A A B a A e a a TVTRTVALU RETENTION VALUE f Mel CATRETPD El CYCL NNNNN l PERMANENT pi WHILECATLG T rar Dee A a a a ee Kae len ee
37. ts JCL and Control Statements 1 1 2 3 4 4 5 4 6 4 7 EXTERNAL MANAGED TAPES LIKE OAM AND 3RD PARTY APPLICATIONS 1 2 4 3 4 4 4 5 4 6 7 FDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD XEXCLUDE TDSTATUS INIT SCRATCH XEXCLUDE TVEXDAYS lt 90 XSELECT TDDSNAME OAM PRIMARY DATA OAM BACKUP DATA OAM BACKUP2 DATA TITLE LINE OAM TAPES REQUIRING IMAGE COPY EXTRACT FILE lt TDXTDATE gt REPORT FIELDS TDVOLSER TDCRJOB TDDSNAME TDEXDATE TDAPRSIZ SUMMARY FIELD TDVOLSER TDDSNAME TDAPRSIZ PRINT DATATYPE RMMDSN DISABLE SUMVALUES BYTEFORMAT MEGABYTES SORTALLOC CYL SORTCORE 8000000 x FTP member name Tapes_Requiring_Image_Copy txt Sample Output OAM TAPES REQUIRING IMAGE COPY EXTRACT FILE 2013 326 VOLSER CREATJOB DATA SET NAME EXPDAT APPROXSIZE 200005 200275 200243 200263 200253 200297 200497 50099 SOS LOC SO SO IL 303103 20104 SUSO OAM OAM OAM OAM OAM SEACKUES o BACKUP SBACRUES OAM BACKUE CAM BACKUP CAMP BACKUP Cf EACKUE QAM PRIMARY QAM PRIMARY QAM PRIMARY QAM PRIMARY QAM PRIMARY QAM PRIMARY FINAL TOTALS TDVOLSER ae oo 366 66 5966 590606 5766 1025358 Ze Ze ECO os ily Zee 9092 wA Soe RUN THE REPORTS 3 7 Archive Tapes Most mainframe shops operate an a
38. y that are currently in use and that need migrating you can see from our sample report that the number of tapes decreased to 200 287 from 261 698 in the original report JCL and Control Statements 1 1 2 3 4 4 5 6 7 TAPE LIBRARY INVENTORY EXCLUDING TAPES WITH STATUS INIT AND SCRATCH STATUS 4 4 4 4 4 4 4 4 4 4 4 4 7 EDREPORT EXEC PGM FDREPORT REGION 0M RMMXTR DD DISP SHR DSN extract data set name SYSIN DD XEXCLUDE TVSTATUS INIT SCRATCH TITLE LINE LIST TAPES EXCLUDE TAPES WITH STATUS INIT AND SCRATCH EXTRACT FILE lt TVXTDATE gt REPORT FIELD TVVOLSER TVOWNER TVRTVALU TVEXDATE TVLOCAT TVUSEBYT SORT FTELD TVVOLSER SUMMARY FIELD TVVOLSER PRINT DATATYPE RMMVOL DISABLE SUMVALUE SORTALLOC CYL SORTCORE 8000000 FTP member name Tape Inventory Excluding INIT and SCRATCH txt Sample Output LIST TAPES EXCLUDE TAPES WITH STATUS INIT AND SCRATCH EXTRACT FILE 2013 326 VOLSER RETENTVALU EXPDAT LOCATION VOLUSEBYTES 151309 SOVPROC 151310 SOVPROC CYCL 99999 151311 SOVPROC CYCL 99999 151312 SOVPROC CYCL 99999 151313 SOVPROC CYCL 99999 200002 CC3G40 i 200003 DSNMSTR E 3694 200004 CD9RO4 A 21041 200005 OAM 28800 200007 DSNMSTR 2013 341 3694 503119 CD9R90 2013 344 317348 503120 CD9R90 2013 345 317414 503121 OAM 1999 366 757510 912196 CD9RO4 2099 365 359737 F
Download Pdf Manuals
Related Search