If you go to CBTTAPE.ORG and go for FILE206, it seems to have a REXX parser for DCOLLECT records
/* TOTAL FROM D, M AND B RECORDS: */ /* L0+ML1+ML2 DSN COUNT */ /* TOTAL L0 + ML1 +ML2 ALLOCATED */ /* TOTAL BACKUP KBYTES */ /* L0 DSN COUNT */ /* L0 ALLOCATED KBYTES */ /* L0 USED KBYTES */ /* SMS DSN COUNT */ /* SMS ALLOCATED KBYTES */ /* ML1 DSN COUNT */ /* ML1 ALLOCATED KBYTES */ /* ML1 ORIGINAL KBYTES */ /* ML2 DSN COUNT */ /* ML2 ALLOCATED KBYTES */ /* ML2 ORIGINAL KBYTES */ /* This may do what you want. It takes a DCOLLECT input file and creates a report. I have not tried it yet, but this maybe helpful. Lizette -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Lizette Koehler Sent: Saturday, July 20, 2013 1:15 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - I ran this process and received data in the DATASET.REPORT file. But it was only for ONLINE dasd. This is expected. Your messages indicate the process ran. Most likely no data to format. Please run a FULL DCOLLECT for all record types then try this process again. Remember my comment: ACBQBAR7 does not get MIGRATED data. Only ONLINE data. It only parses D records not M records. To test this I have a full DCOLLECT dataset. Has all of the Migrated, Capd, vols, etc. when it was run. I run the ACBQBAR7 against that file and only ONLINE datasets were in the list. If it was migrated or tape it was not in the list. Does that help? Lizette -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of esmie moo Sent: Saturday, July 20, 2013 11:03 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - Lisa, Just to let you know that I was able to get the dsn list with the job (examples in the z/OS V1R12.0 DFSMSdfp Storage Administration SC26-7402-14 pages 382 &383) however for some reason it does not list any of the MIGRATED dsns. I tried another test just to select MIGRATEDATA there are no dsns listed. David spotted my error but I couldn't find it where it is. Hopefully he will see this post and let me know where it is. ________________________________ From: Lizette Koehler <stars...@mindspring.com> To: IBM-MAIN@LISTSERV.UA.EDU Sent: Saturday, July 20, 2013 10:38:12 AM Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - According to the Naviquest manual: ACBQBAR7 is called by SYS1.SACBCNTL member ACBJBARD to generate a flat file from DCOLLECT data taken from data set records and lists the fields of your choice, in the order you specify. Does not appear to handle Migrated data. So, you could run a plain dcollect as I described, or review the Naviquest manual (you can find them on the IBM.COM website) http://www.redbooks.ibm.com/abstracts/sg244720.html http://publib.boulder.ibm.com/infocenter/zos/v1r11/index.jsp?topic=/com.ibm. zos.r11.idas200/naviquest.htm Lizette -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of esmie moo Sent: Saturday, July 20, 2013 6:33 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - Lizette, Here is what I had said earlier (see below). I cannot figure out why the output dsn SYS2.DATASET.REPORT does not show is that dsn list but only system stats. David Devine said that "The problem is that you want to get a report on M type (migration) dcollect records and the job deck you are running will only select D type dataset records." I cannot seem to find where the M type records are being selected in the job deck. This is where my problem is. Next I ran the following job (I took this from the IBM manual z/OS V1R12.0 DFSMSdfp Storage Administration SC26-7402-14) : //GENREP EXEC ACBJBAOB, // PLIB1=SYS1.DGTPLIB, // TABL2=SYS2.TEST.ISPTABL //DCOLIN DD DSN=SYS2.DCOLLECT.DATA1,DISP=SHR //ISPFILE DD DSN=SYS2.DATASET.REPORT,DISP=OLD //SYSTSIN DD * PROFILE PREFIX(ZWA6PWG) ISPSTART CMD(ACBQBAR7) + BATSCRW(132) BATSCRD(27) BREDIMAX(3) BDISPMAX(99999999) //SYSIN DD * DSN VOLSER ALLOCSP RECFM TITLE=DATA SET REPORT FROM DCOLLECT DATA - 17/07/2013 TOTALS BLKSIZE DSORG MGMTCLAS STORGRP /* However, when I check the output dsn SYS2.DATASET.REPORT this is what I find and I cannot understand why. READY PROFILE PREFIX(ZWA6PWG) READY ISPSTART CMD(ACBQBAR7) BATSCRW(132) BATSCRD(27) BREDIMAX(3) BDISPMAX(99999999) Number 1 parameter was: DSN Number 2 parameter was: VOLSER Number 3 parameter was: ALLOCSP Number 4 parameter was: RECFM Number 5 parameter was: TITLE Number 6 parameter was: TOTALS Number 7 parameter was: BLKSIZE Number 8 parameter was: DSORG Number 9 parameter was: MGMTCLAS Number 10 parameter was: STORGRP Time *** ISPF transaction log *** Us Userid: ZWA6PWG Date: 13/07/19 Page: 1 08:41 Start of ISPF Log - - - - Session # 1 --------------------------- 08:41 TSO - Command - - ACBQBAR7 08:54 End of ISPF Log - - - - - Session # 1 ------------- ________________________________ From: Lizette Koehler <stars...@mindspring.com> To: IBM-MAIN@LISTSERV.UA.EDU Sent: Friday, July 19, 2013 1:25:08 PM Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - Then I would run DCOLLECT with all the parms (MIGD, CAPD VOL(*) etc...) and then check SYSPRINT and see what records are being produced. There is a summary at the end of the message indicating how many of each record is found. For example IDC01811I NUMBER OF 'D ' RECORDS PROCESSED WAS 442789 IDC01811I NUMBER OF 'A ' RECORDS PROCESSED WAS 378331 IDC01811I NUMBER OF 'V ' RECORDS PROCESSED WAS 1333 IDC01811I NUMBER OF 'M ' RECORDS PROCESSED WAS 38429 IDC01811I NUMBER OF 'B ' RECORDS PROCESSED WAS 61141 IDC01811I NUMBER OF 'C ' RECORDS PROCESSED WAS 3405 IDC01811I NUMBER OF 'T ' RECORDS PROCESSED WAS 3 It helps us that you try things and provide details back. Each shop is unique and we need to see the details in order to help. Lizette -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of esmie moo Sent: Friday, July 19, 2013 10:03 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - Lizette, I was limiting to using MIGRATEDATA just to ensure that DCOLLECT was working correctly. We are running z/OS 1.13. I cannot use the ISMF Option G because some of the RMM modules have not been installed. (confirmed by the MVS group). I am using SAS to parse the output once the records from the DCOLLECT has been created. ________________________________ From: Lizette Koehler <stars...@mindspring.com> To: IBM-MAIN@LISTSERV.UA.EDU Sent: Friday, July 19, 2013 12:40:47 PM Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - Try checking out this link. It describes the DCOLLECT function http://publib.boulder.ibm.com/infocenter/zos/v1r11/index.jsp?topic=/com.ibm. zos.r11.idai200/dcoll.htm What version of z/OS do you run? Do you use SAS, SAS/MXG, SAS/MICS, Tivoli or other analysis tools? ICETOOL? Perhaps you could use the ISMF Option G (report tool)? I am not sure why you are trying to limit to just migration data. I typically pull ALL DCOLLECT records and then use SAS/MXG to filter and summarize the data. MIGRATEDATA creates data records for all migrated data sets that reside on this system. BACKUPDATA creates data records for all backed up data sets on this system. Maybe try a simpler control card process //COLLECT3 JOB ... //STEP1 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=A //MCDS DD DSN=HSM.MCDS,DISP=SHR //BCDS DD DSN=HSM.BCDS,DISP=SHR //SYSIN DD * DCOLLECT - OUTDATASET(USER.DCOLLECT.OUTPUT) - MIGRATEDATA - VOL(*) Lizette -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of esmie moo Sent: Friday, July 19, 2013 9:07 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - Dave, Thanks for the info. However I cannot find where I am selecting the D type records. Could you point it out? Thanks ________________________________ From: David Devine <david.dev...@sse.com> To: IBM-MAIN@LISTSERV.UA.EDU Sent: Friday, July 19, 2013 11:56:05 AM Subject: Re: DCOLLECT QUESTION -RESULTS PUZZLING - Hi Esmee, You've answered your own question. The problem is that you want to get a report on M type (migration) dcollect records and the job deck you are running will only select D type dataset records. If you are running the DFSMS RMM tape management system, it actually includes a dfsort/icetool report deck to strip out dcollect migrated data. >From tso ispf panel for RMM, select 1 User, then R report, then just hit enter to create a list of reports and the one you want is ARCGDM01 DCOLLECT MIGRATION DATA etc. If you don't have RMM you can use the DFSMS access methods services for Z/os manual appendix F to get a breakdown of M type records and their relative positions and lengths and build your own rexx or sort. There are probably examples on this forum you can use. Good luck! Dave ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN