Article Tomoko Furuzono · Oct 24, 2024 1m read Maximum Number of Namespaces and Databases InterSystems FAQ rubric The maximum number of namespaces that can be created in one instance is 2047. However, to use a large number of namespaces, you will need to configure memory accordingly. #Databases #System Administration #InterSystems IRIS #InterSystems IRIS for Health 1 0 0 128
Article Tomoko Furuzono · Sep 19, 2024 1m read How to get the current line of code that's being executed InterSystems FAQ rubric The location of the currently executing code can be obtained using the $STACK function: $STACK($STACK,"PLACE"). Please refer to the following document for sample code. #ObjectScript #InterSystems IRIS #Caché 2 0 1 178
Article Tomoko Furuzono · Sep 5, 2024 1m read Handling NULL in SQL InterSystems FAQ rubric In SQL, NULL data and the empty string ('') are different data. The method for setting and checking each is as follows. (1) NULL data [SQL] #ObjectScript #SQL #InterSystems IRIS #Caché 1 0 0 161
Article Tomoko Furuzono · Aug 29, 2024 1m read How to programmatically read a CSV file line by line InterSystems FAQ rubric This can be achieved by using the CSV() procedure of the %SQL.Util.Procedures class.Below is an example of usage code. (Assuming that the file test.csv is in c:\temp.) #ObjectScript #SQL #InterSystems IRIS #Caché 8 2 4 248
Article Tomoko Furuzono · Aug 8, 2024 2m read Mirrored databases are mounted read-only after removing the mirror configuration InterSystems FAQ rubric If you do not specify the option to remove the mirror attribute of the mirror database when deleting the mirror configuration, the database cannot be restored to a normal state and will be mounted read-only the next time it is mounted. To restore the database to a read-write state, you must remove the mirror attribute using the system routine ^MIRROR. The procedure is as follows (execute in the %SYS namespace): #Mirroring #Tips & Tricks #InterSystems IRIS #Caché #Ensemble #InterSystems IRIS for Health 2 0 1 133
Article Tomoko Furuzono · Jul 25, 2024 1m read How to compile class routines with mapped modifier InterSystems FAQ rubric To compile class routines including the mapped modifier, specify the compiler modifier "/mapped=1" or "/mapped". For example, do the following: [Example 1] Get the class list and compile #ObjectScript #Tips & Tricks #InterSystems IRIS #Caché #Ensemble #InterSystems IRIS for Health 2 1 0 107
Article Tomoko Furuzono · Jul 4, 2024 1m read How to change the special variable $ZTIMESTAMP to your local time zone InterSystems FAQ rubric $ZTIMESTAMP returns the date and time in UTC format, so to change it to the local time zone, use the following system method: $SYSTEM.Util.UTCtoLocalWithZTIMEZONE($ZTIMESTAMP) The above output will be in the format ddddd,sssss.fff. #ObjectScript #Tips & Tricks #InterSystems IRIS #Caché #Ensemble #InterSystems IRIS for Health 1 1 0 156
Article Tomoko Furuzono · Jun 13, 2024 4m read How to check the size of your data InterSystems FAQ rubric Data for InterSystems products (table row data, object instance data) is stored in global variables.The data size of each global can be obtained by clicking the properties of the global you want to view from the Management Portal > System > Configuration > Local Database > Globals page, and then clicking the Calculate Size button on the Global Attributes page that appears.To display the data sizes of globals in a namespace, you can call ^%GSIZE utility on the terminal. #Databases #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 4 2 1 505
Article Tomoko Furuzono · May 2, 2024 1m read After upgrading, when I try to open the Management Portal, I get ERROR #5001 and cannot open it InterSystems FAQ rubric After upgrading your system, you may receive the error below when you try to open the Management Portal: ERROR #5001: Server version of object does not match version sent from the client: %ZEN.Component.vgroup This error is caused by outdated information remaining in your browser's cache. #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 1 1 0 196
Article Tomoko Furuzono · Dec 14, 2023 1m read InterSystems IRIS does not start after restarting the OS after changing the machine name (host name) InterSystems FAQ rubric If you restart the OS after changing the machine name without stopping InterSystems IRIS (hereinafter referred to as IRIS), a problem occurs when IRIS cannot start. To get started, delete the <installation directory>\mgr\iris.ids file. #System Administration #InterSystems IRIS 4 5 0 436
Article Tomoko Furuzono · Nov 16, 2023 2m read How to run online backup from command InterSystems FAQ rubric To run an online backup from a command you can use the API BACKUP^DBACK routine.An example of performing a full backup is as follows. #System Administration #Tips & Tricks #InterSystems IRIS 4 0 0 276
Article Tomoko Furuzono · Jun 1, 2023 1m read How to shrink the IRISTemp database InterSystems FAQ rubric You can set the maximum size of the IRISTemp database at IRIS startup by setting a configuration parameter called MaxIRISTempSizeAtStart. After setting, the system will truncate IRISTemp to the set value (MB) at the next IRIS startup. If the current size is less than the specified MaxIRISTempSizeAtStart, no truncation will occur. Also, if 0 is specified, truncation will not be performed, so the size will start without changing. (Default) Settings are made from the menu below. #Best Practices #Management Portal #System Administration #Tips & Tricks #InterSystems IRIS #InterSystems IRIS for Health 7 1 0 599
Question Tomoko Furuzono · Jan 3, 2020 HL7 validation with "dmr-z" is not work as expected Hi, #HL7 #Interoperability #InterSystems IRIS for Health 0 2 0 341