OS: Windows 2003
DB2: v9 FP1 (wr21380), LUW
I want to schedule a bat file that will execute a db connection, run a
select statement writing the results to a file, and then disconnect
from the database. Without setting any of the DB2bqtime, DB2bqtry,
Db2rqtime, or DB2iqtime I would get an error saying no connection to
database exists. Then I set DB2bqtime to 420, DB2bqtry to 120,
Db2rqtime to 5, and DB2iqtime to 5 with the DB2set command. Now the
CLP window opens but just sits idle and nothing is written to my
output file. I have read the "Command Line Processor Features" from
the infocenter but so far I am not movnig ahead on this project. Can
someone give me guidence on how to get this working. BTW, in version
8 this bat file ran flawlessly using the /i /w /c db2cmd parameters.
My testing has included using these as well as not. Thank you for
suggestions to help me solve this problem!
FAQ
Search
Profile
Private Messages
Log in
