Question

Data archive to Azure

  • 12 April 2024
  • 3 replies
  • 26 views

Userlevel 3
Badge +10

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

 


3 replies

Userlevel 6
Badge +12

@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

Userlevel 3
Badge +10

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 ??

Userlevel 6
Badge +12

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