Two ways:
1. Download CYGWIN components. You can use that like UNIX system
and write cron jobs. The problem inh that is to identify the
correct components. For afull load, it needs 1.5G space
2. Write a batch file composing of a batch file containing
following:
db2 -tvf c:\temp\statsTabs.sql >statsResults.out
Then, write your runstats SQL statements in the file
c:\temp\statsTabs.sql.
Now, you can set in the scheduler to run te batch file. I
have successfully executed the batch files in the scheduler.
Hope this helps.
Good luck.
Parthahs

> -----Original Message-----
> From: Joe Philip
> [mailto:db2udbdba-ezmlmshield-x83415048.[Email address
> protected]
> Sent: Tuesday, June 15, 2004 2:53 PM
> To: LazyDBA Discussion
> Subject: automating runstats on DB2 Windows 2000
>
>
> I want to automate the runstats on Windows 2000. Can some one
> point to me how to set it up on Windows. (For example, I use
Cron on Unix systems to schedule it.) What method should I
follow on Windows?
>
>
>




__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

DB2 & UDB email list listserv db2-l LazyDBA home page