Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Error in BMP which has interface between IMS & DB2.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
chowdhrykapildev

New User


Joined: 05 Aug 2009
Posts: 44
Location: Hyderabad

PostPosted: Wed Sep 02, 2009 1:12 pm    Post subject: Error in BMP which has interface between IMS & DB2.
Reply with quote

I'm trying to run a BMP job which tries to copy data from IMS db's to DB2 table. But I'm facing with the below error while doing so:

+DFS0578I - READ SUCCESSFUL FOR DDNAME PROCLIB MEMBER = IMSFDBI6 IMSF
DFS3603I DSNMIN10 RESOURCE FAILURE FOR SUBSYSTEM DBI6 REASON CODE - 090C030 IMSF
IEA995I SYMPTOM DUMP OUTPUT 637
USER COMPLETION CODE=3042 REASON CODE=05090024

I see the below message in the IMS region message log:

DFS552I BATCH REGION I134808B STOPPED ID=00015 TIME=0920
DFSAOII CHECKING SUBSYSTEM STATUS DUE TO USER ABEND U3042
DFSAOII SUBSYS DBI6 IS READY AND HAS STATUS: CONN
DFSAOII SUBSYS DBI5 IS READY AND HAS STATUS: CONN
DFSAOII SUBSYS DBI4 IS READY AND HAS STATUS: CONN
DFSAOII SUBSYS DBI3 IS READY AND HAS STATUS: CONN
DFSAOII SUBSYS EI2M IS READY AND HAS STATUS: CONN
DFSAOIW TRAN MYSINT01 NOT RESTARTED DUE TO POSSIBLE DB2 PLAN ACCESS PROBLEM
DFSAOIW TRAN MYSINT01 SET TO PSTOPPED
DFSAOIW PROG MYS300P RESTARTED

Can anyone help me out in resolving the issue?

Thank in Advance.
Back to top
View user's profile Send private message

chowdhrykapildev

New User


Joined: 05 Aug 2009
Posts: 44
Location: Hyderabad

PostPosted: Wed Sep 02, 2009 1:14 pm    Post subject:
Reply with quote

Continuation.....

DFSAOIW TRAN MYSINT01 NOT RESTARTED DUE TO POSSIBLE DB2 PLAN ACCESS PROBLEM

The above message points out that the transaction MYSINT01 doesn't have access on the DB2 Plan. I have the DB2 plan created. Can I know how can I give access authority for a particular transaction on a DB2 Plan?
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Sep 02, 2009 5:20 pm    Post subject:
Reply with quote

Is this a new program? Did you look up user abend 3042? Did you check the region? It looks like it is stopped.
Back to top
View user's profile Send private message
chowdhrykapildev

New User


Joined: 05 Aug 2009
Posts: 44
Location: Hyderabad

PostPosted: Wed Sep 02, 2009 5:46 pm    Post subject: @ Sandy
Reply with quote

Its not the new program. Yes, I had a view at 3042 abend with REASON CODE - 090C030.
xxxxxxxx RESOURCE FAILURE FOR SUBSYSTEM zzzz REASON CODE - yyzzaaaa
It says:
09
The resource named in the message was not loaded - the zz value equals the return code associated with the MVS™ system code aaaa.

There's no problem with the region. When I run the BMP, it ends in 3042 abend and the transaction is stopped.

FYI: Below is the DFSRRC00 parm parameters used.

//MYSINT01 EXEC PGM=DFSRRC00,REGION=4096K,
// PARM='BMP,MYS300P,MYS300P,MYSINT01,,N00014,,,,,,,,IMSF,IMSFBMP,
// DBI6,'
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Mon Sep 07, 2009 5:14 pm    Post subject:
Reply with quote

Every installation uses their own PARM parameters. Also check the load libraries in your JCL. If you have both production and test JCL examples try comparing them against yours.
Back to top
View user's profile Send private message
chowdhrykapildev

New User


Joined: 05 Aug 2009
Posts: 44
Location: Hyderabad

PostPosted: Mon Sep 07, 2009 5:23 pm    Post subject: @ Sandy
Reply with quote

Parm parameters for both the Production and Test JCLs are similar. I had even checked the JCL, they are pointing to their own environment libraries (ie everything is perfect with respect to JCL's).
Is there any setting which I need to have regarding DB2 subsystem?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10309
Location: italy

PostPosted: Mon Sep 07, 2009 5:40 pm    Post subject: Reply to: Error in BMP which has interface between IMS &
Reply with quote

the chances of getting Your issue solved on a forum are a bit thin...
from the message there is a problem regarding the DSNMIN10 db2 module

the best thing to do is to work with Your support
has anything changed lately ?

googling for DSNMIN10 gives quite a lot of hits
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 5 Thu Sep 07, 2017 6:02 pm
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm
No new posts WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us