RE: Sever pulling a bazillion rows from IBMi via JDBC (I think)

Charles Wilt <[email protected]> Tue, 2 Sep 2025 08:44:39 -0600
Newsgroups gmane.comp.lang.as400.java
Message-ID <CAJ=Tnc6WFM3+Wo-LfbunuoFzDL-wXODPMMaW0Ut7ZrdcgU45kw@mail.gmail.com>
V291bGQgYmUgaGVscGZ1bCB0byBzZWUgdGhlIEphdmEgY29kZSBiZWluZyB1c2VkLgpQb3NzaWJs
ZSB0aGF0IHRoZSB3YXkgaXQncyB3cml0dGVuIGhhcyBhIGxvdCB0byBkbyB3aXRoIHRoZSBzbG93
bmVzcy4KCk5vdCBpbmNsdWRpbmcgYW4gT1JERVIgQlkgaXMgYWx3YXlzIGdvaW5nIHRvIGJlIGZh
c3Rlci4uLgpBbHNvIG1ha2Ugc3VyZSB0aGF0IEZPUiBGRVRDSCBPTkxZIFdJVEggTkMgaXMgc3Bl
Y2lmaWVkLgoKU29tZSBKREJDIHByb3BlcnRpZXMgdG8gY29uc2lkZXIKaHR0cHM6Ly9qYXZhZG9j
LmlvL3N0YXRpYy9uZXQuc2YuanQ0MDAvanQ0MDAvMjEuMC4wL2NvbS9pYm0vYXM0MDAvYWNjZXNz
L2RvYy1maWxlcy9KREJDUHJvcGVydGllcy5odG1sCiJibG9jayBjcml0ZXJpYSIKImJsb2NrIHNp
emUiCiJkYXRhIGNvbXByZXNzaW9uIgoicmVjZWl2ZSBidWZmZXIgc2l6ZSIKInRjcCBubyBkZWxh
eSIKCkFuIGFsdGVybmF0aXZlIHRvIHVzaW5nIGJsb2NrIHNpemUsIGlzIHRvIHVzZSBzZXRGZXRj
aFNpemUKaHR0cHM6Ly9qYXZhZG9jLmlvL3N0YXRpYy9uZXQuc2YuanQ0MDAvanQ0MDAvMjEuMC4w
L2NvbS9pYm0vYXM0MDAvYWNjZXNzL0FTNDAwSkRCQ1N0YXRlbWVudC5odG1sI3NldEZldGNoU2l6
ZS1pbnQtCgpOb3Qgc3VyZSBvZmYgdGhlIHRvcCBvZiBteSBoZWFkIGlmIHRoYXQgd291bGQgZ2l2
ZSB5b3UgYSBsYXJnZXIgc2V0IG9mCnJlY29yZHMgdGhhbiBhIDUxMiBibG9jayBzaXplLgpOb3Rl
IHRoYXQgdG8gdXNlIGl0LCBibG9jayBzaXplIG11c3QgYmUgMC4KCkhUSCwKQ2hhcmxlcwoKLS0t
LS0tLS0tLSBGb3J3YXJkZWQgbWVzc2FnZSAtLS0tLS0tLS0KRnJvbTogPHNtaXRoNTY0Nm1pZHJh
bmdlQGdtYWlsLmNvbT4KRGF0ZTogVHVlLCBTZXAgMiwgMjAyNSBhdCA3OjUy4oCvQU0KU3ViamVj
dDogU2V2ZXIgcHVsbGluZyBhIGJhemlsbGlvbiByb3dzIGZyb20gSUJNaSB2aWEgSkRCQyAoSSB0
aGluaykKVG86IE1pZHJhbmdlIFN5c3RlbXMgVGVjaG5pY2FsIERpc2N1c3Npb24gPG1pZHJhbmdl
LWxAbGlzdHMubWlkcmFuZ2UuY29tPgoKCldlIGhhdmUgYSBzZXJ2ZXIgdGhhdCBpcyBwdWxsaW5n
IGEgYmF6aWxsaW9uIHJvd3MgdmlhIEpEQkMgKEkgdGhpbmspIGRhaWx5LgpVbmZvcnR1bmF0ZWx5
LCB3ZSBhcmUgc3R1Y2sgd2l0aCB0aGlzIHByb2Nlc3MgYXMgaXMgZm9yIGEgd2hpbGUgdW50aWwg
d2UgY2FuCmdldCBhIHByb2plY3Qgb24gdGhlIHBsYW4gdG8gcHVsbCBvbmx5IG5ldCBjaGFuZ2Vz
LiAgSXQgY3VycmVudGx5IHJ1bnMgZm9yCjItMyBob3VycyBlYWNoIGRheS4KCgoKV2hhdCBpcyB0
aGUgZmFzdGVzdCB3YXkgdG8gcHVsbCB0aGlzIGRhdGE/ICBXaWxsIGl0IGJlIGZhc3RlciB0byBv
bWl0IHRoZQpvcmRlciBieSBjbGF1c2UgYW5kIGp1c3QgbGV0IFNRTCBoYW5kIGJhY2sgZGF0YSBp
biB3aGF0ZXZlciBvcmRlciB0aGF0IGl0CndhbnRzIG9yIHdvdWxkIGl0IGJlIHF1aWNrZXIgdG8g
YWRkIGFuIG9yZGVyIGJ5IGNsYXVzZS4gIEl0IHNlZW1zIGxpa2UKaGF2aW5nIGFuIG9yZGVyIGJ5
IGNsYXVzZSB3b3VsZCBzbG93IGl0IGRvd24gYmVjYXVzZSB0aGUgZmlsZSBpcyBub3QgaW4gYW55
CnBhcnRpY3VsYXIgc2VxdWVuY2UgYnV0IEkgYWxzbyBkaWRuJ3Qga25vdyBpZiBhbiBvcmRlciBi
eSBSUk4gd291bGQgaGVscC4KCgoKQW55IHRob3VnaHRzIChvdGhlciB0aGFuIHJld3JpdGluZyB0
aGUgcHJvY2VzcyB3aGljaCBpcyBpbiB0aGUgcGxhbnMgYnV0CnByb2JhYmx5IG5vdCBmb3IgdGhp
cyB5ZWFyKT8KCi0tIApUaGlzIGlzIHRoZSBNaWRyYW5nZSBTeXN0ZW1zIFRlY2huaWNhbCBEaXNj
dXNzaW9uIChNSURSQU5HRS1MKSBtYWlsaW5nIGxpc3QKVG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6
IE1JRFJBTkdFLUxAbGlzdHMubWlkcmFuZ2UuY29tClRvIHN1YnNjcmliZSwgdW5zdWJzY3JpYmUs
IG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMsCnZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNv
bS9tYWlsbWFuL2xpc3RpbmZvL21pZHJhbmdlLWwKb3IgZW1haWw6IE1JRFJBTkdFLUwtcmVxdWVz
dEBsaXN0cy5taWRyYW5nZS5jb20KQmVmb3JlIHBvc3RpbmcsIHBsZWFzZSB0YWtlIGEgbW9tZW50
IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKYXQgaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9t
aWRyYW5nZS1sLgoKUGxlYXNlIGNvbnRhY3Qgc3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBm
b3IgYW55IHN1YnNjcmlwdGlvbiByZWxhdGVkCnF1ZXN0aW9ucy4KLS0gClRoaXMgaXMgdGhlIEph
dmEgUHJvZ3JhbW1pbmcgb24gYW5kIGFyb3VuZCB0aGUgSUJNIGkgKEpBVkE0MDAtTCkgbWFpbGlu
ZyBsaXN0ClRvIHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBKQVZBNDAwLUxAbGlzdHMubWlkcmFuZ2Uu
Y29tClRvIHN1YnNjcmliZSwgdW5zdWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMsCnZp
c2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL2phdmE0MDAt
bApvciBlbWFpbDogSkFWQTQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCkJlZm9yZSBw
b3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVzCmF0IGh0
dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vamF2YTQwMC1sLgo=