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
[email protected] | 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:[email protected]] On Behalf
Of Icke, Nick
Sent: Tuesday, January 03, 2017 1:58 PM
To: [email protected]
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:[email protected]] On Behalf
Of Hardee, Chuck
Sent: 03 January 2017 18:56
To: [email protected]
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:[email protected]>
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
[email protected]<mailto:[email protected]> |
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
[email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
