Get ILM status on Oracle DB

Discussion created by Karim_Azzouzi_8427 on Feb 6, 2017
Latest reply on Feb 7, 2017 by Karim_Azzouzi_8427
We upgraded one of Automation Engine systems of Vodafone from without ILM to with ILM. 
The ILM is active and partition switched at 20th of january succesfully. 
However, the output of the below UC4 script is "ILM=N". 

As ILM scripting fonction is dedicated only to MS SQL(see documentation:https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/11.2/All%20Guides/help.htm#ucacqg.htm?Highlight=ILM) the workaround to get if ILM is active or not in oracle by script is to call VARA UC_ILM_SETTINGS and to use GET_VAR with the key ACTIVE