MERGECAT QUESTION

Discussion:

MERGECAT QUESTION

(too old to reply)

Lizette Koehler

2017-09-22 21:32:43 UTC

I guess one question not asked is how is the Master cat updated this way.

I think a best practice is to have MCAT READ Access with only a few users who can update to add ALIASes and the like.

If your MCAT is not READ, that may be a task you may wish to perform

Lizette

-----Original Message-----
Behalf Of esmie moo
Sent: Friday, September 22, 2017 8:16 AM
Subject: MERGECAT QUESTION
Gentle Readers,
We have about hundreds of user dsns which are cataloged in the MCAT because
the alias for the users were not defined.My question is the sequence I should
follow. For example do I define the ALIAS and then perform the MERGECAT? or I
perform the MERGECAT and then define the ALIAS?I don't have a test system in
which I can try it out.
Below is my jcl to run the
MERGECAT:/* //STEP1 EXEC
PGM=IDCAMS,REGION=2048K,TIME=1440 //DD1 DD VOL=SER=MCAT03,UNIT=SYSA
LLDA,DISP=OLD// DD VOL=SER=TST001,UNIT=SYSALLDA,DISP=OLD//SYSPRINT
DD SYSOUT=* //SYSIN DD *
REPRO -
INDATASET(TSUT3.MCAT) -
OUTDATASET(USERCAT.APPLIC) -
LEVEL(CTPRT17) -
MERGECAT -
FILE(DD1)
/* //
Thanks.

Jesse 1 Robinson

2017-09-22 22:23:49 UTC

Permalink

MCAT should certainly be READ for all but a handful of system support folks. The actions required here require MCAT update in two respects: MERGECAT deletes source entries from MCAT, while DEF ALIAS requires yet another update.

.
.
J.O.Skip Robinson
Southern California Edison Company
Electric Dragon Team Paddler
SHARE MVS Program Co-Manager
323-715-0595 Mobile
626-543-6132 Office ⇐=== NEW
***@sce.com

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of Lizette Koehler
Sent: Friday, September 22, 2017 2:34 PM
To: IBM-***@LISTSERV.UA.EDU
Subject: (External):Re: MERGECAT QUESTION

I guess one question not asked is how is the Master cat updated this way.

I think a best practice is to have MCAT READ Access with only a few users who can update to add ALIASes and the like.

If your MCAT is not READ, that may be a task you may wish to perform

Lizette

-----Original Message-----
On Behalf Of esmie moo
Sent: Friday, September 22, 2017 8:16 AM
Subject: MERGECAT QUESTION
Gentle Readers,
We have about hundreds of user dsns which are cataloged in the MCAT
because the alias for the users were not defined.My question is the
sequence I should follow. For example do I define the ALIAS and then
perform the MERGECAT? or I perform the MERGECAT and then define the
ALIAS?I don't have a test system in which I can try it out.
Below is my jcl to run the
MERGECAT:/* //STEP1 EXEC
PGM=IDCAMS,REGION=2048K,TIME=1440 //DD1 DD VOL=SER=MCAT03,UNIT=SYSA
LLDA,DISP=OLD// DD VOL=SER=TST001,UNIT=SYSALLDA,DISP=OLD//SYSPRINT
DD SYSOUT=* //SYSIN DD *
REPRO -
INDATASET(TSUT3.MCAT) -
OUTDATASET(USERCAT.APPLIC) -
LEVEL(CTPRT17) -
MERGECAT -
FILE(DD1)
/* //
Thanks.

John Dawes

2017-09-26 16:06:24 UTC

Permalink

Jesse,

I noticed that in your example you do not have the DD1 statements which indicate on which disks the dsns exist.

Is it no longer required? I remember that in the past I had to code in the jcl several DD1 statements when I was doing a REPRO MERGECAT.

Could you or somebody confirm? I ran test using your example and it worked. Just want to be sure.

Sorry to sound like a doubting Thomas. Catalog maintenance makes me nervous.

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

retired mainframer

2017-09-26 16:35:43 UTC

Permalink

Since you are not accessing the datasets, why would you care what volume they are on. MERGECAT moves catalog entries from one catalog to another. If any of the entries being moved require the VVDS be updated, the information to access that VVDS is already available and there is no need for the user to provide it.

-----Original Message-----
Behalf Of John Dawes
Sent: Tuesday, September 26, 2017 9:08 AM
Subject: Re: MERGECAT QUESTION
Jesse,
I noticed that in your example you do not have the DD1 statements which indicate on
which disks the dsns exist.
Is it no longer required? I remember that in the past I had to code in the jcl several DD1
statements when I was doing a REPRO MERGECAT.
Could you or somebody confirm? I ran test using your example and it worked. Just want
to be sure.
Sorry to sound like a doubting Thomas. Catalog maintenance makes me nervous.

Neubert, Kevin

2017-09-26 16:53:09 UTC

Permalink

DFSMS Access Method Services Commands (SC23-6846), REPRO, REPRO Parameters.

FILE(ddname)

specifies the name of a DD statement that identifies all the volumes that
contain the VVDSs to be updated. If you do not specify FILE, VSAM will try
to dynamically allocate the required volumes.

Regards,

Kevin

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of retired mainframer
Sent: Tuesday, September 26, 2017 9:37 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Since you are not accessing the datasets, why would you care what volume they are on. MERGECAT moves catalog entries from one catalog to another. If any of the entries being moved require the VVDS be updated, the information to access that VVDS is already available and there is no need for the user to provide it.

-----Original Message-----
On Behalf Of John Dawes
Sent: Tuesday, September 26, 2017 9:08 AM
Subject: Re: MERGECAT QUESTION
Jesse,
I noticed that in your example you do not have the DD1 statements
which indicate on which disks the dsns exist.
Is it no longer required? I remember that in the past I had to code
in the jcl several DD1 statements when I was doing a REPRO MERGECAT.
Could you or somebody confirm? I ran test using your example and it
worked. Just want to be sure.
Sorry to sound like a doubting Thomas. Catalog maintenance makes me nervous.

esmie moo

2017-09-26 17:23:42 UTC

Permalink

Kevin,
Now I am worried. I am the origin of the post. I checked and so far I haven't processed any VSAM dsns. If I understand your recommendation, I would need to add the DD statement FILE if VSAM files are to be processed?

On Tuesday, September 26, 2017, 12:54:30 PM EDT, Neubert, Kevin <***@COURTS.WA.GOV> wrote:

DFSMS Access Method Services Commands (SC23-6846), REPRO, REPRO Parameters.

FILE(ddname)

specifies the name of a DD statement that identifies all the volumes that
contain the VVDSs to be updated. If you do not specify FILE, VSAM will try
to dynamically allocate the required volumes.

Regards,

Kevin

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of retired mainframer
Sent: Tuesday, September 26, 2017 9:37 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Since you are not accessing the datasets, why would you care what volume they are on. MERGECAT moves catalog entries from one catalog to another. If any of the entries being moved require the VVDS be updated, the information to access that VVDS is already available and there is no need for the user to provide it.

Steely.Mark

2017-09-26 17:34:20 UTC

Permalink

I just executed Mergecat process over the weekend and processed several VSAM entries and I did not have to supply any FILE DD statements.

Thanks

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of esmie moo
Sent: Tuesday, September 26, 2017 12:25 PM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Kevin,
Now I am worried. I am the origin of the post. I checked and so far I haven't processed any VSAM dsns. If I understand your recommendation, I would need to add the DD statement FILE if VSAM files are to be processed?

On Tuesday, September 26, 2017, 12:54:30 PM EDT, Neubert, Kevin <***@COURTS.WA.GOV> wrote:

DFSMS Access Method Services Commands (SC23-6846), REPRO, REPRO Parameters.

FILE(ddname)

specifies the name of a DD statement that identifies all the volumes that contain the VVDSs to be updated. If you do not specify FILE, VSAM will try to dynamically allocate the required volumes.

Regards,

Kevin

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of retired mainframer
Sent: Tuesday, September 26, 2017 9:37 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Since you are not accessing the datasets, why would you care what volume they are on. MERGECAT moves catalog entries from one catalog to another. If any of the entries being moved require the VVDS be updated, the information to access that VVDS is already available and there is no need for the user to provide it.

Carmen Vitullo

2017-09-26 18:00:40 UTC

Permalink

not necessary if processing all entries on all volumes online, but if you want to move some entries from a specific volume you can use the FILE(DDx) statement

//MOVEPAGE EXEC PGM=IDCAMS
//UCATDVR DD DSN=CATALOG.xxx.OSxxx.MCAT,DISP=SHR
//UCATNEW DD DSN=CATALOG.xxx.OSxxx.MCAT,DISP=SHR
//DD1 DD VOL=SER=DRxxx,UNIT=3390,DISP=OLD
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
REPRO ENTRIES(hlq.mlq.*) -
INFILE(UCATDVR) OUTFILE(UCATNEW) MERGECAT FILE(DD1)

carmen
----- Original Message -----

From: "Steely.Mark" <***@AAA-TEXAS.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Tuesday, September 26, 2017 12:35:01 PM
Subject: Re: MERGECAT QUESTION

I just executed Mergecat process over the weekend and processed several VSAM entries and I did not have to supply any FILE DD statements.

Thanks

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of esmie moo
Sent: Tuesday, September 26, 2017 12:25 PM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Kevin,
Now I am worried. I am the origin of the post. I checked and so far I haven't processed any VSAM dsns. If I understand your recommendation, I would need to add the DD statement FILE if VSAM files are to be processed?

On Tuesday, September 26, 2017, 12:54:30 PM EDT, Neubert, Kevin <***@COURTS.WA.GOV> wrote:

DFSMS Access Method Services Commands (SC23-6846), REPRO, REPRO Parameters.

FILE(ddname)

specifies the name of a DD statement that identifies all the volumes that contain the VVDSs to be updated. If you do not specify FILE, VSAM will try to dynamically allocate the required volumes.

Regards,

Kevin

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of retired mainframer
Sent: Tuesday, September 26, 2017 9:37 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Since you are not accessing the datasets, why would you care what volume they are on. MERGECAT moves catalog entries from one catalog to another. If any of the entries being moved require the VVDS be updated, the information to access that VVDS is already available and there is no need for the user to provide it.

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

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

esmie moo

2017-09-27 16:30:54 UTC

Permalink

Carmine and all the rest,
Thanks for easing my concerns and for the explanation as to why FILE(DD1) is used.
I will run future REPRO MERGECAT without the FILE(DD1) statements.
Thanks
On Tuesday, September 26, 2017, 2:02:02 PM EDT, Carmen Vitullo <***@HUGHES.NET> wrote:

not necessary if processing all entries on all volumes online, but if you want to move some entries from a specific volume you can use the FILE(DDx) statement

//MOVEPAGE EXEC PGM=IDCAMS
//UCATDVR DD DSN=CATALOG.xxx.OSxxx.MCAT,DISP=SHR
//UCATNEW DD DSN=CATALOG.xxx.OSxxx.MCAT,DISP=SHR
//DD1 DD VOL=SER=DRxxx,UNIT=3390,DISP=OLD
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
REPRO ENTRIES(hlq.mlq.*) -
INFILE(UCATDVR) OUTFILE(UCATNEW) MERGECAT FILE(DD1)

carmen
----- Original Message -----

From: "Steely.Mark" <***@AAA-TEXAS.COM>
To: IBM-***@LISTSERV.UA.EDU
Sent: Tuesday, September 26, 2017 12:35:01 PM
Subject: Re: MERGECAT QUESTION

I just executed Mergecat process over the weekend and processed several VSAM entries and I did not have to supply any FILE DD statements.

Thanks

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of esmie moo
Sent: Tuesday, September 26, 2017 12:25 PM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Kevin,
Now I am worried. I am the origin of the post. I checked and so far I haven't processed any VSAM dsns. If I understand your recommendation, I would need to add the DD statement FILE if VSAM files are to be processed?

On Tuesday, September 26, 2017, 12:54:30 PM EDT, Neubert, Kevin <***@COURTS.WA.GOV> wrote:

DFSMS Access Method Services Commands (SC23-6846), REPRO, REPRO Parameters.

FILE(ddname)

specifies the name of a DD statement that identifies all the volumes that contain the VVDSs to be updated. If you do not specify FILE, VSAM will try to dynamically allocate the required volumes.

Regards,

Kevin

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of retired mainframer
Sent: Tuesday, September 26, 2017 9:37 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Since you are not accessing the datasets, why would you care what volume they are on. MERGECAT moves catalog entries from one catalog to another. If any of the entries being moved require the VVDS be updated, the information to access that VVDS is already available and there is no need for the user to provide it.

Neubert, Kevin

2017-09-26 23:40:33 UTC

Permalink

My apologies, was simply noting the behavior per the commands manual… “If you do not specify FILE, VSAM will try to dynamically allocate the required volumes.”

Regards,

Kevin

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of esmie moo
Sent: Tuesday, September 26, 2017 10:25 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Kevin,
Now I am worried. I am the origin of the post. I checked and so far I haven't processed any VSAM dsns. If I understand your recommendation, I would need to add the DD statement FILE if VSAM files are to be processed?

On Tuesday, September 26, 2017, 12:54:30 PM EDT, Neubert, Kevin <***@COURTS.WA.GOV> wrote:

DFSMS Access Method Services Commands (SC23-6846), REPRO, REPRO Parameters.

FILE(ddname)

specifies the name of a DD statement that identifies all the volumes that contain the VVDSs to be updated. If you do not specify FILE, VSAM will try to dynamically allocate the required volumes.

Regards,

Kevin

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of retired mainframer
Sent: Tuesday, September 26, 2017 9:37 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: Re: MERGECAT QUESTION

Since you are not accessing the datasets, why would you care what volume they are on. MERGECAT moves catalog entries from one catalog to another. If any of the entries being moved require the VVDS be updated, the information to access that VVDS is already available and there is no need for the user to provide it.

Jesse 1 Robinson

2017-09-26 16:32:52 UTC

Permalink

No problem, Thomas. ;-) As I said, that is (more or less) the JCL that I last used for MERGECAT. There is no reference in control statements to the JCL DD card. I suspect that the old requirement to 'mount' an online DASD volume--especially the one containing the master catalog--has been relaxed or eliminated. It seems pretty primitive the era of dynamic allocation. I did not consult official doc before posting.

.
.
J.O.Skip Robinson
Southern California Edison Company
Electric Dragon Team Paddler
SHARE MVS Program Co-Manager
323-715-0595 Mobile
626-543-6132 Office ⇐=== NEW
***@sce.com

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@LISTSERV.UA.EDU] On Behalf Of John Dawes
Sent: Tuesday, September 26, 2017 9:08 AM
To: IBM-***@LISTSERV.UA.EDU
Subject: (External):Re: MERGECAT QUESTION

Jesse,

I noticed that in your example you do not have the DD1 statements which indicate on which disks the dsns exist.

Is it no longer required? I remember that in the past I had to code in the jcl several DD1 statements when I was doing a REPRO MERGECAT.

Could you or somebody confirm? I ran test using your example and it worked. Just want to be sure.

Sorry to sound like a doubting Thomas. Catalog maintenance makes me nervous.

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