appending to msgfiles using db2load api

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vivek - 03 Jan 2007 10:42 GMT

Hi,

Iam using the db2load API to write data to a table. I see that by
default the load process creates/overwrites the msgfile. Is there a way
to change this behaviour so that messages are appended to an exisiting
msg file.

Thanks,
Vivek

Reply to this Message

Knut Stolze - 03 Jan 2007 13:09 GMT

> Hi,
>
> Iam using the db2load API to write data to a table. I see that by
> default the load process creates/overwrites the msgfile. Is there a way
> to change this behaviour so that messages are appended to an exisiting
> msg file.

I'm curious: Why do you want to do that? It's a security risk, after all.
(Well, so is overwriting.)

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

Vivek - 03 Jan 2007 13:49 GMT

In a particular work flow there are multiple load sessions which are
albeit logically related and as far as the end user is concerned it is
one single transaction. The current naming scheme (for the msg files)
ends up overwriting the files such that only the log file of the last
session is present.
So either i change the naming schema or explore a way wherein i can
append to an existing file.
Also i have seen that DB2 appends a string of the form <n>.load.<00n>
to the supplied msg file name. What is this scheme ? i guess the last
part is the partitionid.

> > Hi,
> >
[quoted text clipped - 5 lines]
> I'm curious: Why do you want to do that? It's a security risk, after all.
> (Well, so is overwriting.)

Reply to this Message