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
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: DB2 abend while querying - SQLCODE=-904 REASON 00C200E2
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    Post subject:
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    Post subject:
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    Post subject: Reply to: DB2 abend while querying - SQLCODE=-904 REASON 00C
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    Post subject:
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    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
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts S213-14 ABEND explantion Apurva Mehta JCL & VSAM 5 Thu Jul 07, 2016 10:56 pm
No new posts How to determine where is error in ab... jackzhang75 PL/I & Assembler 13 Fri Apr 15, 2016 2:01 am


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