echo off date /T time /T echo saving passwords copy "C:\Program Files\IBM\SQLLIB\db2cli.ini" "C:\Program Files\IBM\SQLLIB\db2cli.bak" erase "C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### time /T echo uncataloging odbc sources "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source qmfd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source dwhd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source dwhd02" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source dwhq01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source dwhp01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source imed01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source imed03" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source imed05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source imeq05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source imep05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source imed07" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source imeq07" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source imep01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source bidd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source cusp01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source dm1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source sp1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source bm2pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source sl1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source st1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog system odbc data source d_d1d2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog dcs db d_d1d2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### time /T echo uncataloging databases "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db qmfd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db dwhd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db dwhd02" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db dwhq01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db dwhp01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db imed01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db imed03" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db imed05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db imeq05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db imep05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db imed07" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db imeq07" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db imep01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db cusp01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db bidd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db sl1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db sp1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db bm2pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db st1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db dm1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog db d_d1d2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### time /T echo uncataloging nodes "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog node dm1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog node sp1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog node sl1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog node bm2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v uncatalog node d_d1d2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### time /T echo cataloging nodes "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog tcpip node dm1 remote vh2ldcdv01 server 51000" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog tcpip node st1 remote vh2ldcdv01 server 50000" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog tcpip node sp1 remote vh2ldcap06 server 50000" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog tcpip node sl1 remote phdcap4w server 50000" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog tcpip node bm2 remote lqmpdw051.us.hsbc server 50000" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog tcpip node D_D1D2 remote I03D1D2 server 51446" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog dcs db d_d1d2 as USNETI03D1D2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### time /T echo cataloging databases "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db bidd01 as bidd01 at node sl1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db cusp01 as cusp01 at node bm2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db qmfd01 as qmfd01 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dwhd01 as dwhd01 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dwhd02 as dwhd02 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dwhq01 as dwhq01 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dwhp01 as dwhp01 at node sp1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db imed01 as imed01 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db imed03 as imed03 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db imed05 as imed05 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db imeq05 as imeq05 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db imep05 as imep05 at node sp1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db imed07 as imed07 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db imeq07 as imeq07 at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db imep01 as imep01 at node sp1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dbapmon as sp1pmon at node sp1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dbapmon as st1pmon at node st1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dbapmon as sl1pmon at node sl1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dbapmon as bm2pmon at node bm2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db dbapmon as dm1pmon at node dm1" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog db d_d1d2 as d_d1d2 at node d_d1d2 authentication dcs" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### time /T echo cataloging odbc sources "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source bidd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source cusp01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source qmfd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source dwhd01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source dwhd02" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source dwhq01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source dwhp01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source imed01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source imed03" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source imed05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source imeq05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source imep05" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source imed07" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source imeq07" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source imep01" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source sp1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source st1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source sl1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source bm2pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source dm1pmon" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" "C:\Program Files\IBM\SQLLIB\bin\db2cmd.exe" /c /w /i /t "db2 -v catalog system odbc data source d_d1d2" 1>>"C:\Program Files\IBM\SQLLIB\db2setup.out" REM ############################################################################################################### date /T echo restoring passwords copy "C:\Program Files\IBM\SQLLIB\db2cli.bak" "C:\Program Files\IBM\SQLLIB\db2cli.ini" time /T REM type "C:\Program Files\IBM\SQLLIB\db2setup.out" pause