<div dir="ltr"><div dir="ltr"><div dir="ltr">Agree.. Write a policy that takes a "mmapplypolicy -M var=val" argument, and figure out the workdays outside of the policy. Something like:<div><br></div><div># cat test.poilcy</div><div><div>define( access_age, (DAYS(CURRENT_TIMESTAMP) - DAYS(ACCESS_TIME)))</div><div>/* list migrated files */</div><div>RULE EXTERNAL LIST 'oldFiles' EXEC ''</div><div>RULE 'oldFiles' LIST 'oldFiles'</div><div> WHERE (access_age > MINAGE)</div></div><div><br></div><div># mmapplypolicy gpfs01 -P test.policy -I defer -f ./filelist -M MINAGE=5</div><div><br></div><div><br></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Feb 1, 2021 at 5:29 PM Daniel Kidger <<a href="mailto:daniel.kidger@uk.ibm.com">daniel.kidger@uk.ibm.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:9pt"><div dir="ltr">To me, it feels like you need to do the search the other way around.</div>
<div dir="ltr"> </div>
<div dir="ltr">Firstly, from the target of say "4 weekdays ago", work out how many real days ago that was.</div>
<div dir="ltr">Then use that as a criteria in mmfind or mmapplypolicy.</div>
<div dir="ltr"> </div>
<div dir="ltr"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10.5pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10.5pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10.5pt"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:10.5pt"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr" style="margin-top:20px"><div style="margin-top:10px"><div style="font-family:sans-serif;font-size:8pt;margin-bottom:0.0001pt;line-height:normal"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><span style="font-size:1em">Daniel</span></font></font></div>
<div style="font-family:sans-serif;font-size:8pt;margin-bottom:0.0001pt;line-height:normal"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"> </font></font></div>
<div style="margin-bottom:0.0001pt;line-height:normal"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font color="#19A9F3" size="3" style="font-family:"Helvetica Neue",Helvetica,Arial,"Lucida Grande",sans-serif;font-size:8pt;outline:none">_________________________________________________________</font><br style="outline:none"><font color="#808080" face="Arial" size="2"><span><b>Daniel Kidger Ph.D.</b></span></font></font></font></div>
<div style="margin-bottom:0.0001pt;line-height:normal"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><span style="outline:none;font-size:10.666666984558105px"><font color="#121212"><span style="outline:none;font-size:7.5pt">IBM Technical Sales Specialist</span></font></span></font></font></div>
<div style="margin-bottom:0.0001pt;line-height:normal"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><span style="outline:none;font-size:10.666666984558105px"><font color="#121212"><span style="outline:none;font-size:7.5pt">Spectrum Scale, Spectrum Discover and IBM Cloud Object Storage<br style="outline:none"><br style="outline:none"><span style="font-size:0.857em">+</span></span></font></span><span style="font-size:0.857em"><span style="outline:none;font-family:sans-serif"><font color="#5f5f5f"><span style="outline:none;font-family:Verdana,Geneva,sans-serif"><span style="outline:none">44-(0)7818 522 266 </span></span></font></span></span><br style="outline:none;font-family:sans-serif;font-size:10.666666984558105px"><span style="outline:none;font-family:sans-serif;font-size:10.666666984558105px"><font color="#5f5f5f"><span style="outline:none;font-family:Arial,Helvetica,sans-serif"><span style="outline:none;font-size:8pt"><a href="mailto:daniel.kidger@uk.ibm.com" target="_blank">daniel.kidger@uk.ibm.com</a></span></span></font></span> </font></font>
<table border="0" style="border-collapse:collapse;border-color:rgb(105,105,105);table-layout:fixed;width:360px;word-wrap:break-word"> <tbody> <tr> <td style="overflow:hidden;width:66px;border-color:rgb(105,105,105)"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><a href="https://www.youracclaim.com/badges/687cf790-fe65-4a92-b129-d23ae41862ac/public_url" target="_blank"><img alt="" src="https://images.youracclaim.com/size/110x110/images/c49300ae-d13e-4071-90f5-15f59d199c9e/IBM_Volunteers_Gold_v6.png" style="width: 90px; height: 90px;"></a></font></font></td> <td style="overflow:hidden;width:66px;border-color:rgb(105,105,105)"><a href="https://www.youracclaim.com/badges/8dac4bc0-7b3a-4035-b127-daec8dce9200" target="_blank"><img src="https://images.youracclaim.com/size/110x110/images/c3275eba-a1a8-4602-ab7a-c857877733fb/Virtual_Collabortor_Enterprise.png" style="width: 90px; height: 90px;"></a></td> <td style="overflow:hidden;width:66px;border-color:rgb(105,105,105)"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><a href="https://www.youracclaim.com/badges/8153c6a7-3e02-40be-87ee-24e27ae9459c/public_url" target="_blank"><img alt="" src="https://images.youracclaim.com/size/110x110/images/f2539224-f951-46b4-b376-b88f21c2be98/IBM-Selling-Certification---Level-1.png" style="width: 90px; height: 90px;"></a></font></font></td> <td style="overflow:hidden;width:66px;border-color:rgb(105,105,105)"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><a href="https://www.youracclaim.com/badges/78197e2c-4277-4ec9-808b-ad6abe1e1b16/public_url" target="_blank"><img alt="" src="https://images.youracclaim.com/size/110x110/images/ea52b12f-97ac-4e72-8d24-b0ced8054e7d/Storage_Technical_V1.png" style="width: 90px; height: 90px;"></a></font></font></td> </tr> </tbody></table><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"> </font></font>
<div><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"> </font></font></div><font face="Verdana,Arial,Helvetica,sans-serif" size="2"><font face="Verdana,Arial,Helvetica,sans-serif" size="2"> </font></font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
<div dir="ltr"> </div>
<div dir="ltr"> </div>
<blockquote dir="ltr" style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(170,170,170);margin-left:5px;padding-left:5px;direction:ltr;margin-right:0px">----- Original message -----<br>From: Jonathan Buzzard <<a href="mailto:jonathan.buzzard@strath.ac.uk" target="_blank">jonathan.buzzard@strath.ac.uk</a>><br>Sent by: <a href="mailto:gpfsug-discuss-bounces@spectrumscale.org" target="_blank">gpfsug-discuss-bounces@spectrumscale.org</a><br>To: <a href="mailto:gpfsug-discuss@spectrumscale.org" target="_blank">gpfsug-discuss@spectrumscale.org</a><br>Cc:<br>Subject: [EXTERNAL] Re: [gpfsug-discuss] gpfsug-discuss Digest, Vol 108, Issue 18<br>Date: Sat, Jan 30, 2021 10:29<br>
<div><font face="Default Monospace,Courier New,Courier,monospace" size="2">On 30/01/2021 00:31, Owen Morgan wrote:<br><br>[SNIP]<br><br>><br>> I would prefer to stay in the bounds of the SQL policy rule setup as<br>> that is the framework I have created and started to implement..<br>><br>In general SQL is Turing complete. Though I have not checked in detail I<br>believe the SQL of the policy engine is too.<br><br>I would also note that SQL has a whole bunch of time/date functions.<br><br>So something like<br><br>define(offset, 4)<br>define(day, DAYOFWEEK(CURRENT_TIMESTAMP))<br>define(age,(DAYS(CURRENT_TIMESTAMP)-DAYS(ACCESS_TIME)))<br>define(workingdays,<br>CASE<br>WHEN day=1<br>THEN offest+1<br>WHEN day=6<br>THEN offset<br>WHEN day=7<br>THEN offset+1<br>ELSE<br>offset+2<br>)<br><br>/* delete all files from files older than 4 working days */<br>RULE purge4 DELETE<br> WHERE (age>workingdays) FOR FILESET dummies<br><br><br>JAB.<br><br>--<br>Jonathan A. Buzzard Tel: +44141-5483420<br>HPC System Administrator, ARCHIE-WeSt.<br>University of Strathclyde, John Anderson Building, Glasgow. G4 0NG<br>_______________________________________________<br>gpfsug-discuss mailing list<br>gpfsug-discuss at <a href="http://spectrumscale.org" target="_blank">spectrumscale.org</a><br><a href="http://gpfsug.org/mailman/listinfo/gpfsug-discuss" target="_blank">http://gpfsug.org/mailman/listinfo/gpfsug-discuss</a> </font><br> </div></blockquote>
<div dir="ltr"> </div></div>Unless stated otherwise above:<br>
IBM United Kingdom Limited - Registered in England and Wales with number 741598. <br>
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU<br>
<br>
_______________________________________________<br>
gpfsug-discuss mailing list<br>
gpfsug-discuss at <a href="http://spectrumscale.org" rel="noreferrer" target="_blank">spectrumscale.org</a><br>
<a href="http://gpfsug.org/mailman/listinfo/gpfsug-discuss" rel="noreferrer" target="_blank">http://gpfsug.org/mailman/listinfo/gpfsug-discuss</a><br>
</blockquote></div>