Question

Data archive to Azure

  • 12 April 2024
  • 3 replies
  • 24 views
J
Rank
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

S
Rank
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

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

S
Rank
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


Terms & ConditionsCookie settings