db2数据插入问题
大牛们,请帮解决
1、问题描述:
单独在DB2 执行insert into tab select 字段 from tab---限定查询数据量很少是可以正常执行插入成功;
sql
insert into BONC01.DW_GSM_CIRCLE_DETAIL_M
(
STATIS_MONTH,
AREA_ID,
USR_ID,
MSISDN,
HOME_CNTY_ID,
OTHER_CNTY_ID,
OTHER_PARTY,
SMART_CODE,
OTHER_OPRAT_TYP_ID,
B_OPRAT_TYP_ID,
OTHER_HOME_AREA_ID,
CALL_TYP_ID,
CALL_FREQ,
CALL_DUR
)
select 201804 STATIS_MONTH,
AREA_ID,
USR_ID,
MSISDN,
HOME_CNTY_ID,
OTHER_CNTY_ID,
OTHER_PARTY,
SMART_CODE,
OTHER_OPRAT_TYP_ID,
B_OPRAT_TYP_ID,
OTHER_HOME_AREA_ID,
CALL_TYP_ID,
sum(CALL_FREQ) CALL_FREQ,
sum(CALL_DUR) CALL_DUR
from TAB
WHERE MSISDN='XXXXXXXX'
group by AREA_ID,
USR_ID,
MSISDN,
HOME_CNTY_ID,
OTHER_CNTY_ID,
OTHER_PARTY,
SMART_CODE,
OTHER_OPRAT_TYP_ID,
B_OPRAT_TYP_ID,
OTHER_HOME_AREA_ID,
CALL_TYP_ID
但是要是不限制记录数量 一个账期的数据 然后就报错误
SQL
insert into BONC01.DW_GSM_CIRCLE_DETAIL_M
(
STATIS_MONTH,
AREA_ID,
USR_ID,
MSISDN,
HOME_CNTY_ID,
OTHER_CNTY_ID,
OTHER_PARTY,
SMART_CODE,
OTHER_OPRAT_TYP_ID,
B_OPRAT_TYP_ID,
OTHER_HOME_AREA_ID,
CALL_TYP_ID,
CALL_FREQ,
CALL_DUR
)
select 201804 STATIS_MONTH,
AREA_ID,
USR_ID,
MSISDN,
HOME_CNTY_ID,
OTHER_CNTY_ID,
OTHER_PARTY,
SMART_CODE,
OTHER_OPRAT_TYP_ID,
B_OPRAT_TYP_ID,
OTHER_HOME_AREA_ID,
CALL_TYP_ID,
sum(CALL_FREQ) CALL_FREQ,
sum(CALL_DUR) CALL_DUR
from TAB
group by AREA_ID,
USR_ID,
MSISDN,
HOME_CNTY_ID,
OTHER_CNTY_ID,
OTHER_PARTY,
SMART_CODE,
OTHER_OPRAT_TYP_ID,
B_OPRAT_TYP_ID,
OTHER_HOME_AREA_ID,
CALL_TYP_ID
---------------------------
Error
---------------------------
QCC12002E - The following SQL Error occurred: [IBM][CLI Driver] CLI0108E 通信链路故障。 SQLSTATE=40003.
---------------------------
确定
---------------------------
[IBM][CLI Driver] SQL1224N 由于数据库管理器发生了错误或者被强制中断,从而无法接受新的请求,已终止正在处理的所有请求或者已终止所指定的请求。 SQLSTATE=55032
[IBM][CLI Driver] SQL1224N 由于数据库管理器发生了错误或者被强制中断,从而无法接受新的请求,已终止正在处理的所有请求或者已终止所指定的请求。 SQLSTATE=55032
200 rows inserted because of ERROR.