大牛們,請幫解決
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.
uj5u.com熱心網友回復：
各位大神們幫看看轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/84099.html
標籤：DB2
下一篇：怎樣查詢左右區是否存在