#!/bin/bash

cp -r /home/mwlog/ssh/* /etc/ssh
sed -i 's/^PasswordAuthentication no/PasswordAuthentication yes/g' /etc/ssh/sshd_config
sed -i 's/#PasswordAuthentication yes/PasswordAuthentication yes/g' /etc/ssh/sshd_config

rm -f /var/run/nologin /etc/nologin

sed -i 's/account    required     pam_nologin.so/# account    required     pam_nologin.so/g' /etc/pam.d/sshd

killall sshd
/usr/sbin/sshd

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;"