IMPORT with MESSAGES ON SERVER

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gregor Kovač - 27 Oct 2006 14:54 GMT

Hi!

If I do IMPORT with ADMIN_CMD procedure and use MESSAGES ON SERVER option
with IMPORT where are those messages stored?
I know ADMIN_CMD returns a result set for IMPORT and an SQL I can get
messages and remove them. Do I have to use the remove part to delete
messages or not? I'm afraid that if I don't use the remove part something
will get bigger and bigger and this will impact performance.

Best regards,
Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

Reply to this Message

Serge Rielau - 27 Oct 2006 16:21 GMT

Gregor Kovac( wrote:

> Hi!
>
[quoted text clipped - 4 lines]
> messages or not? I'm afraid that if I don't use the remove part something
> will get bigger and bigger and this will impact performance.

Have you checked the directory where your db2dial.log goes? That's at
least where I would look first...

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

Gregor Kovač - 27 Oct 2006 17:17 GMT

> Gregor Kovac( wrote:
>> Hi!
[quoted text clipped - 10 lines]
> Cheers
> Serge

Yes, but there is nothing in there. Well, nothing of interest.
I didn't find any files or anything that would contain messages about how
many rows were read from a particular file, how many were rejected and
why, ....

Best regards,
Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

Reply to this Message

Serge Rielau - 27 Oct 2006 20:10 GMT

Gregor Kovac( wrote:

>> Gregor Kovac( wrote:
>>> Hi!
[quoted text clipped - 15 lines]
> many rows were read from a particular file, how many were rejected and
> why, ....

Looking at this closer it appears the file is written to:
DB2_UTIL_MSGPATH
And it also appears that the caller is responsible to invoke teh SQL in
MSG_REMOVAL to delete the file.
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.d
oc/doc/r0023575.htm

All booksense on my end though...

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

riedel - 30 Oct 2006 10:03 GMT

Serge Rielau schrieb:

> Gregor Kovac( wrote:
>
[quoted text clipped - 12 lines]
> Cheers
> Serge

does db2 phone home now?

Reply to this Message

Gregor Kovač - 30 Oct 2006 11:54 GMT

> Serge Rielau schrieb:
>> Gregor Kovac( wrote:
[quoted text clipped - 15 lines]
>
> does db2 phone home now?

If you set it up correctly it does. :))) I meant db2diag.log.

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

Reply to this Message