Author |
Message |
Topic: Releasing the Virtual storage used by Load module in Rexx |
TheGodfather
Replies: 3
Views: 2567
|
Forum: TSO and ISPF Posted: Fri Mar 09, 2007 12:31 am Subject: TSOEXEC solved the issue. |
Thanks Kolusu!
Suresh was able to solve the issue by calling the program module by using the TSOEXEC command. He told me he got answer from another forum.
Appreciate your time! |
Topic: Releasing the Virtual storage used by Load module in Rexx |
TheGodfather
Replies: 3
Views: 2567
|
Forum: TSO and ISPF Posted: Thu Mar 08, 2007 12:03 am Subject: Releasing the Virtual storage used by Load module in Rexx |
Hi All,
Our REXX programs calls a load module multiple times based on the input records. This processes running fine when no of records are less than 5 ( 5 times program module would be called - we ... |
Topic: Can we use a COBOL-DB2 program in exit routine of SORT? |
TheGodfather
Replies: 2
Views: 2348
|
Forum: Job Control Language(JCL) Posted: Tue Oct 31, 2006 10:46 am Subject: Can we use a COBOL-DB2 program in exit routine of SORT? |
Hi Kolusu,
Thanks for the quick response.
I would like to make the validation with a generic program so that it can be reused. So I was hoping for such a solution.
As of now, we are going wit ... |
Topic: Can we use a COBOL-DB2 program in exit routine of SORT? |
TheGodfather
Replies: 2
Views: 2348
|
Forum: Job Control Language(JCL) Posted: Tue Oct 31, 2006 6:01 am Subject: Can we use a COBOL-DB2 program in exit routine of SORT? |
I am trying to find out if we can use a COBOL-DB2 program in one of the exit routines available in SORT. If so, how will i give plan details?
I checked in the manuals, but the MODS statement is onl ... |
Topic: SQLCODE -104 from UPDATE query which runs everyday |
TheGodfather
Replies: 9
Views: 6615
|
Forum: Database Posted: Mon Mar 20, 2006 2:59 am Subject: SQLCODE -104 from UPDATE query which runs everyday |
Hi Suresh,
The column is not NULLABLE. I think this is taken care of by the preceding step and setting the condition code.
All,
Our DBA's found the issue. Our production regions use DB2 ver 7. ... |
Topic: SQLCODE -104 from UPDATE query which runs everyday |
TheGodfather
Replies: 9
Views: 6615
|
Forum: Database Posted: Fri Mar 17, 2006 11:19 am Subject: SQLCODE -104 from UPDATE query which runs everyday |
I was thinking that this is the one which provides the dump information. I am not sure about this, this was my assumption. The name is given as
//XRES EXEC PGM=XMR&DB2ID.
So the name ... |
Topic: SQLCODE -104 from UPDATE query which runs everyday |
TheGodfather
Replies: 9
Views: 6615
|
Forum: Database Posted: Fri Mar 17, 2006 4:25 am Subject: SQLCODE -104 from UPDATE query which runs everyday |
Please let me know if you need the full JCL. I have given the exact query as well to make sure that we are not missing anything here.
The job abended again and the restart was also not successful. ... |
Topic: SQLCODE -104 from UPDATE query which runs everyday |
TheGodfather
Replies: 9
Views: 6615
|
Forum: Database Posted: Fri Mar 17, 2006 4:17 am Subject: SQLCODE -104 from UPDATE query which runs everyday |
Thanks for the response Bithead! The JCL step is given below.
//IKJEFT01 EXEC PGM=IKJEFT01
//STEPLIB INCLUDE MEMBER=UTSS01P ... |
Topic: SQLCODE -104 from UPDATE query which runs everyday |
TheGodfather
Replies: 9
Views: 6615
|
Forum: Database Posted: Thu Mar 16, 2006 1:39 pm Subject: SQLCODE -104 from UPDATE query which runs everyday |
Thanks Kolusu! But that is the first step we tried when we encountered the abend.
The interesting point is this is running in production for about 2 weeks now and ran fine when restarted.  |
Topic: SQLCODE -104 from UPDATE query which runs everyday |
TheGodfather
Replies: 9
Views: 6615
|
Forum: Database Posted: Thu Mar 16, 2006 9:49 am Subject: SQLCODE -104 from UPDATE query which runs everyday |
One of the production jobs abended with SQLCODE -104. This ran fine when restarted. This is the first time this is happening. There is no characters in columns 73-80.
UPDATE SQLREGN.EMEDTMP1 EMT ... |
|