The first two systems I worked with using InterSystems technology were a PDP-11 running M11+ and a VAX 11/750 running M/VX. Too many years ago to count! 😊
Since then I've used most, if not all, InterSystems products up to IRIS and HealShare today.
I'm italian living in Switzerland and I work as Senior Consultant at GAIVOTA consultin SA, we provide professional services for InterSystems and other technologies.
Curiosity: apart from DC, I don't have ANY social account! 😁
If I recall correctly I had a similar issue in some old Ensemble system but I'm not 100% sure the global was really that.
If you can stop the production, then I think it's safe to kill ^Ens.AppData, with the production running I don't think killing it it's a good idea.
A curiosity, do you use EnsLib.SQL.Snapshot class in some SQL host (BO)?
Is the content of ^Ens.AppData somewhat related to EnsLib.SQL.Snapshot?
Looking at the content of ^Ens.AppData, what type of adapter/operation is likely using it?
When I was migrating a system I had to export and import SQL Gateway Connection, so in the source system I exported to a tab delimited file and in the target system I imported the definitions.
The code to create the imported definition is:
Set SQLConnection=##class(%SQLConnection).%New()
Set SQLConnection.DSN=$p(line,tab,1)
Set SQLConnection.Name=$p(line,tab,2)
Set SQLConnection.ReverseOJ=$p(line,tab,3)
Set SQLConnection.URL=$p(line,tab,4)
Set SQLConnection.Usr=$p(line,tab,5)
Set SQLConnection.bUnicodeStream=$p(line,tab,6)
Set SQLConnection.classpath=$p(line,tab,7)
Set SQLConnection.driver=$p(line,tab,8)
Set SQLConnection.isJDBC=$p(line,tab,9)
Set SQLConnection.needlongdatalen=$p(line,tab,10)
Set SQLConnection.noconcat=$p(line,tab,11)
Set SQLConnection.nodefq=$p(line,tab,12)
Set SQLConnection.nofnconv=$p(line,tab,13)
Set SQLConnection.nvl=$p(line,tab,14)
Set SQLConnection.properties=$p(line,tab,15)
Set SQLConnection.pwd=$p(line,tab,16)
Set SQLConnection.useCAST=$p(line,tab,17)
Set SQLConnection.useCASTCHAR=$p(line,tab,18)
Set SQLConnection.useCOALESCE=$p(line,tab,19)
Set SQLConnection.xadriver=$p(line,tab,20)
Set sc=SQLConnection.%Save()
In the...good old days, we used to do that in one line 😂
s node="array" f s node=$q(@node) q:node="" w node,"=",@node,!
array(1)=1
array(1,1)=1,1
array(1,1,1)=1,1,1
array(1,1,1,1)=1,1,1,1
array(1,1,2)=1,1,2
array(1,1,3)=1,1,3
array(2)=2
array(2,1)=2,1
array(2,1,1)=2,1,1