SQL - 904 Error On isert >2M records into table

Hi,

We are on PT8.52, HCM 9.0 and DB2 database.

I have written Application Engine program to load all data for certain employees from PS_JOB_JR  to PS_XXX_JOB_JR_TMP table. I have used below insert SQL in my app engine, but it is keep failing for large number of rows( > 1 million). It workes fine and loads data for around 200K rows.

INSERT INTO PS_XXX_JOB_JR_TMP ( EMPLID  ,EMPL_RCD  ,EFFDT  ,EFFSEQ .........,CONT_SAL_TYPE_BRA  ,CBO_CD_BRA  ,SEFIP_CATEGORY_BRA  ,UNION_CD_ALT_BRA) 

 SELECT A.EMPLID  ,A.EMPL_RCD  ,A.EFFDT  ,A.EFFSEQ ........... A.CONT_SAL_TYPE_BRA  ,A.CBO_CD_BRA  ,A.SEFIP_CATEGORY_BRA  ,A.UNION_CD_ALT_BRA   FROM PS_JOB_JR A