I think the slowdown is RPG record level access to a DDM file over a VPN. If I SQL the file, I get the records back in a few seconds. I try to write an SQLRPGLE program and use embedded SQL statements and I get an SQL0805 when I open the cursor. I change the program to SQL a local file and it works fine. Is there a reason why you can't access DDM files with embedded SQL in an RPG program?
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jack Woehr via MIDRANGE-L
Sent: Thursday, December 21, 2023 9:23 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: DDM over VPN
CAUTION: This email originated from outside your organization. Exercise caution when opening attachments or clicking links, especially from unknown senders.
I'm sure someone knows more about this than I do, but sounds like it may be data getting encrypted/decrypted twice, one by ddm, once by VPN.
On Thu, Dec 21, 2023, 07:04 Bob Snuggs <bsnuggs@xxxxxxxxxxxx> wrote:
Has anyone ever done heavy DDM I/Os between 2 AS/400s connected by a VPN
over the general internet instead of using an MPLS connection? We're
trying to set this up and it takes 400 seconds to read 10,000 records
via DDM as opposed to 4 seconds between 2 on-prem AS/400s. I'm just
trying to figure out if this is normal or not. I don't see how it
could be. All other traffic doesn't appear to be an issue.
Any feedback would be greatly appreciated.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fmidrange-l&c=E,1,Yn1OA2Reox94SqrOhkWiuFmS6Awgm4AVzL4ndah7INnE_bPk27iqB_ciE_Kfk5NLV8adXqEt-RzGF5CKB-9hpvsIWWri0CpSlDJW1SAP6Ptvn41g6PaL&typo=1
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fmidrange-l&c=E,1,bNybQbDcHHpHZnD85RdDW8ZBxHjPU3vvWyoWPRQoVN_NGcSaFXS4hRV71OQr728lYjXTbEel2milSFEbA2lPnGc95vfL96Iw5UYjsGRK9nY31tQ_ClH5Fw,,&typo=1.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
midrange.com
