System administration refers to the management of one or more hardware and software systems.
Hi everyone!
We have many severs (DEV, QA and LIVE) besides many other slave servers (about 133) that are running Caché instances. Before writing this utility myself, I would like to know if anyone has done it before. We need to change the SuperUser password and do other credential setups like this on all of these servers and we don't want to do it one by one.
Good day InterSystems Community,
Could someone share ready to use Zabbix monitoring templates for InterSystems Cache? SNMP OIDs, etc..
During a Caché system management training course today we discussed structural database integrity (a.k.a. physical integrity) and the tools InterSystems provides for checking integrity and fixing problems.
Hello,
There is a programatic way to Export/Import the Ensemble System Default Settings?
I know you can use the Production Export Screen and add the "Deployable settings" but I am looking for something more quick and flexible
Thanks
Today I helped someone solve a mystery. He had been trying to use the -U namespace argument of a csession command to specify the namespace in which to run a particular routine, and was puzzled when the routine could not be found.
In my previous article, I gave an example of how to get the own image with InterSystems Caché. Now it's time to launch a project with container.
Since most of our customers moved to Caché 2015.1, some admins became abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:
| CPUPct | job_type | CPU usage (percent) by all processes of the listed job type in aggregate |
What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert?
Checking the latest docs showed that the description of
Hi All
I'm looking for some field experiences, lessons learned, or actual deployed solutions to the problem of replicating non-CACHE.DAT data in a mirrored Cache environment.
Environment:
There are a number of different data types that we're looking at mirroring, and a number of identified solutions. The two main types of data to be mirrored outside of Cache mirroring are:
hi
I want to online backup one Caché database by windows bat, I find some article from the online documentation about terminal script and the ^DBACK tool and External Entry Points for ^DBACK, so I can invoke the External Entry Points for ^DBACK from terminal script like this: send: Do BACKUP^DBACK<CR>
Is there other better way for backup database from bat/script?
Thanks
Hi Everyone,
Link to webinar recording: https://learning.intersystems.com/course/view.php?id=623
Thank you for your interest in this webinar!
Please submit questions about the content of the webinar as comments below this article.
The webinar covers two topics: monitoring message activity and volume and monitoring disk space. I summarize and motivate the topics in the following two sections. The information in this webinar and post applies to the Ensemble, Health Connect, and HealthShare products. For simplicity, I am only going to refer to Ensemble in this post.
1) Monitoring Message Activity and
Hello everyone.
I'm new to Caché.
I would like to know how I can connect my PHP application to the intersystems database.
Is it the same as MySQL?
Need help.
Thank you
Hi All -
Our environment has multiple instances of HealthShare installed and most are on separate VMs/servers. Does anyone have any ideas on how to efficiently manage user accounts across all of these multiple instances of HealthShare? As you can imagine, creating 10 separate Cache accounts on each instance during onboarding of new associates is cumbersome and tedious as is disabling them. We have yet to integrate with AD but we do have a Cyberark initiative under way but it is in the very early stages.
Additionally - I would eventually like to do some reporting based off of specific roles
A few years ago InterSystems announced a tool to help Caché system managers on sites with a large number of Caché instances. It was called Enterprise Manager.
When I recently searched for information about it I didn't have much success.
Please let me know the Configuration management tools that can be integrated with InterSystems....
How to integrate the Config management tool with InterSystems.. Please let know the steps
Have you ever thought about leveraging IIS (Internet Information Services for Windows) to improve performance and security for your Caché web applications?
Are you worried about the complexity of properly setting up IIS?
See the webinar Configuring a Web Server presented by @Kyle Baxter, InterSystems Senior Support Specialist. Learn how to install IIS, set up it up to work with the CSP Gateway, and configure the CSP Gateway to talk to Caché.
If you have not subscribed to our Developer Community YouTube Channel yet, let's get started right now.
Enjoy!
Hi All,
We can sent the file to FTP server using CMD prompt.
When trying send file using cache FTP. it automatically logged out.
While cache FTP access (read/write) FTP server it automatically logged out.
CODE:
S ftp=##class(%Net.FtpSession).%New()
S Server="test"
S Username="test"
S Password="test"
I $L(Server)=0||($L(Username)=0)||($L(Password)=0) S Status="Invalid Credentials" Q Status
S ConnSt=ftp.Connect(Server,Username,Password)
I 'ConnSt S Status="Couldn't Estabilish the FTP connection" Q Status
;
;Linking the file
D
I only recently noticed the presence of a local database named CACHE alongside the more familiar CACHESYS, CACHELIB, CACHETEMP and CACHEAUDIT.
A bit of digging through the documentation archive led me to conclude that the CACHE database arrived in 2010.2, where the release notes say:
Note the lack of an accent on the words I have highlighted.
The above documentation is incorrect when it says "this database is mounted as read-only".In fact it is mounted RW.But the %DB_CACHE security resource that controls access to it only grants R as its public permission.
Hi!
Sometimes when I have Zen page in a browser (e.g. Management Portal page) and when my Internet connection interrupts, I see the alert window on the page, something like this screenshot:
Is there any setting for the CSP web app to prevent this alerts from popping up?
Hello,
I have been involved with using terminal scripts lately (I use GE Centricity Business), that usually do not go beyond 'send:' and 'wait for:' commands. Notwithstanding, I have been stuck with the message boxes since the script recorder does not record over this whenever I need to click 'Yes' in a given message box prompt which aggressively stops my scripts/macros from continuing. I know that this commands are labeled 'Extended Escape Sequences', but I have been looking all over at the Intersystems document repository with no luck in finding anything of the sort.
During startup a Caché/Ensemble/HealthShare instance must consult a parameter file to get some information it needs at the early stages of startup. By default it uses the file called cache.cpf, but by adding an extra argument to the ccontrol start command you can make it use an alternative file.
Usually I recommend to set the global buffer (GB) as large as possible in order to maintain in memory more globals as possible. I don't know if this is a standard recommendation, but I want to discuss what should be the best buffer size for a Ensemble instance that only process messages.
I mean, if the instance only runs productions that pass messages then the 90% of the global access is used for persist the messages.
Hello,
I have a problem with an Ensemble instance on Windows to access to a network shared directory. Ensemble service (services.msc) is executed with a user which has access to this network shared directory :
- When I try to copy or access files from a terminal ==> this is OK : the command w ##class(%SYS.ProcessQuery).%OpenId($Job).OSUserName returns the user defined in Ensemble service logon screen.
- When I try to copy or access files from a service, process or operation item of the running Production ==> this is KO and the command ##class(%SYS.ProcessQuery).%OpenId($Job).OSUserName returns
In this post, I am going to detail how to set up a mirror using SSL, including generating the certificates and keys via the Public Key Infrastructure built in to Caché.The goal of this is to take you from new installations to a working mirror with SSL, including a primary, backup, and DR async member, along with a mirrored database.
Hi All,
We using cache 5.02.We have some problem regarding license usage.
Currently, we have an application running in one namespace ("Database B") that has globals and routines mapped to another database ("Database A"). After enforcing clean up on Database A, we found that 90% of the disk is free. We would like to compact Database A and release the unused space. However, we are running OpenVMS, which seems to be the issue.
For databases consisting of only globals, we are able to use ^GBLOCKCOPY; however, we need to ensure that the routines and mappings are also copied.
What would be the best recommended way to do this?
Hy.
Is there a way to migrate MySql db to Cache (like export from MySql and import to Cache - not just the data, but the properties of the table too)?
Thank you.
I have been asked to assist in the planning of the a new server for our database, which we will be changing operating systems from OpenVMS to Linux (RedHat distribution). However, its difficult to find material regarding what would be recommended, which is likely due to the database being proprietary.
In looking at the information provided below and hoping to decrease processing time, would anyone be able to recommend type of configuration we should have for the new Linux server? Please feel free to ask any clarifying questions.
The current server is running with the following hardware
We've been noticing that we're getting this (https://community.intersystems.com/post/cach%C3%A9-sql-error-odbc) error more frequently and having to constantly purge cached queries in order to resolve it. Is there a way to avoid the issue in the first place?
thanks!
Hi All, When i try to run the CSP from Studio it shows "Server Availability Error" and management portal and documents also throw a same error.how to recover it.
We know there are numerous ways to backup cache/ensemble with VMware, but we are not in a state to do that and can't do shadowing because the lack of resources. Anyways how can i backup cache to a drive mounted as network share.