2
« on: March 17, 2020, 01:10:09 PM »
I'm fairly new to using the CMOD suite of tools and was wondering if the following is available ?
Occasionally, I go into the OnDemand Client and go to the System Log Folder. Once in the folder , I'll do a search on MSG_NUM = 13 , to see if there were any DB issues from the last 24 hours.
Question - Is there a way to run this query thru an automated fashion, either thru a windows environment or mainframe job to produce the same report and have that archive as a daily CMOD report ?
The current way our team handles this seems a little clunky. We have a series of sort steps running on our mainframe to first determine the system log table name, as this changes over time. Once determined, we'll query the system log table , extracting the timestamp and and a partial piece of the MSG_NUM(1st 100 bytes).
Using the reporting tool in an automated fashion seems like a much easier option , if available.