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

DB2 abend while querying - SQLCODE=-904 REASON 00C200E2


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

New User


Joined: 21 Apr 2009
Posts: 5
Location: india

PostPosted: Wed Jul 14, 2010 1:14 pm
Reply with quote

Hi,

While submitting the DB2 query for select we are getting -904 abend with REASON 00C200E2
and TYPE OF RESOURCE 00000220
he table which we are trying to access is a partition table.
Please help to reslove this issue
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Jul 14, 2010 1:42 pm
Reply with quote

Hi Priya,

Have you checked the status of the Tablespace...?
Is dere ne other message displayed in the logs..
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Wed Jul 14, 2010 2:07 pm
Reply with quote

start with the IBM LookAt website,
set-up to help those who have no idea how to use manuals.
The Link is here

1. enter -904 in the 'enter message id'.

2. select you system, or leave the default.

3. click the go button.

now, a list of db2 version error&msg code manuals are displayed.
pick your version

perform a search (little flashlight button) for -904

open a new tab for the -904 link
open a new tab for the 00c200e0 link

read the -904 info, and open a new tab for the reason code info.

look at the reason code. (000220)

in the 00c200e0 page, click the 'next topic' button twice
(until you get to 00c200e2 and read that)

as you will have realized from reading the -904, the DSN is available
in the sqlca.

if you were using spufi or qmf, this info is available to you.
if this was from a program,
and you do not have a routine using CALLing DSNTIAR for sql error display,
you should incorporate one.
Back to top
View user's profile Send private message
krishnapriyavr

New User


Joined: 21 Apr 2009
Posts: 5
Location: india

PostPosted: Wed Jul 14, 2010 3:18 pm
Reply with quote

The table is in RW status only. But not able to query it. I have checked the status of table and index. All are RW only.
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Jul 14, 2010 6:03 pm
Reply with quote

Quote:
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.


As indicated by the error code,due to some issues the db2 is not able to allocate the VSAM dataset. There can be many reasons for that.U can chek with system support guys if nething wrong with the volume..

Thanks..
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 Reorg abended with REASON=X'00E40347' DB2 2
No new posts ISAM and abend S03B JCL & VSAM 9
No new posts REASON 00D70014 in load utility DB2 6
No new posts DB2 Statistics - Using EXPLAIN and qu... DB2 1
No new posts Abend S0C4 11 (Page Translation Excep... PL/I & Assembler 16
Search our Forums:

Back to Top