View previous topic :: View next topic
|
Author |
Message |
chowdhrykapildev
New User
Joined: 05 Aug 2009 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
chowdhrykapildev
New User
Joined: 05 Aug 2009 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
chowdhrykapildev
New User
Joined: 05 Aug 2009 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
chowdhrykapildev
New User
Joined: 05 Aug 2009 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
|