View Attach Info
This is version . It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

BACKUP (DEI DATI) MULTIDATABASE MEDIANTE DB2MOVE#

#!/bin/bash
. /home/db2prod/sqllib/db2profile
if db2 connect to NOME_DI_UN_DB_QUALSIASI_ESISTENTE 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

ESPORTAZIONE FILE DDL MULTIDATABASE (SCHEMA PER SCHEMA) MEDIANTE DB2LOOK#

#!/bin/bash
. /home/db2prod/sqllib/db2profile
USER=ROOT
export USER

if db2 connect to NOME_DI_UN_DB_QUALSIASI_ESISTENTE 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/db2look/database_db2look.tar /etc/hosts

        for database in $lista_database ; do
        #database="ENTI"
        if [ "$database" != "TOOLSDB" ] ; then
                echo "Salvataggio db2look  $database"
                rm -rf /TUOPERCORSO/db2look/$database
                mkdir  /TUOPERCORSO/db2look/$database
                cd     /TUOPERCORSO/db2look/$database

                db2 connect to $database user USER using PASSWORD
                lista_schema=`db2 -x "select schemaname from syscat.schemata where schemaname not like '%SYS%' and schemaname<>'NULLID' and schemaname<>'SQLJ'"`
                #echo $list_schema
                for db_schema in $lista_schema ; do
                        #echo Salvataggio schema $db_schema
                        db2look -d $database -e -z $db_schema -o $database$db_schema.db2 -i USER -w PASSWORD
                done
                db2 connect reset
                tar -uf /TUOPERCORSO/database_db2look.tar /TUOPERCORSO/db2look/$database/*
        fi
        done

        rm -f /TUOPERCORSO/database_db2look.tar.gz
        gzip  /TUOPERCORSO/database_db2look.tar

else
  mail -s "!!!!!!!!!ATTENZIONE ERRORI !!!!!!!!!!!!!" log@telnext.it < /opt/script/salvataggio-non-effettuato
  exit 1
fi

Add new attachment

Only authorized users are allowed to upload new attachments.
« This particular version was published on 14-Apr-2010 14:30 by RaffaelePedrini.