Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

-904 not PENDINg status or BPOOL or SIZE releated

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: -904 not PENDINg status or BPOOL or SIZE releated
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: 7996
Location: Bellevue, IA

PostPosted: Mon Apr 13, 2009 8:54 pm    Post subject:
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    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Mon Apr 13, 2009 9:08 pm    Post subject:
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    Post subject:
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    Post subject:
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: 7996
Location: Bellevue, IA

PostPosted: Mon Apr 13, 2009 10:42 pm    Post subject:
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

Site Director


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

PostPosted: Tue Apr 14, 2009 5:50 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. session stuck in TPX with status ACL amitc23 CA Products 1 Tue Dec 13, 2016 12:53 pm
No new posts Increase the screen size after split mistah kurtz TSO/ISPF 2 Fri Sep 02, 2016 6:39 pm
No new posts How to resolve IMS DB status code FM Priyanka Boga IMS DB/DC 3 Fri Jun 10, 2016 1:54 pm
No new posts JCL to fetch schedule status from act... parasmalik20 CA Products 1 Thu Jun 02, 2016 7:11 pm
No new posts ALTER of an IDMS AREA with NEW/OLD pa... Awanti IDMS/ADSO 2 Mon Mar 14, 2016 10:01 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us