Chuck;
I don't think the TYPE=FDR, which is a full volume restore, supports the
arguments you are giving it. I believe the select statement for this is:
SELECT VOL=xxxxxx,GEN=nnnn,COPY=n,CYCLE=nn,NVOL=xxxxxx
Where VOL is the volume you are restoring from, NVOL is the new volume to
restore to, GEN is the generation, CYCLE is the incremental cycle if using ABR.
I am pretty sure this is why you are not getting the results you would expect.
That being said, maybe try doing TYPE=ABR instead for a DATASET level restore:
//SYSIN DD *
RESTORE TYPE=ABR,
DSNENQ=NONE,
SELTERR=NO
EXCLUDE DSN=IDMS.PROD.HOLDER.SYS1.VTOCIX**
EXCLUDE DSN=IDMS.PROD.HOLDER.SYS1.VVDS**
EXCLUDE DSN=ID.DB.MA.PROD.**.NEW
EXCLUDE DSN=ID.DB.MA.PROD.**.OLD
EXCLUDE DSN=ID.DB.MA.PROD.**.SAVE
EXCLUDE DSN=ID.DB.MA.PROD.UDI**
SELECT DSN=ID.DB.MA.PROD.**,NEWI=...TEST
/*
As a note, I kept your original parm of SELTERR=NO (not the default) which
tells it to not ABEND if one or more of the SELECT or EXCLUDE statements does
not get a match. I also modified the SELECT statement, as I believe you missed
a . before the ** after the PROD to make the ** a qualifier.
I assume you have SMS rules in place to put these on the correct volumes?
Hopefully this helps.
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Hardee, Chuck
Sent: Tuesday, January 03, 2017 2:11 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FDR List
Thanks Nick, I'll try to be as detailed as I can.
I have 235 production datasets across 6 packs. I needed to restore the datasets
to 6 test packs.
The datasets are of the format: ID.DB.MA.PROD.AMPSYOVY.PX001001
The difference in the datasets are that the last 6 digits change. The first 3
digits are a "family" id and the last 3 digits are a sequence number within the
family.
The naming for the TEST environment would be ID.DB.MA.TEST.AMPSYOVY.PX001001
The "family" and sequencing would remain the same.
So, in a nutshell, the files are to be restored from 6 prod packs to 6 test
packs changing the PROD to TEST.
The packs are of a format ID2P01 thru 06 and ID2T01 thru 06.
This is what I fed to FDR:
//SYSIN DD *
RESTORE TYPE=FDR,
ENQERR=NO,
ACTMESS=NO,
DATA=USED,
SELTERR=NO,
CONFMESS=NO
EXCLUDE DSN=IDMS.PROD.HOLDER.SYS1.VTOCIX**
EXCLUDE DSN=IDMS.PROD.HOLDER.SYS1.VVDS**
EXCLUDE DSN=ID.DB.MA.PROD.**.NEW
EXCLUDE DSN=ID.DB.MA.PROD.**.OLD
EXCLUDE DSN=ID.DB.MA.PROD.**.SAVE
EXCLUDE DSN=ID.DB.MA.PROD.UDI**
SELECT DSN=ID.DB.MA.PROD**,NEWI=...TEST
/*
After the restore was complete, the existing files
ID.DB.MA.TEST.AMPSYOVY.PX001001, etc were deleted, but the catalog entries
remained and the production files were placed on the test volumes but the PROD
was not changed to TEST.
Additionally, there were also 6 "rogue" files on 2 of the prod packs, their
naming was ID.DB.MA.PROD.CAS02001.SAVE, etc.
These files were also restored, but to my way of thinking, the EXCLUDE for the
ID.DB.MA.PROD.**.SAVE should have caused them to be excluded from being
restored to the test packs.
So, what am I missing here?
First, as a file name is run thru the list of exclude and select parms, the
file name ending in SAVE should have been eliminated, right?
Then, if a file makes it past the excludes, if it matches the DSN+ value, it
should be restored, but the PROD node in the name should have been changed to
TEST, right?
Also, the last couple of lines in the output from the restore process are this:
FDR316** FDR DID NOT FIND REQUESTED DSN/G=ID.DB.MA.PROD**
FDR999 FDR SUCCESSFULLY COMPLETED
I'm sure these lines say it all, but to me, they don't say a thing.
Let me say right now, I inherited this job stream from someone who is no longer
here so I cannot say with absolute certainty that this ran successfully last
year.
Thanks for taking the time to look at this.
Chuck
Charles (Chuck) Hardee
Senior Systems Engineer/Database Administration EAS Information Technology
Thermo Fisher Scientific
300 Industry Drive | Pittsburgh, PA 15275 Phone +1 (724) 517-2633 | Mobile +1
(412) 877-2809 | FAX: +1 (412) 490-9230 chuck.har...@thermofisher.com |
www.thermofisher.com
WORLDWIDE CONFIDENTIALITY NOTE: Dissemination, distribution or copying of this
e-mail or the information herein by anyone other than the intended recipient,
or an employee or agent of a system responsible for delivering the message to
the intended recipient, is prohibited. If you are not the intended recipient,
please inform the sender and delete all copies.
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Icke, Nick
Sent: Tuesday, January 03, 2017 1:58 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FDR List
Whats the prob you are encountering and can you supply the exec pack, I maybe
able to help
Ta
Nick
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Hardee, Chuck
Sent: 03 January 2017 18:56
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: FDR List
Does anyone know if there is an FDR list out there somewhere?
If there isn't one, is anyone willing to offer insight on an FDR RESTORE
problem I am having?
Thanks,
Chuck
Charles (Chuck) Hardee<mailto:chuck.har...@thermofisher.com>
Senior Systems Engineer/Database Administration EAS Information
Technology<mailto:DBA%20Engineering%20-%20DB2_IDMS>
Thermo Fisher Scientific
300 Industry Drive | Pittsburgh, PA 15275 Phone +1 (724) 517-2633 | Mobile +1
(412) 877-2809 | FAX: +1 (412) 490-9230
chuck.har...@thermofisher.com<mailto:chuck.har...@thermofisher.com> |
www.thermofisher.com
WORLDWIDE CONFIDENTIALITY NOTE: Dissemination, distribution or copying of this
e-mail or the information herein by anyone other than the intended recipient,
or an employee or agent of a system responsible for delivering the message to
the intended recipient, is prohibited. If you are not the intended recipient,
please inform the sender and delete all copies.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
E-MAIL CONFIDENTIALITY NOTICE: This e-mail from Donegal Insurance Group may
contain CONFIDENTIAL and legally protected information. If you are not an
intended recipient, please do not copy, use or disclose this email or its
contents to others; and please notify us by calling toll free (800) 877-0600
x7880 or by replying to this message, and then delete it from your system.
Delivery of this email to an unintended recipient is not a waiver of any
attorney-client or other applicable privilege.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
