EXPORT and Transaction Logging

Tracy P

EXPORT and Transaction Logging

I am a bit new to the administrative side of DB2. I'm trying to track down an issue where a process that is running an EXPORT is holding the transaction logs hostage. My understanding is that EXPORTS should not be writing to the transaction logs so I'm a little confused on what I'm missing here. Does the EXPORT Utility log when it starts and completes in the transaction logs or is it something else entirely?

Nadir Doctor

EXPORT and Transaction Logging
(in response to Tracy P)
Hi Tracy,

From your note, it seems this is on linux, unix, windows platform.

When using the export utility, one can include a "select <column_list> from
<schema.table_name> ... with ur" - specifying an isolation level of
uncommitted read at end will minimize any locking conflict.

Nadir




On Mon, Jan 7, 2019 at 11:41 AM Tracy Paben <[login to unmask email]> wrote:

> I am a bit new to the administrative side of DB2. I'm trying to track down
> an issue where a process that is running an EXPORT is holding the
> transaction logs hostage. My understanding is that EXPORTS should not be
> writing to the transaction logs so I'm a little confused on what I'm
> missing here. Does the EXPORT Utility log when it starts and completes in
> the transaction logs or is it something else entirely?
>
> -----End Original Message-----
>

Tracy P

RE: EXPORT and Transaction Logging
(in response to Nadir Doctor)

Yes, this is with Uncommitted Read. 

 

In Reply to Nadir Doctor:

Hi Tracy,

From your note, it seems this is on linux, unix, windows platform.

When using the export utility, one can include a "select from
... with ur" - specifying an isolation level of
uncommitted read at end will minimize any locking conflict.

Nadir




On Mon, Jan 7, 2019 at 11:41 AM Tracy Paben <[login to unmask email]> wrote:

> I am a bit new to the administrative side of DB2. I'm trying to track down
> an issue where a process that is running an EXPORT is holding the
> transaction logs hostage. My understanding is that EXPORTS should not be
> writing to the transaction logs so I'm a little confused on what I'm
> missing here. Does the EXPORT Utility log when it starts and completes in
> the transaction logs or is it something else entirely?
>
> -----End Original Message-----
>

 

Edited By:
Tracy Paben[Organization Members] @ Jan 07, 2019 - 12:56 PM (America/Central)