Versions Compared

Old Version 6

changes.mady.by.user Tony Johnson

Saved on

compared with

New Version Current

changes.mady.by.user Tony Johnson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The SQL for purging L1 data is:

Code Block
sql
sql

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). .