Caché database monitoring scripts on Windows

Question

Question

Bharath Nunepalli · Aug 20, 2019

#Databases #Journaling #Monitoring #Caché

I'm a DBA and support Caché databases on AIX. I coded shell scripts for monitoring journaling status, databases size, license end date.

We recently got a new instance of Caché on Windows. I'm just curious to know whether anyone coded database monitoring scripts on Windows using PowerShell or any other scripting language.

If yes, please share the details.

Thanks & Regards,

Bharath Nunepalli.

Discussion (3)1

Log in or sign up to continue

David Underhill · Aug 21, 2019

We coded all the journal and data file monitoring in Cache itself and just had simple checks on the running status and alerts.log externally, keeps it fairly platform independent.

On windows we used vbscript to check service status and log contents.

0 0

score 0 · Answer 1 · 2019-08-21T09:49:01-04:00

David,

Thanks for the response.

Main reason for coding the scripts in Shell was that we want them to run even when Caché instance is down.

When you say in Caché itself, do you mean like a task in Task Manager?

Also, how did you schedule the vbscript scripts?

score 0 · Answer 2 · 2019-08-21T11:23:45-04:00

Yes, when Cache was up we had a class that would run in Cache Task Manager which would alert on issues and also log metrics.

In Windows we had a script that ran in Scheduled Tasks which would alert if the Cache status was invalid (i.e. not "running" or "down") using "ccontrol list nodisplay > outputfile" or if alerts.log existed.