Author |
Message |
Topic: Read SYSLOG |
rsantosh
Replies: 4
Views: 3697
|
Forum: Job Control Language(JCL) Posted: Wed Mar 31, 2021 11:20 am Subject: Read SYSLOG |
Hi Kolusu,
Yes, I am trying to see how to use ISFLOGSTARTTIME/ISFLOGSTOPTIME.
Also, I am not dumping all the data but only records with $HASP373 & $HASP395. This will reduce I/O.
Regards ... |
Topic: Read SYSLOG |
rsantosh
Replies: 4
Views: 3697
|
Forum: Job Control Language(JCL) Posted: Wed Mar 31, 2021 10:32 am Subject: Read SYSLOG |
Hi Kolusu,
Thank you. We do offload the syslog but time interval is quiet large. I need to get the data every 15 min or so.
I found that we can use SDSF's ISFLOG command in REXX to get the data ... |
Topic: Read SYSLOG |
rsantosh
Replies: 4
Views: 3697
|
Forum: Job Control Language(JCL) Posted: Tue Mar 30, 2021 11:29 am Subject: Read SYSLOG |
Hello,
Is there any utility or way to read the SYSLOG?
We need to extract job info like start time end time and RC (different jobs) after every x minutes. We tried using ISFAFD but that limits ... |
Topic: COBOL V6.1 Vs 6.2 NUMCHECK |
rsantosh
Replies: 2
Views: 4068
|
Forum: Application Programming Posted: Mon Mar 22, 2021 11:57 pm Subject: COBOL V6.1 Vs 6.2 NUMCHECK |
Hi Kolusu,
Thank you.
Regards,
Santosh |
Topic: COBOL V6.1 Vs 6.2 NUMCHECK |
rsantosh
Replies: 2
Views: 4068
|
Forum: Application Programming Posted: Mon Mar 22, 2021 4:43 am Subject: COBOL V6.1 Vs 6.2 NUMCHECK |
Hello,
Following statement running fine with COBOL v6.1 but failing with NUMCHECK with COBOL v6.2. Program we compiled with 6.1 is already in production. Below snippet is having the same data type ... |
Topic: DAYS vs YEAR return different date |
rsantosh
Replies: 5
Views: 3650
|
Forum: Database Posted: Tue Jan 05, 2021 2:04 am Subject: DAYS vs YEAR return different date |
Hi Nic/Chuck,
Yes, after Nic providing the input I got the clarification.
SELECT DATE('2020-02-29') - 1 YEAR FROM SYSIBM.SYSDUMMY1
gives SQLCODE 0 with warning indicating End-of-Month adjustm ... |
Topic: DAYS vs YEAR return different date |
rsantosh
Replies: 5
Views: 3650
|
Forum: Database Posted: Mon Jan 04, 2021 8:07 am Subject: DAYS vs YEAR return different date |
Hi Nic,
Thank you. It helped.
Regards,
Santosh |
Topic: DAYS vs YEAR return different date |
rsantosh
Replies: 5
Views: 3650
|
Forum: Database Posted: Mon Jan 04, 2021 6:50 am Subject: DAYS vs YEAR return different date |
Hello,
Subtracting DAYS and YEAR resulting in different date.
What can be the explanation?
SELECT DATE('2021-02-28') - 365 DAYS
FROM SYSIBM.SUSDUMMY1
Result : 2020-02-29
... |
Topic: Cobol Program daily execution count |
rsantosh
Replies: 5
Views: 4221
|
Forum: Application Programming Posted: Wed Dec 16, 2020 7:00 am Subject: Cobol Program daily execution count |
Thank you Kolusu.
Regards,
Santosh |
Topic: Cobol Program daily execution count |
rsantosh
Replies: 5
Views: 4221
|
Forum: Application Programming Posted: Wed Dec 09, 2020 8:07 am Subject: Cobol Program daily execution count |
Hello Kolusu,
Is there any way to find out if sub programs are getting executed? Recently we archived one subprogram thinking it is obsolete(we searched for the program name in the source library) ... |
Topic: EIBCALEN ON SIZE ERROR with COBOL V6 |
rsantosh
Replies: 2
Views: 5500
|
Forum: CICS and Middleware Posted: Wed Nov 18, 2020 11:39 pm Subject: EIBCALEN ON SIZE ERROR with COBOL V6 |
Hi Kolusu,
Thank you. In our shop default is TRUNC(OPT). So the only option we are left with is overriding the NUMCHECK.
Regards,
Santosh |
Topic: EIBCALEN ON SIZE ERROR with COBOL V6 |
rsantosh
Replies: 2
Views: 5500
|
Forum: CICS and Middleware Posted: Wed Nov 18, 2020 8:39 am Subject: EIBCALEN ON SIZE ERROR with COBOL V6 |
Hello,
COBOl V6 has introduced a new compiler option NUMCHECK(BIN) which is giving ON SIZE ERROR for EIBCALEN because it is defined as PIC S9(4) COMP.
IF EIBCALEN NOT = LENGTH DFHCOMMAREA
W ... |
Topic: Same query different CPU time with different host value |
rsantosh
Replies: 7
Views: 4834
|
Forum: Database Posted: Wed Jun 24, 2020 12:02 pm Subject: Same query different CPU time with different host value |
What are the cons of using bind option REOPT(ALWAYS)? Is it advisable to use this option?
Regards,
Santosh |
Topic: Same query different CPU time with different host value |
rsantosh
Replies: 7
Views: 4834
|
Forum: Database Posted: Tue Jun 23, 2020 11:50 am Subject: Same query different CPU time with different host value |
Just to add, the table has 80M rows as of today and everyday 20K+ rows get added to it. Would it be better to use REOPT option to get the access determined during run time?
Regards,Santosh |
Topic: Same query different CPU time with different host value |
rsantosh
Replies: 7
Views: 4834
|
Forum: Database Posted: Tue Jun 23, 2020 11:34 am Subject: Same query different CPU time with different host value |
Hi Chuck,
Thank you for the detailed info.
Today when I ran EXPLAIN on the query I saw it using same INDEX with both "LIKE" and "=(equal)" unlike the other day.
LIKE :HV1 ... |
|