Requesting additional modify command to return database status in syslog

[BRUCE LOGAN]

I love the F SARSTC, DISPLAY command that shows the INIT parameters in the SYSLOG (or in my case OPSLOG).  I would really like to see similar commands that can be entered from a console to query the data base status.  This is currently done manually by logging into View and entering the status command  for each instance of VIEW - over 20.  But by querying View from the console, we could automate the process and generate email alerts or perform other actions as needed.  This would be beneficial to our modernization efforts going forward and would be a great product enhancement.  What do I have to do in order for this to happen?
Thanks.

[Lenn Thompson]

@BRUCE LOGAN: Good morning. I'd suggest that you create and idea in our Ideas Program (https://community.broadcom.com/ideation/allideas) so that other users of the product can comment and vote on it. The Ideas Program is an important way that our product teams prioritize development efforts.

Remember to assign your idea to the View/Deliver category! ​

[Ed Blazejewski]

Hi Bruce, 

You can create JCL and run the SARDBASE program, name the database you want to use, and then use the STATUS or STATUS FULL control statement. This will create a lot of data which you can then scan for any issues. You can run this JCL via a production scheduler if you like.

https://techdocs.broadcom.com/us/en/ca-mainframe-software/traditional-management/ca-view/14-0/reference/database-utilities/maintain-the-database-sardbase/status.html

Does this help?

Ed

[ERIC Foecking]

I would add that it would be hugely beneficial for our OPS team to be able to see actually numbers on the console when we have FULL database issues.  I agree with Bruce the automation potential, taking that output from the log, would open doors on tracking usage at intervals and keeping dynamic and regular updates on database usage.  We currently support nearly 100 databases across 30 JES complexes.

[BRUCE LOGAN]

Hi Ed,

Thanks for your response.  The STATUS control statement is handy but not what I had in mind when it comes to automation and reporting for multiple data base instances.  The idea is to the have the some or all of the output produced by the control statement sent to the syslog/opslog, so that an OPS/MVS rule could parse and send email alerts when needed.  It was my understanding that this had been approved and was in development.  Has that status changed?

Bruce

[ERIC Foecking]

For instance, our A/O team has taken the SARDBI23 message posted when either component has exceeded the DBTHRESH thresholds.  They check for the INDEX keyword in the message and will email our View Admins an update that an INDEX is filling and space may need to be added.  To expand on what Bruce may be interested in, over the years, I had looked at setting up a batch process to run every hour and take the percentage used to develop usage trend where we could determine high water marks or critical times during a day/week/month/quarter that may require adjusting our space.  It was a project, for me, that was relegated to high priorities.  Being able to trap STATUS output in SYSLOG/OPSLOG would open doors to other alternatives in capturing that kind of statistic.