go to post Alexander Pettitt · Sep 21, 2022 something like this works for me echo "h" | iris session [instance] -U [namespace] [routine]
go to post Alexander Pettitt · Sep 1, 2022 Are you looking in ^JOBEXAM or the SMP? As a out of the box idea I am going to suggest screen so you can just keep your session running. I know with VPN connections keeping a session going can be difficult.
go to post Alexander Pettitt · Jul 27, 2022 If you use PURGE^JOURNAL it will keep you from doing anything that will break your system. I would catch up your DR async before deleting journals. You should look at this Purging Mirror Journal Files
go to post Alexander Pettitt · Jul 20, 2022 Yes you could edit the database properties ^DATABASE so a particular database did not journal but I would be worried that the journals will also change the other datasets so I would unmount them before applying journals. It might be better to create a parallel instance and mount the restored database and then replay the journals. For a production issue I would reach out to the WRC.
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 21, 2022 Two possible issues: Are you running a backup? Do you have a network mounted filesystem like NFS or SMB? We need to see messages.log or cconsole.log for the time it was happening.
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 · Jun 1, 2022 One thing you can do is run it in steps for both the compaction and the free so you have performance effect data on your actual system. Do a run to compact and free of maybe 1 or 10 Gb. Be ready for the WIJ to expand. Try it on a non production copy if you can first and run an Integchk on the dataset after. Make sure you are on a current version of Cache or IRIS since some versions had issues. Know when your system really has it low utilization period. You might have midnight/end of day processing or someone might do the weekly ETL on the weekend.
go to post Alexander Pettitt · Jan 6, 2022 I no longer have a shadow to test with but something like:echo "d tag^routine \n h" | csession [instance] -U %SYSYou need Unix passthough authentication to work.Managing and Monitoring Shadowing might help you find the data you want
go to post Alexander Pettitt · Dec 13, 2021 The affected class is not part of the required install for Cache 2018.1.5.659.0 or IRIS 2020.1.1.408.0. I would search filesystems for JndiLookup and log4j.
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 · Oct 25, 2021 The ^DATABASE routine in %SYS allows you to edit the size. Sizing a CACHE.DAT avoids the on the fly expansion that would otherwise happen. Some people thought this would be a performance benefit.
go to post Alexander Pettitt · Oct 25, 2021 Looks like you can set charset to UTF-8 using the docs here. You might need the full version to do that.
go to post Alexander Pettitt · Oct 20, 2021 What charset do you want to use? That may be the issue. I use putty too.
go to post Alexander Pettitt · Oct 5, 2021 Intersystems has worked hard but encryption is not free. Do you have something like batch processing? You would notice an impact more there then on a 1 second query. I would worry more about key security and recovery. Encryption also has a serious impact on the ability of modern SAN storage to dedup and compress which could result in higher than expected storage costs.
go to post Alexander Pettitt · Sep 28, 2021 You might look at this tool combination for the last journal file. Convert Journal Files Using ^JCONVERT and ^%JREAD
go to post Alexander Pettitt · Sep 7, 2021 If you have not already, migrate to solid state disks. It is weird that the page Vic recommends does not mention that.
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 · Sep 1, 2021 Here is a link to the Cache document - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCDI_journal#GCDI_journal_view