SQL code -904 reason code 00C200E0

eHorizon.Andrew · Posted: Tue Jul 03, 2007 2:48 pm

I have search the forum, but can't find any case i metioned below, can anybody give me some advice?

SQLCODE : -904 DSNTIAR CODE : 0

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C200E0, TYPE OF RESOURCE
00000700, AND RESOURCE NAME BP5
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRFF SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -115 13172746 0 -1 0 12714050 SQL DIAGNOSTIC
INFORMATION
DSNT416I SQLERRD = X'FFFFFF8D' X'00C9000A' X'00000000'
X'FFFFFFFF' X'00000000' X'00C20042' SQL DIAGNOSTIC
INFORMATION

I have check the tablespace's status, it is RW....

thanks for help.

eHorizon.Andrew · Posted: Tue Jul 03, 2007 2:57 pm

what do you mean ?

murmohk1 · Posted: Tue Jul 03, 2007 2:59 pm

Sorry about my previous post.

eHorizon.Andrew · Posted: Tue Jul 03, 2007 3:02 pm

i see,3x, could you tell me how you check out the size of buffer pool?

wanderer · Posted: Wed Jul 04, 2007 12:17 am

There is a DISPLAY BUFFERPOOL command you can use in DSN prompt. However it is unlikely that you will be able to change it. Talk to your DBA about this. You can also alter your tablespace to point to some other active bufferpool.

eHorizon.Andrew · Posted: Wed Jul 04, 2007 7:30 am

thank you wanderer,I am afraid I do not have privilege to alter the tablespace also, so as a user , what can I do else?

wanderer · Posted: Wed Jul 04, 2007 8:09 am

Tell your DBA, "You better fix this or else..."