1
Windows Client / Re: Automated Report from OnDemand Client
« on: March 18, 2020, 11:27:31 AM »
Thanks Greg and Justin !! Will take a look.
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
2
Windows Client / Automated Report from OnDemand Client
« 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.
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.
3
Workshops/webinars, and the like / Re: Webinar: Migrating ASG/Mobius Solutions to IBM CMOD: A 4 Step Approach
« on: February 26, 2020, 08:32:32 AM »4
Content Navigator / Rolling up reports into one view ?
« on: January 29, 2020, 08:50:57 AM »
Is it possible to present multiple report entries in CMOD as one high level entry which allows the end user to drill down for more detailed information, which would be the actual report.
Here is our issue. It could be that we haven't set up this correctly to begin with ?
We are migrating over to CMOD from another system.
In the old system we captured our mainframe job data and all DD's which produced output(report data) in the following way.
(it was in drill down fashion)
First view at a job level
Sysout ID Jobname Jobid Arch Date Time Loc Lines Pages
JOBABC123 * * * * * * *
JOBABC123 JOBABC123 JOB12345 01/28/2020 08:24 PTAP 381 15
JOBABC123 JOBABC123 JOB12334 01/27/2020 08:23 PTAP 381 15
JOBABC123 JOBABC123 JOB12324 01/26/2020 08:24 PTAP 381 15
JOBABC123 JOBABC123 JOB12222 01/25/2020 08:24 PTAP 381 15
Second view is the more detailed view by viewing one of the jobs (from above)
Sel DDname Stepname Procstep DSID Lines Pages
JESMSGLG JES2 2 31 1
JESJCL JES2 3 83 1
JESYSMSG JES2 4 190 1
SYSPRINT STEP123 105 5 1
SYSPRINT STEP124 107 5 1
SYSPRINT STEP125 109 5 1
Question -
Can this type of layout be done in Content Navigator as well as the CICS client ?
Here is our issue. It could be that we haven't set up this correctly to begin with ?
We are migrating over to CMOD from another system.
In the old system we captured our mainframe job data and all DD's which produced output(report data) in the following way.
(it was in drill down fashion)
First view at a job level
Sysout ID Jobname Jobid Arch Date Time Loc Lines Pages
JOBABC123 * * * * * * *
JOBABC123 JOBABC123 JOB12345 01/28/2020 08:24 PTAP 381 15
JOBABC123 JOBABC123 JOB12334 01/27/2020 08:23 PTAP 381 15
JOBABC123 JOBABC123 JOB12324 01/26/2020 08:24 PTAP 381 15
JOBABC123 JOBABC123 JOB12222 01/25/2020 08:24 PTAP 381 15
Second view is the more detailed view by viewing one of the jobs (from above)
Sel DDname Stepname Procstep DSID Lines Pages
JESMSGLG JES2 2 31 1
JESJCL JES2 3 83 1
JESYSMSG JES2 4 190 1
SYSPRINT STEP123 105 5 1
SYSPRINT STEP124 107 5 1
SYSPRINT STEP125 109 5 1
Question -
Can this type of layout be done in Content Navigator as well as the CICS client ?
5
Other / Identifying data tables
« on: January 07, 2020, 09:06:54 AM »
Is there a way to identify the CMOD data tables when pulling all CMOD tables from SYSIBM.SYSTABLES ?
Here is the generic query I have to pull all the tables ....
SELECT *
--SELECT SUBSTR(DBNAME,1,8) AS DBNAME
-- , RTRIM(SUBSTR(CREATOR,1,5)) CONCAT '.' CONCAT
-- SUBSTR(NAME,1,20) AS TABLE
FROM SYSIBM.SYSTABLES
WHERE DBNAME LIKE 'ARS%' AND TYPE='T'
ORDER BY 1,2
Here is the generic query I have to pull all the tables ....
SELECT *
--SELECT SUBSTR(DBNAME,1,8) AS DBNAME
-- , RTRIM(SUBSTR(CREATOR,1,5)) CONCAT '.' CONCAT
-- SUBSTR(NAME,1,20) AS TABLE
FROM SYSIBM.SYSTABLES
WHERE DBNAME LIKE 'ARS%' AND TYPE='T'
ORDER BY 1,2
6
Other / Identifying Duplicate Reports
« on: December 17, 2019, 11:23:59 AM »
I'm new to using CMOD and have a basic question. Is it possible to identify duplicate reports in CMOD based off of the posting_date thru DB2 queries ? For example, if you have 2 reports with the same posting_date, is there a value in one of the tables to compare.
I see a compression field and not sure if I can use that as sort of a HASH value ? (Our company isn't on the CMOD version that produces HASH values.)
Our company is in the process of migrating reports over to CMOD and at times have duplicated reports for particular days. Just trying to see if there is an easy way to go about this.
thanks !
I see a compression field and not sure if I can use that as sort of a HASH value ? (Our company isn't on the CMOD version that produces HASH values.)
Our company is in the process of migrating reports over to CMOD and at times have duplicated reports for particular days. Just trying to see if there is an easy way to go about this.
thanks !
Pages: [1]