Article Sylvain Guilbaud · Aug 24, 2023 1m read How to regenerate a blank AUDIT database? It sometimes happens that due to an adverse event the AUDIT database (IRISAUDIT) has grown to such proportions that the disk it resides on is full and the daily purge cannot be expected to reclaim disk space. #Databases #Security #System Administration #Tips & Tricks #Caché #InterSystems IRIS #InterSystems IRIS for Health 1 4 0 223
Question Sylvain Guilbaud · Aug 23, 2023 Does LOAD DATA provide in a future version an option to indicate a date/datetime format other than 'yyyy-mm-dd hh:mm:ss'? Is it planned that LOAD DATA takes into account several DATE/DATETIME formats with, for example, a parameter indicating the format used in the source data? example : LOAD DATA .../... USING { "from": { "file": { "dateformat": "DD/MM/YYYY" } } } #Data Import and Export #JDBC #SQL #Tools #InterSystems IRIS #InterSystems IRIS for Health 2 3 0 209
Article Sylvain Guilbaud · Apr 20, 2022 4m read Method to recompile classes and routines after a major upgrade During a major version upgrade it is advisable to recompile the classes and routines of all your namespaces (see Major Version Post-Installation Tasks). #Best Practices #System Administration #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 11 3 1 1.2K
Article Sylvain Guilbaud · Apr 19, 2022 2m read How to manage in a CI/CD pipeline an InterSystems API Manager (IAM aka Kong GATEWAY) configuration ? Kong provides an open source configuration management tool (written in Go), called decK (which stands for declarative Kong) #InterSystems API Manager (IAM) #Tips & Tricks #InterSystems IRIS #InterSystems IRIS for Health #Other 2 0 0 679
Question Sylvain Guilbaud · Feb 25, 2022 How to configure SAM to monitor containers or local instances ? Monitoring IRIS through SAM (sam:1.0.0.115) While I've used to make it work in the past, I'm not able any more to fix the already faced issue : "State: Unreachable" Despite all the ip-addresses attempts (or hostname = host.docker.internal) and while "/api/monitor/metrics" is running well... Could someone provide good practices to make it work cleanly ? #System Alerting and Monitoring (SAM) #InterSystems IRIS 1 13 0 450
Discussion Sylvain Guilbaud · Feb 21, 2022 How to efficiently store historical data, similar to current data, without mixing physical storage ? Let's consider you would like to efficiently store your historical data in a similar structure than the one used for your current data, but without sharing the same physical storage (ie : not in the same global). What is the most efficient way to do it ? Below a simple class of your current data : #Data Model #Globals #Caché #InterSystems IRIS 3 9 0 404
Announcement Sylvain Guilbaud · Feb 20, 2022 Happy Birthday Python Python is 31 today ; let’s celebrate it 🎂 And special thanks to Guido van Rossum #Embedded Python #InterSystems IRIS 10 1 0 228
Article Sylvain Guilbaud · Oct 19, 2016 7m read How to replace the CACHE.DAT of a mirrored database (i.e: when you need to upgrade a software version) Context: mirrored configuration with one primary member and one async member (without failover/backup member) Purpose: replace the CACHE.DAT of a mirrored database on the primary member. Steps to follow: #Caché #Code Snippet #Databases #System Administration #Mirroring #Tips & Tricks 6 3 0 989
Article Sylvain Guilbaud · Oct 6, 2016 3m read How to dismount/mount a database programmatically to dismount/mount a database, use Dismount() and Mount() methods in SYS.Database class available in %SYS namespace.NB: the database ID is its Directory You'll find some examples of how to dismount/mount and check if a database is mounted (Mounted=1) or not (Mounted=0), and quickly see all the attributes of a database (via zwrite) #Beginner #Code Snippet #Databases #Tips & Tricks #Caché 3 2 1 2.6K
Article Sylvain Guilbaud · Oct 4, 2016 6m read How to add a parameter to a class programmatically This sample class will add parameter DSINTERVAL to each class containing the parameter DSTIME To execute it from a Terminal : #Caché #Code Snippet #Terminal #Tips & Tricks 2 6 1 1K
Article Sylvain Guilbaud · Feb 24, 2016 1m read Script sample for running an external Caché / Ensemble backup on Windows (using ##Class(Backup.General).ExternalFreeze() / ExternalThaw()) C:\data\backup.bat :C:\InterSystems\Ensemble\bin\cache -s"C:\InterSystems\Ensemble\Mgr" -U%%SYS ##Class(Backup.General).ExternalFreeze() <C:\data\login.scr echo %ERRORLEVEL%rem note that we need to check errorlevel from highest to lowest here....if errorlevel 5 goto OK #Caché #Code Snippet #System Administration #Backup 2 0 0 1.8K
Question Sylvain Guilbaud · Feb 17, 2016 How can we customize the Excel content exported from the Analyzer/Dashboard ? A customer needs to add lines in the Excel sheet before the MDX resultset content.Is there a more elegant/convenient way than modifying %DeepSee.UI.MDXExcel methods ?Thanks in advance.Sylvain #InterSystems IRIS BI (DeepSee) #MDX 1 4 0 459
Question Sylvain Guilbaud · Dec 2, 2015 DeepSee DataConnector references (external databases sources) I’m interested in our DeepSee references who define cubes with external databases. #InterSystems IRIS BI (DeepSee) 1 2 0 251