go to post Alexander Pettitt · Apr 6 Set file=##class(%File).%New("[path/filename]") Write file.Size Do file.Open("AWS") Do file.WriteLine("This is a second line of text") Write file.Size do file.%Save() set file = "" // Close file This works for me
go to post Alexander Pettitt · Dec 5, 2022 Yes there is a way since I have seen it. The ZLOAD and ZREMOVE commands are combined. Here is a sample I was sent. zr zl showAdmins() n rs1,rs2,rc1,rc2,$NAMESPACE,user,adminrole,roles s $NAMESPACE="%SYS" s rs1=##class(%ResultSet).%New("Security.Roles:List") d rs1.Execute("*","%Admin_Manage:U,%Admin_Operate:U,%Admin_Secure:U") f s rc1=rs1.Next() q:rc1=0 d . s adminrole=rs1.Data("Name") . s rs2=##class(%ResultSet).%New("Security.Users:List") . d rs2.Execute("*",adminrole) . f s rc2=rs2.Next() q:rc2=0 w rs2.Data("Name"),"|",rs2.Data("Roles"),! q d showAdmins
go to post Alexander Pettitt · Jun 30, 2022 The host, storage and DB engine don't influence the gref count at all. Only what the code does.If you do a set,kill or write that is a gref.The host, storage and DB engine determine the limit of grefs per second.Faster storage is always better.More memory (larger global/routine buffer) is always better.Faster cores are always better. More cores are better if there is work for them to do.Newer versions of IRIS (DB engine) are always better. GLOSTAT will give you some numbershttps://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=GCM_glostat Vertical Scaling IRIShttps://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSCALE_vertical
go to post Alexander Pettitt · Jun 14, 2022 What does openssl version show? Guessing 3.x since that is the version that ships with Ubuntu 22.04. Bob is right, try on Ubuntu 20.04 instead. This shows the downside of IRIS being dependent on OS packages.
go to post Alexander Pettitt · Oct 26, 2021 Have you tried URL encoding? CON would be equal to %43%4F%4E and con would be %63%6F%6E
go to post Alexander Pettitt · Sep 2, 2021 I don't know a way that you can do that. You can run ^%GSIZE against a specific CACHE.DAT
go to post Alexander Pettitt · May 26, 2021 I have 21 instances of Cache running on a single server. There are a lot of pluses: simpler cpf, database snapshots, easier downtime negotiations I would manually specify memory since you likely have very few simultaneous users. Here is a link Sizing System Memory for Caché
go to post Alexander Pettitt · May 11, 2021 If your session is text you might make a look at a tool like screen that is available for Unix based systems.
go to post Alexander Pettitt · Apr 9, 2021 Death to extents :) I work in Unix where LVM and mount points would make this easy but it looks like Windows has mount points. Windows mount point
go to post Alexander Pettitt · Apr 9, 2021 You can compact and truncate the database while IRIS is up. Compacting a Database Truncating is the next section