如题:
删除表的时候提示:
db2 => drop table db2inst1.g_accept201311
DB21034E 该命令被当作 SQL 语句来处理,因为它是无效的“命令行处理器”命令。在
SQL 处理期间,它返回:
SQL10003C 没有足够系统资源以处理请求。无法处理该请求。 SQLSTATE=57011
附上db2diag信息:
2014-06-05-16.38.28.328000+480 E127061386H2618 LEVEL: Error (OS)
PID : 2292 TID : 1588 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : NAVGPS
APPHDL : 0-17146 APPID: *LOCAL.DB2.140605083804
AUTHID : ADMINISTRATOR HOSTNAME: lipeng241
EDUID : 1588 EDUNAME: db2agent (NAVGPS)
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, VirtualAlloc
OSERR : 8 "存储空间不足,无法处理此命令。"
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
360513536
DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
33095680
CALLSTCK:
[0] 0x6D35C3A5 sqloGetProfKey + 0x45675
[1] 0x6D12360C sqloMemPoolHandleIsValid + 0x22C
[2] 0x6D33D6F8 sqloGetProfKey + 0x269C8
[3] 0x6E13CF1E sqbLbpDdlSyncServices::pdDumpDdlSyncServices + 0x166E
[4] 0x6E13CB1A sqbLbpDdlSyncServices::pdDumpDdlSyncServices + 0x126A
[5] 0x6E3177EB SQLD_GSS_ARRAY::toIO + 0x2BDEB
[6] 0x6E3175C9 SQLD_GSS_ARRAY::toIO + 0x2BBC9
[7] 0x6E316ED0 SQLD_GSS_ARRAY::toIO + 0x2B4D0
[8] 0x6F6235DF sqlrlgttbspace + 0x61B8F
[9] 0x6F621A9E sqlrlgttbspace + 0x6004E
[10] 0x6EBB5FE9 sqlnx_explain_init + 0xD5A79
[11] 0x6EBB4346 sqlnx_explain_init + 0xD3DD6
[12] 0x6EA225E2 sqlnp_main + 0xE832
[13] 0x6EA17E08 sqlnp_main + 0x4058
[14] 0x6EA13F6F sqlnp_main + 0x1BF
[15] 0x6E83D2DB sqlnn_env_sys_init + 0x236B
[16] 0x6E83CA34 sqlnn_env_sys_init + 0x1AC4
[17] 0x6F28F19B sqlra_get_inc_bind_sect + 0x296AB
[18] 0x6F2969F7 sqlra_get_inc_bind_sect + 0x30F07
[19] 0x6F2A5A7E sqlra_get_inc_bind_sect + 0x3FF8E
[20] 0x6F417606 sqlriget_pfpairs + 0xF00D6
[21] 0x6F416D71 sqlriget_pfpairs + 0xEF841
[22] 0x6F416A3A sqlriget_pfpairs + 0xEF50A
[23] 0x6F33E2C2 sqlriget_pfpairs + 0x16D92
[24] 0x6F21555A sqlrw_krcb_init + 0x9B62A
[25] 0x6F138316 sqlrr_execimmd + 0x116
[26] 0x6E63092D sqljsDrdaAsCbGwCopyStreamLob + 0x33A6D
[27] 0x6E6230E8 sqljsDrdaAsCbGwCopyStreamLob + 0x26228
[28] 0x6E621BE0 sqljsDrdaAsCbGwCopyStreamLob + 0x24D20
[29] 0x6E6018BC sqljsDrdaAsCbGwCopyStreamLob + 0x49FC
[30] 0x6E60097D sqljsDrdaAsCbGwCopyStreamLob + 0x3ABD
[31] 0x6E5FFAAC sqljsDrdaAsCbGwCopyStreamLob + 0x2BEC
[32] 0x6E5FF7CC sqljsDrdaAsCbGwCopyStreamLob + 0x290C
[33] 0x6E456C33 sqeAgent::RunEDU + 0x393
[34] 0x6F94193A sqlzGetZRCInfo + 0x4FA
[35] 0x6F9417DD sqlzGetZRCInfo + 0x39D
[36] 0x6D199752 sqloSpawnEDU + 0xB72
[37] 0x7C82481F GetModuleHandleA + 0xDF
2014-06-05-16.38.28.328000+480 I127064772H585 LEVEL: Severe
PID : 2292 TID : 1588 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : NAVGPS
APPHDL : 0-17146 APPID: *LOCAL.DB2.140605083804
AUTHID : ADMINISTRATOR HOSTNAME: lipeng241
EDUID : 1588 EDUNAME: db2agent (NAVGPS)
FUNCTION: DB2 UDB, buffer pool services, sqlbFreeExtentsForObject, probe:1146
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
DIA8300C A memory heap error has occurred.
2014-06-05-16.38.28.328000+480 I127065359H578 LEVEL: Error
PID : 2292 TID : 1588 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : NAVGPS
APPHDL : 0-17146 APPID: *LOCAL.DB2.140605083804
AUTHID : ADMINISTRATOR HOSTNAME: lipeng241
EDUID : 1588 EDUNAME: db2agent (NAVGPS)
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDeleteObject, probe:800
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
DIA8300C A memory heap error has occurred.
2014-06-05-16.38.28.328000+480 I127065939H552 LEVEL: Error
PID : 2292 TID : 1588 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : NAVGPS
APPHDL : 0-17146 APPID: *LOCAL.DB2.140605083804
AUTHID : ADMINISTRATOR HOSTNAME: lipeng241
EDUID : 1588 EDUNAME: db2agent (NAVGPS)
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDeleteObject, probe:800
DATA #1 : String, 69 bytes
Obj={pool:2;obj:529;type:1} State=x37 Parent={2;529}, EM=9600, PP0=0
2014-06-05-16.38.28.328000+480 I127066493H1006 LEVEL: Error
PID : 2292 TID : 1588 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : NAVGPS
APPHDL : 0-17146 APPID: *LOCAL.DB2.140605083804
AUTHID : ADMINISTRATOR HOSTNAME: lipeng241
EDUID : 1588 EDUNAME: db2agent (NAVGPS)
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDeleteObject, probe:0
DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:2;obj:529;type:1} Parent={2;529}
lifeLSN: 000000000008F42C
tid: 0 0 0
extentAnchor: 9600
initEmpPages: 0
poolPage0: 0
poolflags: 3122
objectState: 37
lastSMP: 0
pageSize: 4096
extentSize: 32
bufferPoolID: 1
partialHash: 51445762
objDescAttributes: 0
bufferPool: 0x79175780
pdef: 0x5f7c02e0
2014-06-05-16.38.28.328000+480 I127067501H659 LEVEL: Error
PID : 2292 TID : 1588 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : NAVGPS
APPHDL : 0-17146 APPID: *LOCAL.DB2.140605083804
AUTHID : ADMINISTRATOR HOSTNAME: lipeng241
EDUID : 1588 EDUNAME: db2agent (NAVGPS)
FUNCTION: DB2 UDB, data management, sqldTableDrop, probe:650
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
DIA8300C A memory heap error has occurred.
DATA #1 : String, 62 bytes
Unable to drop table.
RC=8B0F0000, Pool=2, Object=529, Class=0
收起