IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DFDSS COPY using Filter REFDT statement


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
markzasz

New User


Joined: 04 Apr 2017
Posts: 4
Location: USA

PostPosted: Thu Feb 11, 2021 7:15 pm
Reply with quote

I am trying to use DFDSS to COPY data from our General Pool to a Transfer Pool that contains 1Tb EAV volumes for an Application migration. The reason we need this to support moving the Application to a New LPAR and minimize the down time required to do this. the General Pool contains 400 Mod54 volumes and moving them would take 36 hours to copy the dat on the new LPAR. so we want to copy inactive data to the EAV's so the data can be copied to the New LPAR General Pool at a later date. Here are the few options i have tried with DFDSS and it seam to be looking at data 1 week old when i am looking for data at least 45 day old to start.

#1
//FILTER DD *
INC(B*.**, -
D*.**, -
E*.**, -
F*.**, -
P*.**, -
V*.**, -
X*.**) -
BY(REFDT LT 2020360) -
EXC(SYS1.**, -
*.*CM.**)

#2
//FILTER DD *
INC(B*.**, -
D*.**, -
E*.**, -
F*.**, -
P*.**, -
V*.**, -
X*.**) -
BY(REFDT LE 2020360) -
EXC(SYS1.**, -
*.*CM.**)

#3
//FILTER DD *
INC(B*.**, -
D*.**, -
E*.**, -
F*.**, -
P*.**, -
V*.**, -
X*.**) -
BY(REFDT GT 2020360) -
EXC(SYS1.**, -
*.*CM.**)

#4
//FILTER DD *
INC(B*.**, -
D*.**, -
E*.**, -
F*.**, -
P*.**, -
V*.**, -
X*.**) -
BY(REFDT LE *,-45) -
EXC(SYS1.**, -
*.*CM.**)
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Moderator


Joined: 14 Mar 2007
Posts: 10729
Location: italy

PostPosted: Thu Feb 11, 2021 7:41 pm
Reply with quote

Quote:
BY( REFDT LT (*,-xxxx) )


used to work for me
Back to top
View user's profile Send private message
markzasz

New User


Joined: 04 Apr 2017
Posts: 4
Location: USA

PostPosted: Thu Feb 11, 2021 8:14 pm
Reply with quote

Thank you, that is working....

It appears my confusion was due to the fact I have SELM(FIRST)
coded in my SYSIN controls and i was getting DS not selected due to no First, and when i looked at the DS it was created last week. so apparently the BY filter is not the first criteria used when looking at the dataset....

Thank you for the response.....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. include and copy COBOL Programming 4
No new posts Exception Filter CA Products 0
No new posts tso copy in the foreground TSO/ISPF 12
No new posts SKIP LOCKED DATA in UPDATE statement DB2 9
This topic is locked: you cannot edit posts or make replies. Copy list of files from PS to another... CLIST & REXX 11
Search our Forums:

Back to Top