Skip to main content

Hi all,

Will the data archive objects in IFS allow objects and data to be moved to an Azure location.  This option can be taken for media archiving.

Thanks

 

@JannetteC 

Hope this will give you some guidance

https://docs.ifs.com/techdocs/foundation1/040_administration/260_data_management/020_data_archiving/220_large_volume_media_archiving/default.htm

 

Regards,

Sahan


Hello @Sahan Udana 

Thanks for your reply.  I have media arching setup - however the CLU’s that I am trying to move to Azure have not moved despite me setting the job as follows:

 

 

Should I be using another method such as Data Archive Objects ??


Can you check if the below query returning any results.

SELECT   t.item_id, NULL language_code, t.media_object, t.archive_no
FROM MEDIA_ITEM_TAB t
WHERE t.latest_access_date < (SYSDATE - 30)
AND NVL(Dbms_Lob.GetLength(t.media_object),0) > 0
AND t.archived = 'FALSE'
UNION ALL
SELECT l.item_id, l.language_code, l.media_object, l.archive_no
FROM MEDIA_ITEM_LANGUAGE_TAB l
WHERE l.latest_access_date < (SYSDATE - 30)
AND NVL(Dbms_Lob.GetLength(l.media_object),0) > 0
AND l.archived = 'FALSE';

These are the records not accessed for 30 days (last_access_limit_days) will be archived. If this has no results returned archiving will not happen. 


Reply