×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
To add FUD you could look at entry 14 at
https://www-01.ibm.com/support/docview.wss?uid=nas4SF98198&myns=ibmi&mynp=OCSSTS2D&mync=E&cm_sp=ibmi-_-OCSSTS2D-_-E
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Steinmetz, Paul via MIDRANGE-L
Sent: Wednesday, February 6, 2019 11:10 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
Subject: RDBIMPORT weirdness - Fails on every 3rd or 4th attempt
We're using RDBIMPORT (RDB40 from Prodata) to pull a 3 million record file daily.
Remote is MYSQL on a Linux server.
Normal good run is 10-12 minutes.
Fails on every 3rd or 4th attempt, around 2.6 million records, or less.
Failure occurs around 5-7 minutes.
Nothing done after failure.
Next attempt after failure is successful.
Recreated issue on R&D LPAR connecting to a different remote with a different MYSQL.
V7R3 latest cum and groups.
Latest version of RDB40.
RDBIMPORT uses RDBCONNECT which runs JVM 1.8.0.191 32 bit.
Engaged RDB support, nothing yet.
Turned on debug/trace, normal, nothing there.
Any thoughts from the group?
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx<mailto:psteinmetz@xxxxxxxxxx>
http://www.pencor.com/
midrange.com
