On 30/01/2021 00:31, Owen Morgan wrote:
[SNIP]
I would prefer to stay in the bounds of the SQL policy rule setup as
that is the framework I have created and started to implement..
In general SQL is Turing complete. Though I have not checked in detail I
believe the SQL of the policy engine is too.
I would also note that SQL has a whole bunch of time/date functions.
So something like
define(offset, 4)
define(day, DAYOFWEEK(CURRENT_TIMESTAMP))
define(age,(DAYS(CURRENT_TIMESTAMP)-DAYS(ACCESS_TIME)))
define(workingdays,
CASE
WHEN day=1
THEN offest+1
WHEN day=6
THEN offset
WHEN day=7
THEN offset+1
ELSE
offset+2
)
/* delete all files from files older than 4 working days */
RULE purge4 DELETE
WHERE (age>workingdays) FOR FILESET dummies
JAB.
--
Jonathan A. Buzzard Tel: +44141-5483420
HPC System Administrator, ARCHIE-WeSt.
University of Strathclyde, John Anderson Building, Glasgow. G4 0NG
_______________________________________________
gpfsug-discuss mailing list
gpfsug-discuss at spectrumscale.org
http://gpfsug.org/mailman/listinfo/gpfsug-discuss
