Thanks for the suggestion. Will try these settings and let you
Sent from Mail for Windows 10
From: Ian Bjorhovde
Sent: 05 February 2019 00:23
To: [login to unmask email]
Subject: [DB2-L] - RE: How to continue a load activity over brief
This is a system issue, not a database issue, so you should talk to
your Linux system administrator.
You should check your filesystem’s settings for the
‘timeo’ and ‘retrans’ option.
Alternatively, you can use an NFS hard mount, which means that any
I/O calls will wait forever and won’t timeout. This is
probably not recommended if you have an unreliable network.
IBM Gold Consultant
On Feb 1, 2019, at 11:48 AM, Harishkumar .Pathangay
<[login to unmask email]> wrote:
I have a db2 [18.104.22.168] database on server1. server1 also has a nfs
mount point /var/nfs.
I load data to a table from /var/nfs/db2share/1gb.del
after I start load activity in db2 server itself [it is a local
application performing the load], the nfs network went down very
briefly for about 20 seconds, but it came back with in the next 10
seconds. the network down time was only less than 30 seconds. but
still load utility is saying disk error occurred. it is not able to
sense the availability of the network back again and continue the
I can manually restart the load, but if there is any timeout
parameter I can specify to influence db2 load utility so that it
can load the data again even if the network was down briefly say 30
seconds. I do not want to restart load manually every time if there
is mild network availability issues.
I tried, db2 registry variables - DB2IQTIME=120 and
DB2RQTIME=180. but it did not work. I am not even sure that setting
would help me in this situation. please let me know.
-----End Original Message-----
Site Links: View post online View mailing list
online Start new thread via email
Unsubscribe from this mailing list Manage your
This email has been sent to: [login to unmask email]
ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning,
Log Analysis, TDM & more.
BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job
done faster & easier than ever.
Use of this email content is governed by the terms of service