Earlier ODBC driver versions should be compatible with Caché 2018.1, but we recommend updating clients to the latest driver for your Caché version.  There aren't any 2021.x ODBC drivers for Caché on the WRC download page.  If you have one and you want to be sure you have a good driver, reach out to the WRC so we can understand your specific situation.

Erik

Hi Hoi, nice to see you in the community. You piqued my curiosity about FASP and I found this white paper about it: https://www.ibm.com/downloads/cas/7D3KBL9Z.

I don't see any support for this in our class reference.  If you are looking for support for this in InterSystems IRIS, I would start with your InterSystems account team to explore what you need and what alternatives might serve.

Kevin, manually allocating space for a database file allows you to (as Alexander mentioned) avoid expansions on-the-fly.  In some applications that extra overhead isn't desirable when the system is running.  Pre-expanding the database also commonly results in a contiguous file on disk, which can improve performance of storage and backup operations.  There can be other reasons, too, why limiting the size of a database would be desirable.

It should work.  Windows privileges need to be correct, and in recent Windows versions, it is not as simple as running as an Administrator.  If you have specified a user to run the IRIS instance, rather than the Local System account, run the irisinstall setserviceusername command (details are in the documentation) to set privileges correctly.

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

The InterSystems WRC can also help if you are truly stuck.

Gulshan, the path you take depends on how much money you want to spend and how you prefer to learn.  You have a lot of choices.  I'll add this one to the list of good options the others have posted:

https://wiki.python.org/moin/BeginnersGuide

It's an important language to learn for a lot of fields.  Good luck and post back here with what you chose.  That will probably help a lot of others.

Erik

Thank you, Michael, a picture will help a lot.  It sounds like Rose is some kind of server clustering solution that allows two servers to share a disk.

@wenjie zhao, if you are using Caché 2016.1 today, I would suggest that you discuss this with your account manager, who is probably most familiar with your system.  Your account manager can bring in technical resources if necessary to help you.
 

The InterSystems IRIS data platform is the engine in InterSystems' current product set.  IRIS for Health adds capabilities related to healthcare applications and DeepSee (part of the older Caché database engine) allows you to embed business intelligence capability into your applications.

For new development, or if you are just getting started, I would look to InterSystem IRIS and the products built on it, unless you know you have a specific need for Caché.

James,

The system-provided audit events are documented here:

https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GCAS_audit#GCAS_audit_sys_events

Check to see if these events will give you what you need:

  • %System/%DirectMode/DirectMode audits commands run at the IRIS terminal.
  • The events under %System/%SQL audit SQL commands.
  • %System/%System/OSCommand audits $ZF calls.

There are many others that track logins and system changes.

Erik