UatBackup1.bat:
db2cmd.exe UatBackup2.bat
UatBackup2.bat:
e:
cd UATdb2back\
mkdir %date:~2,2%%date:~5,2%%date:~8,2%
cd %date:~2,2%%date:~5,2%%date:~8,2%\
db2 connect to JYKLLIFE user db2inst1 using db2inst1
db2look -d JYKLLIFE -a -e -x -o %date:~2,2%%date:~5,2%%date:~8,2%.sql -i db2inst1 -w db2inst1
db2move JYKLLIFE export -u db2inst1 -p db2inst1
exit
db2cmd.exe UatBackup2.bat
UatBackup2.bat:
e:
cd UATdb2back\
mkdir %date:~2,2%%date:~5,2%%date:~8,2%
cd %date:~2,2%%date:~5,2%%date:~8,2%\
db2 connect to JYKLLIFE user db2inst1 using db2inst1
db2look -d JYKLLIFE -a -e -x -o %date:~2,2%%date:~5,2%%date:~8,2%.sql -i db2inst1 -w db2inst1
db2move JYKLLIFE export -u db2inst1 -p db2inst1
exit