Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-29 Thread Jon Perryman
> On Thursday, July 27, 2023 at 05:25:49 AM PDT, Jason Cai > wrote: > The first question is about how to monitor and alert the system issues. Hi Jason, I don't think anyone analyzes messages on a daily/weekly/monthly basis because it is impractical. The majority of the thousands of unique me

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Jason Cai
Dear Max, Thank you very much for your effort and help to provide me with a complete solution for my problem using SORT. That is exactly what I needed. I appreciate your expertise and generosity in sharing your sample JCL. It was very helpful and clear. I will use it as a reference and tailor i

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Jason Cai
/Software Interlock From: IBM Mainframe Discussion List on behalf of Kevin Mckenzie Date: Thursday, July 27, 2023 at 12:12 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: Inquiry about extracting and counting msgid from operlog using sort program Hi, Jason. If all you’re looking to do is

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Kevin Mckenzie
Date: Thursday, July 27, 2023 at 3:07 AM To: IBM-MAIN@LISTSERV.UA.EDU , Kevin Mckenzie Cc: Jason Cai Subject: [EXTERNAL] Re: Inquiry about extracting and counting msgid from operlog using sort program Dear Massimo and Kolusu, Thank you for your help. I got the results I wanted. The results are as

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Kevin Mckenzie
, 2023 at 3:07 AM To: IBM-MAIN@LISTSERV.UA.EDU , Kevin Mckenzie Cc: Jason Cai Subject: [EXTERNAL] Re: Inquiry about extracting and counting msgid from operlog using sort program Dear Massimo and Kolusu, Thank you for your help. I got the results I wanted. The results are as follows. MSGID

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Sri h Kolusu
>> Can dfsort delete the last word if the first position is M and the last word >> is a number? Jason, Quite simple, you need to show me an example, the length of the last word and the DCB properties of the input file and I can show you how to do it. Thanks, Kolusu DFSORT Development IBM Corpo

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Massimo Biancucci
Jason, for you first question I could say experience. All my customer sites have different "hot messages" to look at. Others are only warning, others (the most of) are simply ignored. I cannot simply share them. I could give you some "generic hints" like: - JES Spool over x% then add a spool v

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Jason Cai
Dear Max I am writing to you regarding two questions that I have. The first question is about how to monitor and alert the system issues. We can monitor most of the issues and send alerts to our phones. However, when we cannot provide a complete list of msgids to the monitoring system, some cr

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Massimo Biancucci
Jason, as usually, it depends. About Operlog analysis, it depends on the response-time you need. At different customer sites I use automation product (BMC, IBM, Broadcom) in order to catch specific messages and react asap with specific actions or simply sending SMS/Mail. Some others use external

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-27 Thread Jason Cai
Dear Massimo and Kolusu, Thank you for your help. I got the results I wanted. The results are as follows. MSGID NUMREC $HASP000 20 $HASP001 10 .. >DISTINCT COUNT: 530 I also appreciate Kevin McKenzie's reply. Th

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-26 Thread Sri h Kolusu
≫ INREC PARSE=(%00=(ABSPOS=64,ENDBEFR=C' ',FIXLEN=15)), Massimo, Jason wants to count the MSGID , not the message TEXT which starts at position 58, but your parse is starting with ABSPOS=64. Thanks, Kolusu -- For IBM-MAIN s

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-26 Thread Massimo Biancucci
Jason, you can try this: OPTION VLSCMP INCLUDE COND=(6,1,SS,EQ,C'NXWM',AND, 7,1,CH,EQ,C' ',AND, 64,1,SS,EQ,C'ABCDEFGHIJKLMNOPQRSTUVWXYZ') INREC PARSE=(%00=(ABSPOS=64,ENDBEFR=C' ',FIXLEN=15)), BUILD=(1,4,%00,X'0001') SORT FIELDS=(5,15,BI,A) SUM FIELDS=(20,4,BI) OUTFIL FNAMES=SORTOUT,VTOF,

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-26 Thread Sri h Kolusu
>> But I do not know how to count the number of occurrences of each msgid and >> eliminate duplicates. Jason, Assuming the msgid is at position 58 for a length of 7 bytes, you can use the following control cards that would give you the desired results. //SYSINDD * INCLUDE COND=((58,7,SS,

Re: Inquiry about extracting and counting msgid from operlog using sort program

2023-07-26 Thread Kevin Mckenzie
List on behalf of Jason Cai Date: Wednesday, July 26, 2023 at 4:19 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Inquiry about extracting and counting msgid from operlog using sort program Dear All, I am writing to inquire about how to use the sort program on the mainframe to extract

Inquiry about extracting and counting msgid from operlog using sort program

2023-07-26 Thread Jason Cai
Dear All, I am writing to inquire about how to use the sort program on the mainframe to extract and count msgid from a day's operlog. I would appreciate your guidance and advice on this matter. Msgid is a keyword that identifies system messages. It usually consists of 7 letters and a number,