Db2 in non-interactive mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Santhosh - 28 Jul 2006 03:33 GMT

Hi All

I need to execute a set of LOAD commands non-interactively. I used the
following:

db2cmd /c /w /i db2 < ./db2audit.txt >db2audit.log

This db2audit.txt contains db connection and load command. But somehow
it is not executing in Fix Pack 2.. but executing in FP 9..

So can I know what can be the reason? Anyother way of doing it?

Regards
Santhosh

Reply to this Message

Serge Rielau - 28 Jul 2006 04:04 GMT

> Hi All
>
[quoted text clipped - 7 lines]
>
> So can I know what can be the reason? Anyother way of doing it?

So what happens? Error message?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Mark A - 28 Jul 2006 07:03 GMT

> Hi All
>
[quoted text clipped - 10 lines]
> Regards
> Santhosh

IN 8.2 there is stored procedure called DB2LOAD that you can call to perform
a load.

Reply to this Message