MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 10 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Releasing the Virtual storage used by Load module in Rexx
TheGodfather

Replies: 3
Views: 2567

PostForum: TSO and ISPF   Posted: Fri Mar 09, 2007 12:31 am   Subject: TSOEXEC solved the issue.
Thanks Kolusu! Smile

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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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. Smile 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

PostForum: 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

PostForum: 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

PostForum: 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. Smile
  Topic: SQLCODE -104 from UPDATE query which runs everyday
TheGodfather

Replies: 9
Views: 6615

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group