View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-5) was last changed on 14-Apr-2010 14:30 by RaffaelePedrini  

This page was created on 14-Apr-2010 14:30 by RaffaelePedrini

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 1 added 3 lines
!!BACKUP (DEI DATI) MULTIDATABASE MEDIANTE DB2MOVE
%%prettyif
{{{
At line 3 changed one line
if db2 connect to NOMEDBESISTENTE user USER using PASSWORD ; then
if db2 connect to NOME_DI_UN_DB_QUALSIASI_ESISTENTE user USER using PASSWORD ; then
At line 31 added 49 lines
}}}
\\\\
!!ESPORTAZIONE FILE DDL MULTIDATABASE E SCHEMA PER SCHEMA MEDIANTE DB2LOOK
%%prettyif
{{{
#!/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
}}}
Version Date Modified Size Author Changes ... Change note
5 14-Apr-2010 14:30 2.635 kB RaffaelePedrini to previous
4 14-Apr-2010 14:30 2.631 kB RaffaelePedrini to previous | to last
3 14-Apr-2010 14:30 2.73 kB RaffaelePedrini to previous | to last
2 14-Apr-2010 14:30 2.732 kB RaffaelePedrini to previous | to last
1 14-Apr-2010 14:30 0.94 kB RaffaelePedrini to last
« This page (revision-5) was last changed on 14-Apr-2010 14:30 by RaffaelePedrini