Discussion:
DCOLLECT QUESTION
(too old to reply)
esmie moo
2013-07-17 15:58:35 UTC
Permalink
Good Morning Gentle Readers,
 
I am trying to compile a report for a HLQ using DCOLLECT.  I want to extract info only for SYS2.CICS.AS400 Can this be done?  I checked the doc : z/OS DFSMS Access Method Services for Catalogs SC26-7394-04 chapter 11 for an example but I found none.  Would anybody have  an example?
 
Thanks in advance.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Lizette Koehler
2013-07-17 16:24:17 UTC
Permalink
Could you provide more detail on what you are trying to do?

Do you have SAS/MXG or SAS/MICS or SAS? Do you use REXX?

I think you will need to run DCOLLECT and then parse the output with a tool
(ICETOOL for instance) to provide the listing you want. However, will ISMF
or 3.4 do what you need?

Lizette


-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On
Behalf Of esmie moo
Sent: Wednesday, July 17, 2013 8:58 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: DCOLLECT QUESTION

Good Morning Gentle Readers,
 
I am trying to compile a report for a HLQ using DCOLLECT.  I want to extract
info only for SYS2.CICS.AS400 Can this be done?  I checked the doc : z/OS
DFSMS Access Method Services for Catalogs SC26-7394-04 chapter 11 for an
example but I found none.  Would anybody have  an example?
 
Thanks in advance.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
esmie moo
2013-07-17 17:58:44 UTC
Permalink
Lizetee,
 
I am trying to run the job in BATCH using IDCAMS.  Below are the parms I am using.  I noticed that eventhough I am including MIGRATEDATA however when I check the output it does not show any of the migrated dsns.
 
 DCOLLECT +       
 OFILE(OUTDS) +   
 VOLUME(*) +      
 STORAGEGROUP(*) +
 SMSDATA(ACTIVE) +
 MIGRATEDATA +    
 CAPPLANDATA +    
 BACKUPDATA       


________________________________
From: Lizette Koehler <***@MINDSPRING.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Wednesday, July 17, 2013 12:24:14 PM
Subject: Re: DCOLLECT QUESTION


Could you provide more detail on what you are trying to do?

Do you have SAS/MXG or SAS/MICS or SAS?  Do you use REXX?

I think you will need to run DCOLLECT and then parse the output with a tool
(ICETOOL for instance) to provide the listing you want.  However, will ISMF
or 3.4 do what you need?

Lizette


-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On
Behalf Of esmie moo
Sent: Wednesday, July 17, 2013 8:58 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: DCOLLECT QUESTION

Good Morning Gentle Readers,
 
I am trying to compile a report for a HLQ using DCOLLECT.  I want to extract
info only for SYS2.CICS.AS400 Can this be done?  I checked the doc : z/OS
DFSMS Access Method Services for Catalogs SC26-7394-04 chapter 11 for an
example but I found none.  Would anybody have  an example?
 
Thanks in advance.

----------------------------------------------------------------------
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
Staller, Allan
2013-07-17 18:35:43 UTC
Permalink
Is the MCDS in your execution JCL?

<snip>
  I noticed that eventhough I am including MIGRATEDATA however when I check the output it does not show any of the migrated dsns.
 
 DCOLLECT +       
 OFILE(OUTDS) +   
 VOLUME(*) +      
 STORAGEGROUP(*) +
 SMSDATA(ACTIVE) +
 MIGRATEDATA +    
 CAPPLANDATA +    
 BACKUPDATA       

</snip>
________________________________

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
esmie moo
2013-07-18 10:58:02 UTC
Permalink
Yes.  It is.  Here is the jcl:
 
//GENDAT   EXEC PGM=IDCAMS,REGION=4M,TIME=1440        
//SYSPRINT DD SYSOUT=*                                
//MCDS     DD DSN=SYS2.HSM.MCDS,DISP=SHR                  
//BCDS     DD DSN=SYS2.HSM.BCDS,DISP=SHR                  
//OUTDS    DD DSN=HSM.DCOLLECT.DATA,               
//    RECFM=VB,LRECL=988,DSORG=PS,UNIT=SYSALLDA,      
//    SPACE=(1,(300,300),RLSE),AVGREC=M,              
//    DISP=(,CATLG,DELETE)                            
//SYSIN    DD *                                       
  DCOLLECT +                                          
  OFILE(OUTDS) +                                      
  VOLUME(*) +                                         
  STORAGEGROUP(*) +                                   
  SMSDATA(ACTIVE) +                                   
  MIGRATEDATA +                                       
  CAPPLANDATA +                                       
  BACKUPDATA                                          
/*                                                    


________________________________
From: "Staller, Allan" <***@KBMG.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Wednesday, July 17, 2013 2:35:34 PM
Subject: Re: DCOLLECT QUESTION


Is the MCDS in your execution JCL?

<snip>
  I noticed that eventhough I am including MIGRATEDATA however when I check the output it does not show any of the migrated dsns.
 
 DCOLLECT +       
 OFILE(OUTDS) +   
 VOLUME(*) +      
 STORAGEGROUP(*) +
 SMSDATA(ACTIVE) +
 MIGRATEDATA +    
 CAPPLANDATA +    
 BACKUPDATA       

</snip>
________________________________

----------------------------------------------------------------------
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
Staller, Allan
2013-07-18 12:49:52 UTC
Permalink
In that case, I would expect to see type M records in the OUTDS file.
Try a test, only requesting MIGRATEDATA and see what shows up in OUTDS.

i.e. DCOLLECT OFILE(OUTDS) MIGRATEDATA

<snip>
Yes.  It is.  Here is the jcl:
 
...snippage

Is the MCDS in your execution JCL?

<snip>
  I noticed that eventhough I am including MIGRATEDATA however when I check the output it does not show any of the migrated dsns.
 
 DCOLLECT +       
 OFILE(OUTDS) +   
 VOLUME(*) +      
 STORAGEGROUP(*) +
 SMSDATA(ACTIVE) +
 MIGRATEDATA +    
 CAPPLANDATA +    
 BACKUPDATA       

</snip>
________________________________

----------------------------------------------------------------------
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
esmie moo
2013-07-18 13:44:02 UTC
Permalink
Allan,
 
Your suggestion worked and it shows all the entries.  I will check the subsequent SAS jobs which runs after the DCOLLECT.


________________________________
From: "Staller, Allan" <***@KBMG.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Thursday, July 18, 2013 8:49:41 AM
Subject: Re: DCOLLECT QUESTION


In that case, I would expect to see type M records in the OUTDS file.
Try a test, only requesting MIGRATEDATA and see what shows up in OUTDS.

i.e. DCOLLECT OFILE(OUTDS) MIGRATEDATA

<snip>
Yes.  It is.  Here is the jcl:
 
...snippage

Is the MCDS in your execution JCL?

<snip>
  I noticed that eventhough I am including MIGRATEDATA however when I check the output it does not show any of the migrated dsns.
 
 DCOLLECT +       
 OFILE(OUTDS) +   
 VOLUME(*) +      
 STORAGEGROUP(*) +
 SMSDATA(ACTIVE) +
 MIGRATEDATA +    
 CAPPLANDATA +    
 BACKUPDATA       

</snip>
________________________________

----------------------------------------------------------------------
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
Staller, Allan
2013-07-17 16:48:41 UTC
Permalink
DCOLLECT will generate may record types. For your purposes type D (dataset) and type M (migrated dataset) and possibly type B (backed up dataset) come to mind.
AFAIK, there is no "out of the box" way to restrict the output to only SYS2.CICS.AS400.**

It seems that your only recourse is to post-process DCOLLECT output with (ICETOOL, SAS, .....)

HTH,

<snip>
I am trying to compile a report for a HLQ using DCOLLECT.  I want to extract info only for SYS2.CICS.AS400 Can this be done?  I checked the doc : z/OS DFSMS Access Method Services for Catalogs SC26-7394-04 chapter 11 for an example but I found none.  Would anybody have  an example?
</snip>
 

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Mike Wood
2013-07-17 20:33:31 UTC
Permalink
ESmie, Look at the report generator available under ISMF dialog.
There are some sample reports based on DCOLLECT, and the report generator allows you to use 'generic' field comparisons (sub strings)......

Mike Wood

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
esmie moo
2013-07-18 11:03:57 UTC
Permalink
Mike,
 
I checked the option G  Report Generation  - Create Storage Management Reports - out as well however I get the message :EDGS094  message not found in 'ISPMLIB' library.  Seems that this wasn't installed.
 
I was thinking of running the data selection via batch because of the enormity of the dsns.  Would you have an example?


________________________________
From: Mike Wood <***@NTLWORLD.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Wednesday, July 17, 2013 4:33:25 PM
Subject: Re: DCOLLECT QUESTION


ESmie,  Look at the report generator available under ISMF dialog.
There are some sample reports based on DCOLLECT, and the report generator allows you to use 'generic' field comparisons (sub strings)......

Mike Wood

----------------------------------------------------------------------
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
Lizette Koehler
2013-07-18 12:58:27 UTC
Permalink
Go to the RMM installation manuals, they will tell you what ISPF libraries
need to be added to your TSO Logon process to get option G to work. Also,
you want to download the SHARE presentations on how to run the Report
function.

Lizette


-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On
Behalf Of esmie moo
Sent: Thursday, July 18, 2013 4:04 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: DCOLLECT QUESTION

Mike,
 
I checked the option G  Report Generation  - Create Storage Management
Reports - out as well however I get the message :EDGS094  message not found
in 'ISPMLIB' library.  Seems that this wasn't installed.
 
I was thinking of running the data selection via batch because of the
enormity of the dsns.  Would you have an example?


________________________________
From: Mike Wood <***@NTLWORLD.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Wednesday, July 17, 2013 4:33:25 PM
Subject: Re: DCOLLECT QUESTION


ESmie,  Look at the report generator available under ISMF dialog.
There are some sample reports based on DCOLLECT, and the report generator
allows you to use 'generic' field comparisons (sub strings)......

Mike Wood

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Lizette Koehler
2013-07-18 13:00:47 UTC
Permalink
Just to help a little bit (I believe in research)

On my systems, the RMMISPF REXX is found in library SYS1.SEDGEXE1

So you should have other SYS1.SEDG* libraries that need to go into TSO Logon
process for ISMF

Lizette


-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On
Behalf Of Lizette Koehler
Sent: Thursday, July 18, 2013 5:58 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: DCOLLECT QUESTION

Go to the RMM installation manuals, they will tell you what ISPF libraries
need to be added to your TSO Logon process to get option G to work. Also,
you want to download the SHARE presentations on how to run the Report
function.

Lizette


-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On
Behalf Of esmie moo
Sent: Thursday, July 18, 2013 4:04 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: DCOLLECT QUESTION

Mike,
 
I checked the option G  Report Generation  - Create Storage Management
Reports - out as well however I get the message :EDGS094  message not found
in 'ISPMLIB' library.  Seems that this wasn't installed.
 
I was thinking of running the data selection via batch because of the
enormity of the dsns.  Would you have an example?


________________________________
From: Mike Wood <***@NTLWORLD.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Wednesday, July 17, 2013 4:33:25 PM
Subject: Re: DCOLLECT QUESTION


ESmie,  Look at the report generator available under ISMF dialog.
There are some sample reports based on DCOLLECT, and the report generator
allows you to use 'generic' field comparisons (sub strings)......

Mike Wood

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
esmie moo
2013-07-18 14:10:38 UTC
Permalink
Lizette,
 
Thank you.  I will take a look.


________________________________
From: Lizette Koehler <***@MINDSPRING.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Thursday, July 18, 2013 9:00:48 AM
Subject: Re: DCOLLECT QUESTION


Just to help a little bit (I believe in research)

On my systems, the RMMISPF REXX is found in library SYS1.SEDGEXE1

So you should have other SYS1.SEDG* libraries that need to go into TSO Logon
process for ISMF

Lizette


-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On
Behalf Of Lizette Koehler
Sent: Thursday, July 18, 2013 5:58 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: DCOLLECT QUESTION

Go to the RMM installation manuals, they will tell you what ISPF libraries
need to be added to your TSO Logon process to get option G to work.  Also,
you want to download the SHARE presentations on how to run the Report
function.

Lizette


-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On
Behalf Of esmie moo
Sent: Thursday, July 18, 2013 4:04 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: DCOLLECT QUESTION

Mike,
 
I checked the option G  Report Generation  - Create Storage Management
Reports - out as well however I get the message :EDGS094  message not found
in 'ISPMLIB' library.  Seems that this wasn't installed.
 
I was thinking of running the data selection via batch because of the
enormity of the dsns.  Would you have an example?


________________________________
From: Mike Wood <***@NTLWORLD.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Wednesday, July 17, 2013 4:33:25 PM
Subject: Re: DCOLLECT QUESTION


ESmie,  Look at the report generator available under ISMF dialog.
There are some sample reports based on DCOLLECT, and the report generator
allows you to use 'generic' field comparisons (sub strings)......

Mike Wood

----------------------------------------------------------------------
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
shmuel+ (Shmuel Metz , Seymour J.)
2013-07-18 13:16:39 UTC
Permalink
In <***@web165001.mail.bf1.yahoo.com>, on
07/18/2013
Post by esmie moo
I checked the option G  Report Generation  - Create Storage
Management Reports - out as well however I get the message :EDGS094 
message not found in 'ISPMLIB' library.  Seems that this wasn't
installed.
More likely it was installed but the libraries are not in you logon
proc. You should be able to add them with LIBDEF.
--
Shmuel (Seymour J.) Metz, SysProg and JOAT
Atid/2 <http://patriot.net/~shmuel>
We don't care. We don't have to care, we're Congress.
(S877: The Shut up and Eat Your spam act of 2003)

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Mike Wood
2013-07-18 14:07:03 UTC
Permalink
If your sys progs used the default names, you might find the exec EDGRMLIB (SYS1.SEDGEXE1) will dyanmically allocate the data sets needed and take you to the rmm dialog where option R will also be the report generator.
Its so easy to use, you shouldn't even need to RTM.

Mike

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
esmie moo
2013-07-19 12:29:23 UTC
Permalink
Mike,
 
I checked with the sysprog and I was told that this functionality was not installed and there are no plans to have it installed.  Thanks


________________________________
From: Mike Wood <***@NTLWORLD.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Thursday, July 18, 2013 10:06:57 AM
Subject: Re: DCOLLECT QUESTION


If your sys progs used the default names, you might find the exec EDGRMLIB (SYS1.SEDGEXE1) will dyanmically allocate the data sets needed and take you to the rmm dialog where option R will also be the report generator.
Its so easy to use, you shouldn't even need to RTM.

Mike

----------------------------------------------------------------------
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
Lizette Koehler
2013-07-19 12:39:03 UTC
Permalink
I would explain to your Sysprogs that this is a no fee function that is
helpful in doing work in ISMF. And that all that is needed is some
additional datasets in TSO Logon process. Also, that even though these are
RMM datasets, IBM provides them for a general reporting tool.

You might also check to see if the files are included in your sysres set.
Go to 3.4 and look for

**.SEDG*

For DSNAME Level. If they show up, just include that in your note saying,
you already ship the files, the just need to be available to my TSO/ISPF
Session.

Your Sysprogs may not realize they are a function in ISMF for all, not just
an RMM function.

Here is the summary from Mike Wood's Share Presentation on this feature

Summary
• The Report Generator is a full featured tool that can help simplify the
process of creating and managing ‘AdHoc’ reports
• It has many supplied samples and offers several ways to customize the
product to meet your needs
• Includes RMM, HSM, and SMS Report Types and Sample Reports
• It can also be used to
• report on almost any data
• Reformat or reduce almost any data record
• Context sensitive help screens provide useful information to assist you
when generating reports
• The Report Generator is documented in “DFSMSrmm Reporting” “Chapter 2.
Using the DFSMSrmm Report Generator”
• Continues to be Enhanced to enable more flexible reporting and
processing

• DFSMSrmm web site: www.storage.ibm.com/software/sms/rmm/


Lizette


-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On
Behalf Of esmie moo
Sent: Friday, July 19, 2013 5:29 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: DCOLLECT QUESTION

Mike,
 
I checked with the sysprog and I was told that this functionality was not
installed and there are no plans to have it installed.  Thanks


________________________________
From: Mike Wood <***@NTLWORLD.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Thursday, July 18, 2013 10:06:57 AM
Subject: Re: DCOLLECT QUESTION


If your sys progs used the default names, you might find the exec EDGRMLIB
(SYS1.SEDGEXE1) will dyanmically allocate the data sets needed and take you
to the rmm dialog where option R will also be the report generator.
Its so easy to use, you shouldn't even need to RTM.

Mike

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