If you are starting out in the Windows environment then there is going to be
far more than just a runstats that you are going to want to run. What about
backups, monitoring, reorg and the host of other housekeeping jobs.

We have developed a series of VB scripts that are run via the Windows
scheduler. The output is put into subdirectories under a single daily
directory. The system currently has over 230 "jobs". Output more than 8 days
old is automatically deleted. Each morning the day's directory is scanned
and an email sent to the DBA describing any failures or unusual events. All
the code is written in VBScript and so can be easily read and modified.
Additionally we have an HTA program (Like an html file, but runs locally)
that can be used to display the status of our 25 UDB databases (including
replication status).

The code is currently not generalised, but if there was sufficient interest
I would be happy to work with the group to develop the code into a sharable
facility.

Regards

John Cuthbertson
Umbrella Consulting Group

-----Original Message-----
From: Parthasarathy [Partha]
[mailto:db2udbdba-ezmlmshield-x24712750.[Email address protected]
Sent: Wednesday, 16 June 2004 8:04 AM
To: LazyDBA Discussion
Subject: RE: automating runstats on DB2 Windows 2000


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


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]

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