Does Caché or IRIS have Data Masking capability natively to Test/Dev/Report environment, like other databases?

Does anyone know if there is a table or query to get the Application Error Log (^ERRORS) by SQL?

Does Caché have any features similar to PostgreSQL 'WITH RECURSIVE'? Something that allows recursion in SQL.
 

I have a FullBackup.cbk file generated by Caché Backup Online. This file has many databases.
Is there a Caché feature to restore only one database?
I've tried EXTSELCT^DBREST(), but this routine runs through all databases (skipping the unselected). This process becomes slow, lasting 1 day to finalize the process.

We recently registered unavailability of the Web service in some moments. The application goes offline.

Analyzing the IIS logs and logs in "C:\Windows\System32\LogFiles\HTTPERR" I found nothing relevant.

Analyzing the CSP Gateway logs I noticed the following behavior when unavailability occurs:

>>> Time: Tue Mar 19 09:35:12 2019; RT Build: 1701.1606aa (win64/iis); Log-Level: 0; Gateway-PID: 3536; Gateway-TID: 6020
    Initialization
    The CSP Gateway module 'C:\Inetpub\CSPGateway\CSPms.

Can I apply a custom resource to a Management Portal page through code, using the method or global? The documentation only shows the manual mode: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCAS_rsrcs#GCAS_C181701

Or export the settings already saved.

Hi

I want to get the total amount of time that a process is active or the timestamp that it was created/started.

I tried the %SYS.ProcessQuery class, but I did not find any related information.

Is there any way to get this information from a process?

I'm using Caché 2017.

Hi community,
I need to monitor Caché Intersystems with some custom indicators.
I started customizing the SNMP Mib. But I've been in a Zabbix event, all speakers use ODBC to monitor their database, Oracle, MySQL, PostgreSQL ...
What is the best way? Use ODBC or SNMP Custom Mib?
What are you guys using?

Hi,

Can I get "Window Size" from terminal? By command line.

Terminal > Edit > Window Size

I already tried to use 'do CURRENT^%IS', but without success. It does not return the change, for example, when the column is 132.

Is there any routine or method for this?