By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Scheduling a DB2 command to run

P: 2
Hi,

I'm quite new to DB2 and AIX and I'm looking for a way to schedule a DB2 command to run on a daily basis or perhaps even on an hourly basis.

Thanks

Regards

Fridge
Sep 26 '07 #1
Share this Question
Share on Google+
4 Replies


P: 3
Hi,

I'm quite new to DB2 and AIX and I'm looking for a way to schedule a DB2 command to run on a daily basis or perhaps even on an hourly basis.

Thanks

Regards

Fridge
If you use the graphic tools, have a look at the Task Center. You can schedule
'commands' there and then use the Journal to monitor status.
Sep 26 '07 #2

P: 14
You can also setup a cron job in AIX and schedule it
Sep 26 '07 #3

docdiesel
Expert 100+
P: 297
Hi,
You can also setup a cron job in AIX and schedule it
and make sure that you setup the cronjob as the instance owner, e.g. db2inst1. That way you don't need to give a password when connecting to a db.

Regards, Bernd
Sep 27 '07 #4

P: 2
You can also setup a cron job in AIX and schedule it
I know now how to setup a cron job, but I dont know how to script the following.

su - db2prd
(username)
(password)
db2....
Oct 2 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.