Hi,<br />
I am getting this error :<br />
<br />
ERROR <a
href="http://www-128.ibm.com/developerworks/forums/">57011</a>
; <a
href="http://www-128.ibm.com/developerworks/forums/">IBM</a>&
lt;a
href="http://www-128.ibm.com/developerworks/forums/">DB2</a>
SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code:
"00C90084", type of resource: "00000230", and resource name:
"4K". SQLSTATE=57011<br />
<br />
|
Hi,<br />
<br />
my query is as under:<br />
SELECT A.ERND_YTD_AMT, <br />
A.PD_YTD_AMT, <br />
A.PTD, <br />
A.CHG_CD, <br />
A.PD_AMT, <br />
A.VER, <br />
A.OBG_NO, <br />
B.ORIG_BAL, <br />
B.FED_CD, <br />
B.VER, <br />
B.OBG_NO, <br />
C.GEO_1, <br />
C.VER, <br />
C.OBG_NO, <br />
D.PRM_EFF_FR_DT, <br />
D.PRM_EFF_THRU_DT, <br />
D.VER, <br />
D.OBG_NO, <br />
E.PRM_NO, <br />
E.PRM_SOURCE, <br />
E.VER <br />
FROM AFS2.HEADER A, <br />
AFS2.OBLN B, <br />
AFS2.OBLG C, <br />
AFS2.PRIME_SCHED D, <br />
AFS2.BASE_RATE E <br />
WHERE A.VER = 108011400 AND <br />
(A.CHG_CD BETWEEN 100 AND 199) AND <br />
B.VER = 108011400 AND <br />
C.VER = 108011400 AND <br />
D.VER = 108011400 AND <br />
(D.CHG_CD BETWEEN 100 AND 199) AND <br />
E.VER = 108011400 AND <br />
A.OBL_NO = B.OBL_NO AND <br />
A.OBG_NO = B.OBG_NO AND <br />
C.OBG_NO = B.OBG_NO AND <br />
D.OBL_NO = B.OBL_NO AND <br />
D.OBG_NO = C.OBG_NO AND <br />
D.PRM_NO = E.PRM_NO AND <br />
D.PRM_SOURCE_CD = E.PRM_SOURCE <br />
<br />
|
Hi,<br />
SQL State 57011 says that it is beacuse of <b>INSUFFICIENT VIRTUAL
STORAGE FOR BUFFERPOOL EXPANSION</b>.<br />
<br />
This is given as Programmer Response, <b>If this error should occur during
interactive</b><br />
<b>execution of an SQL statement or execution of an application
program,</b><br />
<b>installation administration should be notified</b>.<br />
<br />
|