469,891 Members | 2,251 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,891 developers. It's quick & easy.

appending to msgfiles using db2load api

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

Jan 3 '07 #1
2 1347
Vivek wrote:
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.)

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 3 '07 #2
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.

Knut Stolze wrote:
Vivek wrote:
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.)

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 3 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Nanchil | last post: by
3 posts views Thread by nekiv90 | last post: by
3 posts views Thread by claus.hirth | last post: by
4 posts views Thread by John A Grandy | last post: by
reply views Thread by Suresh | last post: by
7 posts views Thread by Vivek | last post: by
reply views Thread by Vivek | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.