View previous topic :: View next topic
|
Author |
Message |
krishnapriyavr
New User
Joined: 21 Apr 2009 Posts: 5 Location: india
|
|
|
|
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 |
|
|
LearningDb2
New User
Joined: 19 Jun 2009 Posts: 40 Location: India
|
|
|
|
Hi Priya,
Have you checked the status of the Tablespace...?
Is dere ne other message displayed in the logs.. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
krishnapriyavr
New User
Joined: 21 Apr 2009 Posts: 5 Location: india
|
|
|
|
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 |
|
|
LearningDb2
New User
Joined: 19 Jun 2009 Posts: 40 Location: India
|
|
|
|
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 |
|
|
|