Programming

Hi Robin
First Thing : Thank you for looking into it and providing valid suggestions.

Made few changes :
1.I have removed distinct in the select query.
2.I already have indexes for both tables for required columns as below.

Code:

--staging 
CREATE UNIQUE INDEX schemaname.PK_Customer_Staging
    ON schemaname.Customer_Staging(Name ,CUST_ID,ORG_ID)
ALLOW REVERSE SCANS PAGE SPLIT SYMMETRIC

--target
CREATE UNIQUE INDEX schemaname.PK_Customer_Table
    ON schemaname.Customer_Table(Name ,CUST_ID,ORG_ID)
ALLOW REVERSE SCANS PAGE SPLIT SYMMETRIC

3.I observed my db2 uses MAX_LOG => 32 and LOGPRIMARY is 12(No way to extend this as its max provided by tool client ) and do get transaction log space error while loading first time since no data exists in target table.

Is there any way to split the logic based on row count and insert data in two parts . Like First 5 Million , then 5=M to Max count .
Or any other approach to load huge 8 Million data . Any help appreciated.