echo `date +"%C%y-%m-%d %T"`
echo
db2 -v connect to xdb

###########################################################################################################

echo `date +"%C%y-%m-%d %T"`; echo; db2 -v "CALL SYSPROC.ADMIN_CMD('LOAD FROM (select CREATED_TIME, UPDATED_TIME, END_TIME,     ECIF_CREATED_TIME, ECIF_UPDATED_TIME, CREATED_BY_EMPLOYEE,     UPDATED_BY_EMPLOYEE, CREATED_SYSTEM, UPDATED_SYSTEM,     CREATED_CHANNEL, UPDATED_CHANNEL, SEQ_NO,  TRANS_ID, ECO_TYPE,     ACCT_ID, BATCH_NUM, ORDER_TYPE, ORDER_TYPE_DESC, UNITY_ORDER_NUM    , ORDER_NUM, CMMDTY_CODE, CMMDTY_NAME, CMMDTY_CATALOG,     CMMDTY_BRAND, CMMDTY_GROUP, BATCH_TYPE, BATCH_CHG_QTY, STORE,      BRANCH, OPERATOR, EVENT_TS, CURR_TYPE, EVENT_TYPE, PARTY_ID,     PARTY_ID_TYPE  from ECIF1.TB2033 WHERE T_NO =18 ) of cursor INSERT INTO ecif.TB2033_18  nonrecoverable')"

echo `date +"%C%y-%m-%d %T"`
echo
db2 -v connect reset
db2 -v terminate
echo `date +"%C%y-%m-%d %T"`

echo `date +"%C%y-%m-%d %T"`; echo; db2 -v "truncate table ecif.tb2033_0 immediate"

trunc.sh > trunc.log 2>&1
nohup load1.sh  > load1.log 2>&1 &
nohup load2.sh  > load2.log 2>&1 &


# Will not use below single process load
#db2 "declare cur1 cursor database ${sdb} user ${suserid} using ${spwd} for select * from ${sschema}.${line} with ur"
#STATUS=$?
#if [ $STATUS -ne 0 ]
#then
#    LOG_MSG="Error when declaring cursor for table ${sschema}.${line}"
#    write_log
#    exit 1
#fi
#db2 "load from cur1 of cursor messages ${sdb}.${sschema}.${line}.load.msg replace into ${tschema}.${line} nonrecoverable"
#if [ $STATUS -ne 0 ]
#then
#    LOG_MSG="Error when loading data into table ${tschema}.${line}"
#    write_log
#    exit 1
#fi