Confluence will be unusable 23-July-2024 at 06:00 due to a Crowd upgrade.
The SQL for purging L1 data is:
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT
count(DATA_CATALOG_ADMIN.PurgeDatasetVersion(DatasetVersion))
FROM
DatasetGroup g
JOIN
VerDataset d
ON
(
d.DatasetGroup= g.DatasetGroup
)
JOIN
DatasetVersion dv
ON
(
dv.Dataset= d.Dataset
)
WHERE
g.DatasetLogicalFolder=39684091
and d.LatestVersion != dv.DatasetVersion
and Registered<sysdate-14
|
...
To actually delete the files the script in ~glast/datacat/prod/delete-datacat must be run (as glastraw on glastlnx21fermilnx-v21). .