View previous topic :: View next topic
|
Author |
Message |
kavinkumar_s
New User
Joined: 03 Mar 2009 Posts: 10 Location: chennai
|
|
|
|
I PASTED MY OUTPUT AS I GOT, HOW TO RECTIFY THIS ERROR?
Code: |
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C200E2, TYPE OF RESOURCE 00000220, AND RESOURCE NAME DSNCAT2.DSNDBC.CPRJDB.CPRJTS.I0001.A001
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXICTB SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 190 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000000BE' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
-------------------------------------------------------------------------------- --- |
AND I GOT SOME HIT ABOUT THAT REASON CODE, BUT I DONO HOW TO SOLVE IT, CAN U GIVE ME BREIF SOLUTION HOW TO SOLVE ?
00C200E2
Explanation:
The buffer manager (BM) subcomponent of DB2 is unable to open a data set that is required by the requesting function. An error was returned by the dynamic allocation function that was invoked to allocate a VSAM data set. DB2 message DSNB207I was issued to inform the operator of the error condition. This reason code and the data set name are recorded in
the cursor table (CT) and made available to the user in the SQLCA or in messages.
System action:
A ’resource not available’ code is returned to the user.Abend status is recorded in SYS1.LOGREC.
System programmer response:
The error code returned from the dynamic allocation function was externalized in the DSNB207I message. Refer to the appropriate MVS publication for an explanation of this error code. Correct the situation,
and notify the user to invoke the application again.
User response:
Notify the system programmer. Invoke the application again after the system programmer has corrected the error.
Problem determination:
The unexpected dynamic allocation return code is saved in register 8. It may help determine the cause of the failure.
WAITING FOR UR SOLUTION ? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
You posted this
Quote: |
User response:
Notify the system programmer. Invoke the application again after the system programmer has corrected the error. |
Does that not give you a clue about what you need to do??? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
WAITING FOR UR SOLUTION ? -
UR means Uncommitted Read.
if your intention was to say 'YOUR',
this is not a chat room, please use full spelling.
your abbreviation is confusing, as we are speaking about DB2.
if you would spend less time mastering the intricacies of colored posts
and more with reading what you cut&pasted,
you would have had your solution:
User response:
Notify the system programmer. Invoke the application again after the system programmer has corrected the error.
Did you notify your system programmer?
we know nothing about your environment, except that it employs people like you,
who seem to be waiting for someone else to do their job. |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
Back to top |
|
|
kavinkumar_s
New User
Joined: 03 Mar 2009 Posts: 10 Location: chennai
|
|
|
|
i'm fresher my TL gave me this issue , i need to solve it, can u give solution ? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Please, stop sending me PM's.
what about checking with your systems programmer do you not understand?
if you are a systems programmer, what about trying to find this dataset:
DSNCAT2.DSNDBC.CPRJDB.CPRJTS.I0001.A001
apparently it is not there. check your migration schedules. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
I'll echo Dick's response -- please, no more PM's. I do not have DB2 here, cannot help you solve your problem, and you did not post all the messages so you cannot resolve this issue without talking to your site support group. You are not likely to resolve this one by yourself; you will need assistance from your site. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Your TL needs to learn how to make assignments. . . It makes no sense to give an issue to a fresher that the error message says must be dealt with by the systems programmer
Suggest you talk with the system programmer (or possibly the storage management) to determine if the dataset was migrated. |
|
Back to top |
|
|
|