Question Sylvain Guilbaud · Aug 30, 2023 How to activate all AUDIT system events? When installing IRIS, all the system AUDIT events are not enabled. What is the fastest way to activate all events? System > Security Management > System Audit Events #Monitoring #Security #System Administration #InterSystems IRIS #InterSystems IRIS for Health 3 1 2 228
Question Sylvain Guilbaud · Aug 28, 2023 From DBeaver, how to filter system schemas (ie: starting with "%") ? I'm looking for an efficient way in DBeaver to filter system tables (ex: belonging to a schema starting with "%"). By using a user with the %All role, DBeaver shows us a long list of system schemas, which forces us to go down the list before accessing the user tables. #JDBC #SQL #InterSystems IRIS #InterSystems IRIS for Health 1 8 0 1.3K
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 232
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 211
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.3K
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 693
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 459
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 419
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 233
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 1K
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.7K
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.9K
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 462
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 253