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 

SOC4 Abend

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
abracadabra
Beginner


Joined: 02 Sep 2003
Posts: 101
Topics: 55
Location: India

PostPosted: Tue Oct 18, 2005 10:20 am    Post subject: SOC4 Abend Reply with quote

Hi,

I have a cobol batch program A which is calling a DB2 batch program B. The job executes program A and is abending with a SOC4. The message is 'I/O instruction issued against DDNAME DSNPARM which is missing from JCL'

The abend is at the location CALL 'DSNHLI' USING SQL-PLIST3

The DB2CNTRL is passing the following parms which I am assuming is the DSN Type and the plan - DSN E1111TVB 0001 0001

It looks like some files are missing. Is my assumption correct?

Thanks
_________________
Cheers!
Back to top
View user's profile Send private message
SureshKumar
Intermediate


Joined: 23 Jan 2003
Posts: 211
Topics: 21

PostPosted: Tue Oct 18, 2005 11:18 am    Post subject: Reply with quote

abracadabra,
Is program A Cobol/DB2? is it being executed thru IKJEFT* in the JCL? if not search for how to execute a DB2 program from a non DB2 program. This has-been discussed many times. Thanks
Back to top
View user's profile Send private message
a_seshu
Beginner


Joined: 30 Sep 2004
Posts: 16
Topics: 4
Location: Chennai

PostPosted: Tue Oct 25, 2005 6:14 am    Post subject: Reply with quote

Hi abracadabra...

when ever any db2 program is executing in batch, it has to either issue a call attach facility or it has to execute under the terminal monitor program (TMP) (IKJEFT01), specifying the system, plan and the load module. Normally people think that this is only for a db2 program running in batch.

But the fact is that even if a non-db2 program is running and it is calling a db2 batch program, the non-db2 calling program should be executed under the TMP. This is how the called db2 program will know what database system to connect to and what plan to use.

Thanks,
Seshu.
_________________
I dont think I would ever stop learning. - Seshu.
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group