How to run db2pd -hadr in batch mode I am trying to automate some things on DB2 and would like to use a batch file to do this. I create the following batch file test.bat:

db2cmd - -w "db2 -tvf test.db2"


I then try to do two commands in the test.db2 script, which work together in the CLP interactive mode:

!set db2instance=INST1;
!db2pd -db MYDB -hadr;


I then get the following output:


  Database MYDB not activated on database partition 0.
  Option -hadr requires -db  or -alldbs option and active database.


I'm using DB2 9.7 LUW on Windows 2008 R2.
I found a way to do this using two batch files:

test1.bat
------------------------------------------------------------------------
db2cmd -c -i -w "test2.bat"
PAUSE

test2.bat
------------------------------------------------------------------------
set db2instance=INST1
db2pd -db MYDB -hadr


This is effectively the same as running in interactive mode but if anybody has a way to do this using only one batch file please let me know!