IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DSN NOT VALID SUBSYSTEM ID


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
p.bhaskar naidu
Currently Banned

New User


Joined: 25 Jun 2005
Posts: 11

PostPosted: Fri Dec 21, 2007 4:28 pm
Reply with quote

Hi,
When i try to submit a COBOL-DB2 program through a jcl i am getting the following error.
"READY
DSN
DSNE110E DSN NOT VALID SUBSYSTEM ID, COMMAND TERMINATED
READY
RUN PROGRAM(xxxxxxxx)PLAN(xxxxxxxx)
IKJ56709I INVALID DATA SET NAME, PROGRAM (xxxxxxxx)PLAN(xxxxxxxx)"

Can anybody help me in resolving this error?

Regards
Bhaskar
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Fri Dec 21, 2007 4:33 pm
Reply with quote

Quote:
Can anybody help me in resolving this error?


not without seeing what You submitted for execution!
Back to top
View user's profile Send private message
p.bhaskar naidu
Currently Banned

New User


Joined: 25 Jun 2005
Posts: 11

PostPosted: Fri Dec 21, 2007 4:42 pm
Reply with quote

sorry... i am just trying to retirive the data from the db2 table, when i try to run this job, that time i am getting this error.
Back to top
View user's profile Send private message
saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Fri Dec 21, 2007 4:55 pm
Reply with quote

Hi Baskar,
There will be a separated Sub-System Id for your site, Give that Sub-System id after DSN

For Ex:
Code:

 DSN S(DBAA)                               
 RUN PROGRAM (Program Name) PLAN(Plan Name) -     
  LIB('Load library')     
 END         

Note: DBAA is my Sub-System ID.

Correct me if i am wrong.

Thanks
Sai
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Fri Dec 21, 2007 5:02 pm
Reply with quote

Quote:
sorry... i am just trying to retirive the data from the db2 table, when i try to run this job, that time i am getting this error.


If You want us to help You debug the error You must show what You submitted..

It is clear that You want to execute some db2 related program,
but that' s not enough to find out the error
Back to top
View user's profile Send private message
p.bhaskar naidu
Currently Banned

New User


Joined: 25 Jun 2005
Posts: 11

PostPosted: Fri Dec 21, 2007 5:30 pm
Reply with quote

Saiprasadh,
i have tried as you said, but this time i am getting the new error

"READY
DSN S(DBUD)
DSN
RUN PROGRAM(xxxxxxxx) PLAN(xxxxxxxx)
IKJ56641I DSN ENDED DUE TO ERROR+
IKJ56641I SYSTEM ABEND CODE 0C6 REASON CODE 00000006"

Regards
Bhaskar
Back to top
View user's profile Send private message
saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Fri Dec 21, 2007 5:42 pm
Reply with quote

Hi Baskar,

I would be helpful, if you post the JCL you submitted.





Thanks
Sai
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Retrieve IMS SubSystem Name IMS DB/DC 2
No new posts Get name of Subsystem routine is exec... All Other Mainframe Topics 2
No new posts How to connect Remote DB2 subsystem t... CLIST & REXX 15
No new posts Easytrieve Error, NOT A VALID FILE CA Products 2
No new posts Comman to get active DB2 subsystem CLIST & REXX 9
Search our Forums:

Back to Top