Shell script from DB2

mdx34 · #1 (**permalink**) 01-22-08, 10:04

DB2 8.2 on Linux.

Is there a way to execute/schedule a shell script from DB2 ?

T.I.A

anu_chiluka · #2 (**permalink**) 01-22-08, 10:38

Have you tried Task Center

ARWinner · #3 (**permalink**) 01-22-08, 11:32

You can also use cron.

Andy

mdx34 · #4 (**permalink**) 01-24-08, 11:31

We don't want to use cron but how do you set it up from task center ?

Thanks again.

Peter.Vanroose · #5 (**permalink**) 01-26-08, 05:37

Related question: is it possible to write a trigger which will call a shell script (like e.g. sending an email)?

stolze · #6 (**permalink**) 01-26-08, 07:02

Triggers: Yes, you can do that easily by implementing an external UDF or procedure. The trigger can simply invoke this external routine.

Operating system commands in general: http://www.ibm.com/developerworks/db...303stolze.html

Peter.Vanroose · #7 (**permalink**) 01-26-08, 08:24

Quote:

Originally Posted by stolze

Operating system commands in general: http://www.ibm.com/developerworks/db...303stolze.html

Thanks! Very interesting page indeed!

Internet Services

Web Development

Digital Marketing

Consumer Tech