1, the problem description:
Alone in DB2 insert into the TAB select fields from the TAB - limit the query data are rarely can insert normal execution success;
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,
The sum (CALL_FREQ) CALL_FREQ,
The sum (CALL_DUR) CALL_DUR
The from the TAB
WHERE the 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
But if you don't limit the number of records a data and then submitted to the wrong payment days
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,
The sum (CALL_FREQ) CALL_FREQ,
The sum (CALL_DUR) CALL_DUR
The from the 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
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
The Error
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
IBM QCC12002E - The following SQL Error occurred: [] [CLI Driver] CLI0108E communication link failure, SQLSTATE=40003.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Sure
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
[IBM] [CLI Driver] SQL1224N: an error occurred due to the database manager or be forced to interrupt, thus unable to accept new requests, terminated is processing all requests or terminated as specified by the request, the SQLSTATE=55032,
[IBM] [CLI Driver] SQL1224N: an error occurred due to the database manager or be forced to interrupt, thus unable to accept new requests, terminated is processing all requests or terminated as specified by the request, the SQLSTATE=55032,
200 rows inserted because of the ERROR.
CodePudding user response:
Every great god help have a look