#!/bin/bash

for FILE in `ls -1 /home/mwlog/init/*.sql | sort -g`
do
    echo "CONNECT TO MWLOG~" > /tmp/migrate.sql
    cat $FILE >> /tmp/migrate.sql
    echo -e "\n\nTERMINATE~" >> /tmp/migrate.sql
    su - db2inst1 -c "db2 -td~ -qvf /tmp/migrate.sql"
done

for FILE in `ls -1 /home/mwlog/migration/*.sql | sort -g`
do
    echo "CONNECT TO MWLOG;" > /tmp/migrate.sql
    cat $FILE >> /tmp/migrate.sql
    echo -e "\n\nTERMINATE;" >> /tmp/migrate.sql
    su - db2inst1 -c "db2 -qtvf /tmp/migrate.sql"
done
touch /var/migrate.done


su - db2inst1 -c "db2 connect to mwlog > /dev/null 2>&1;
                  db2 set schema mwlog > /dev/null 2>&1;
                  echo '/home/mwlog/storeprocedure/merge_dlog_md.db2'; 
                  db2 -td@ -f /home/mwlog/storeprocedure/merge_dlog_md.db2; 
                  db2 terminate > /dev/null 2>&1;"