ADSM-L

Re: DB2 backup - connection unstable ?

2006-01-24 09:13:49
Subject: Re: DB2 backup - connection unstable ?
From: "Allen S. Rout" <asr AT UFL DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 24 Jan 2006 09:13:30 -0500
>> On Tue, 24 Jan 2006 13:58:59 +0100, Brian Ipsen <bri AT DMSAVE DOT COM> said:


> Hi,

>  I've got an issue with a DB2 database running backup towards a TSM
>  > server... for some wierd reason, it keeps
>  dropping/re-establishing the > connection towards the server...  >
>  The activity log on the server says:


What's your idle timeout?

I've seen one factor that tends to result in dropped sessions in many
environments: botched network at the client side.  If you can get full
bandwidth in and out of the client, then that's not it.

One factor relevant for DB2 is that DB2 sometimes takes a while
twiddling its thumbs between tablespaces.  If your timeout is
sufficiently small, this might give the session time to expire.  But
from your log, that'd have to be a really short time, like in the
minute range or under.  That sounds suspiciously low to me.


- Allen S. Rout

<Prev in Thread] Current Thread [Next in Thread>