Help for this page

Select Code to Download


  1. or download this
    ssh server 'for i in `. /u02/db2inst1/sqllib/db2profile;db2 list db di
    +rectory|grep "Database alias"|\
    sed -e 's/Database//g' -e 's/alias//' -e 's/=//' `;do echo DB $i; . /u
    +02/db2inst1/sqllib/db2profile ; \
            db2 connect to $i user tester using password ;db2 terminate ; 
    +done ;'
    
  2. or download this
    @test=`ssh $key '. /u02/db2inst1/sqllib/db2profile; for i in \`. /u02/
    +db2inst1/sqllib/db2profile;db2 list db directory|grep "Database alias
    +"|sed -e 's/Database//g' -e 's/alias//' -e 's/=//' -e 's/\\n//g' \`;d
    +o echo DB \$i;db2 connect to $i user tester using password;done;'`;