Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 6968
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 C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us