#!/bin/bash
. /home/db2prod/sqllib/db2profile
if db2 connect to NOMEDBESISTENTE user USER using PASSWORD ; then

        db2 connect reset

        lista_database=`db2 list db directory|grep -i alias|cut -d= -f2` || exit 1

        tar -cf /TUOPERCORSO/database.tar /etc/hosts

        for database in $lista_database ; do
        if [ "$database" != "TOOLSDB" ] ; then
                echo "Salvataggio database  $database"
                rm -rf /TUOPERCORSO/$database
                mkdir  /TUOPERCORSO/$database
                cd     /TUOPERCORSO/$database
                db2move $database export
                tar -uf /TUOPERCORSO/database.tar /TUOPERCORSO/$database/*
        fi
        done

        rm -f /TUOPERCORSO/database.tar.gz
        gzip  /TUOPERCORSO/database.tar
else
  mail -s "!!!!!!!!!ATTENZIONE ERRORI !!!!!!!!!!!!!" log@telnext.it < /opt/script/salvataggio-non-effettuato
  exit 1
fi