All
Accepted answers
Alexander Pettitt · Jan 17, 2023 go to post

The role is subject to a company's idea of what the role is and their definition is the only one that matters.
Will you support the underlying OS for example?
The person who can give you the best ideas is the person who had the role before or their manager if they are not available.
The application vendor can give you ideas if there is one.
Understanding the what, how and why of the existing install is critical.

Sign up for product alerts from Intersystems here
Consider getting your own instance here
Here is link for IRIS administration documentation
 

Alexander Pettitt · Dec 5, 2022 go to post

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
Alexander Pettitt · Oct 26, 2022 go to post

Been a long time since I did this but when I did the performance impact was huge with a massive increase (+20%) in CPU.

There is still a warning on the app developer site to never do that.

Alexander Pettitt · Oct 7, 2022 go to post

This is a pretty severe issue with storage. I would examine why the journals are not getting written.
Are you seeing OS errors?

Alexander Pettitt · Sep 1, 2022 go to post

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.

Alexander Pettitt · Jul 20, 2022 go to post

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.

Alexander Pettitt · Jun 30, 2022 go to post

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 numbers
https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=GCM_glostat

Vertical Scaling IRIS
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSCALE_vertical

Alexander Pettitt · Jun 21, 2022 go to post

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.

Alexander Pettitt · Jun 14, 2022 go to post

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.

Alexander Pettitt · Jun 1, 2022 go to post

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.

Alexander Pettitt · Oct 25, 2021 go to post

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.

Alexander Pettitt · Oct 5, 2021 go to post

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.

Alexander Pettitt · Sep 7, 2021 go to post

If you have not already, migrate to solid state disks.

It is weird that the page Vic recommends does not mention that.

Alexander Pettitt · Sep 1, 2021 go to post

Many things could be happening.

How do you cleanup journal files? Purge after so many backups? Are your backup working?

You could look in a journal file and see what global data is causing the expansion.

If you have the system management portal you can look at journal data there too.

You might need to go to the application vendor to tell what data a global holds.

Alexander Pettitt · Jun 2, 2021 go to post

I think the WRC would be the only ones who could tell you what could be moved into CACHETEMP unless you found someone else  who they had told already.

If you just don't want to store so many journals you could just backup multiple times a day and do a journal purge.

Congratulations on using Ensemble to the point you have this problem.