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

-904 not PENDINg status or BPOOL or SIZE releated


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kavinkumar_s

New User


Joined: 03 Mar 2009
Posts: 10
Location: chennai

PostPosted: Mon Apr 13, 2009 8:38 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Mon Apr 13, 2009 8:54 pm
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Apr 13, 2009 9:07 pm
Reply with quote

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
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Mon Apr 13, 2009 9:08 pm
Reply with quote

User Response: Notify the system programmer. Invoke the application again after the system programmer has corrected the error.

Explanation: The SQL statement could not be executed because resource 'resource-name' of type 'resource-type' was not available at the time for the reason indicated by 'reason-code'.

00000220 Data set
Back to top
View user's profile Send private message
kavinkumar_s

New User


Joined: 03 Mar 2009
Posts: 10
Location: chennai

PostPosted: Mon Apr 13, 2009 9:50 pm
Reply with quote

i'm fresher my TL gave me this issue , i need to solve it, can u give solution ?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Apr 13, 2009 10:04 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Mon Apr 13, 2009 10:42 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 14, 2009 5:50 am
Reply with quote

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 icon_confused.gif

Suggest you talk with the system programmer (or possibly the storage management) to determine if the dataset was migrated.
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 Job completes in JES, but the status ... IBM Tools 1
No new posts SCOPE PENDING option -check data DB2 2
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Masking variable size field - min 10 ... DFSORT/ICETOOL 4
Search our Forums:

Back to Top