Re: Embedded SQL and RPG time out - montioring

Jim Franz <[email protected]> Fri, 10 Apr 2026 10:08:21 -0400
Newsgroups gmane.comp.lang.as400.rpg
Message-ID <CAEVZ15NV509sMYBJD-VhkD=J2oe0GUy2H0zGrPYc_hfQi0w6UA@mail.gmail.com>
YWxzbyBhdmFpbGFibGUKVGhlIHFhcXFpbmkgc2V0dGluZ3MgZm9yIGEgam9iIGNhbiBiZSBvdmVy
cmlkZGVuIGF0IHRoZSBqb2IgbGV2ZWwgKGFuZAphIHdob2xlIGJ1bmNoIG9mIG90aGVyIHNxbCBz
ZXR0aW5ncykKaHR0cHM6Ly93d3cuaWJtLmNvbS9kb2NzL2VuL2kvNy40LjA/dG9waWM9c2Vydmlj
ZXMtb3ZlcnJpZGUtcWFxcWluaS1wcm9jZWR1cmUKCiAgIC0gUVVFUllfVElNRV9MSU1JVAoKSmlt
IEZyYW56CgpPbiBGcmksIEFwciAxMCwgMjAyNiBhdCA5OjM24oCvQU0gUGF1bCBUaGVycmllbiB2
aWEgUlBHNDAwLUwgPApycGc0MDAtbEBsaXN0cy5taWRyYW5nZS5jb20+IHdyb3RlOgoKPiBUaGFu
a3MuIFRoYXTigJlzIGhlbHBmdWwuCj4KPiBQYXVsIFRoZXJyaWVuCj4gRXh0LiAyMjMwCj4gcHRo
ZXJyaWVuQG1iaS1pbmMuY29tCj4KPiBGcm9tOiBEYW5pZWwgR3Jvc3MgPGRhbmllbEBxcGdtci5k
ZT4KPiBTZW50OiBGcmlkYXksIEFwcmlsIDEwLCAyMDI2IDk6MTMgQU0KPiBUbzogcnBnNDAwLWxA
bGlzdHMubWlkcmFuZ2UuY29tCj4gQ2M6IFBhdWwgVGhlcnJpZW4gPHB0aGVycmllbkBtYmktaW5j
LmNvbT4KPiBTdWJqZWN0OiBSZTogRW1iZWRkZWQgU1FMIGFuZCBSUEcgdGltZSBvdXQgLSBtb250
aW9yaW5nCj4KPiBPZiBjb3Vyc2UgUGF1bCAtIHlvdSBjYW4gY29udHJvbCB0aGUgZGlmZmVyZW50
IHRpbWVvdXRzIHdpdGggSFRUUCBvcHRpb25zCj4gLSB0aGlzIGlzIHRoZSBzZWNvbmQgcGFyYW1l
dGVyIG9mIEhUVFBfR0VULiBodM2P4oCL4oCL77u/4oCMzY8KPiBbRXh0ZXJuYWwgZW1haWxdPAo+
IGh0dHBzOi8vc3VtbWFyeS51czEuZGVmZW5kLmVncmVzcy5jb20vdjMvc3VtbWFyeT9yZWY9ZW1h
aWwmY3JJZD02OWQ4ZmMwZDkyMTlmN2Q0ZjMzZTQ0MjAmbGFuZz1lbgo+ID4KPiBFeHRlcm5hbCBl
bWFpbCA8Cj4gaHR0cHM6Ly9zdW1tYXJ5LnVzMS5kZWZlbmQuZWdyZXNzLmNvbS92My9zdW1tYXJ5
P3JlZj1lbWFpbCZjcklkPTY5ZDhmYzBkOTIxOWY3ZDRmMzNlNDQyMCZsYW5nPWVuCj4gPgo+IFtF
eHRlcm5hbCBlbWFpbF08Cj4gaHR0cHM6Ly9zdW1tYXJ5LnVzMS5kZWZlbmQuZWdyZXNzLmNvbS92
My9zdW1tYXJ5P3JlZj1lbWFpbCZjcklkPTY5ZDhmYzBkOTIxOWY3ZDRmMzNlNDQyMCZsYW5nPWVu
Cj4gPgo+Cj4gT2YgY291cnNlIFBhdWwgLSB5b3UgY2FuIGNvbnRyb2wgdGhlIGRpZmZlcmVudCB0
aW1lb3V0cyB3aXRoIEhUVFAgb3B0aW9ucwo+IC0gdGhpcyBpcyB0aGUgc2Vjb25kIHBhcmFtZXRl
ciBvZiBIVFRQX0dFVC4KPgo+Cj4gaHR0cHM6Ly93d3cuaWJtLmNvbS9kb2NzL2RlL2kvNy42LjA/
dG9waWM9ZnVuY3Rpb25zLWh0dHAtZ2V0LWh0dHAtZ2V0LWJsb2IjcmJhZnpzY2FodHRwZ2V0X19I
VFRQX29wdGlvbnMKPiA8Cj4gaHR0cHM6Ly93d3cuaWJtLmNvbS9kb2NzL2RlL2kvNy42LjA/dG9w
aWM9ZnVuY3Rpb25zLWh0dHAtZ2V0LWh0dHAtZ2V0LWJsb2IjcmJhZnpzY2FodHRwZ2V0X19IVFRQ
X29wdGlvbnMKPiA+Cj4KPiBZb3Ugc2hvdWxkIGV4cGVyaW1lbnQgd2l0aAo+Cj4gICAtIGNvbm5l
Y3RUaW1lb3V0Cj4gICAtIGlvVGltZW91dAo+Cj4gYW5kIHNldCB0aGUgdGltZW91dHMgdG8geW91
ciBuZWVkcyAtIGFuZCB0aGVuIGNoZWNrIHRoZSBTUUwgY29kZSBhbmQgc3RhdGUuCj4KPiBIVEgK
PiBEYW5pZWwKPgo+Cj4KPiBBbSAxMC4wNC4yMDI2IHVtIDE1OjA1IHNjaHJpZWIgUGF1bCBUaGVy
cmllbiB2aWEgUlBHNDAwLUwgPAo+IHJwZzQwMC1sQGxpc3RzLm1pZHJhbmdlLmNvbTxtYWlsdG86
cnBnNDAwLWxAbGlzdHMubWlkcmFuZ2UuY29tPj46Cj4g77u/SXMgdGhlcmUgYSB3YXkgaW4gUlBH
IHdpdGggU1FMIHRvIHBsYWNlIGEgdGltZW91dCBvbiBhbiBzcWwgc3RhdGVtZW50Lgo+IFdlIGFy
ZSB1c2luZyBTUUwgdG8gaW50ZXJmYWNlIHdpdGggVmVydGV4IGFuZCB3ZSBoaXQgYW4gaXNzdWUg
d2hlcmUgdGhlCj4gcmVxdWVzdCB0byB2ZXJ0ZXggbmV2ZXIgcmV0dXJuZWQgd2l0aCBhIHJlc3Bv
bnNlLiAgVGhlcmUgd2FzIG5vIGVycm9yLCB0aGUKPiBleGVjIHNxbCBqdXN0IHNhdCB0aGVyZToK
Pgo+ICAvLyBTZW5kIHJlcXVlc3QgJiByZWNlaXZlIHJlc3BvbnNlLiBNb3ZlIHJlc3BvbnNlIGlu
dG8gcmVzcG9uc2VUZXh0Cj4gICBleGVjIHNxbAo+ICAgICAgIHZhbHVlcyBxc3lzMi5IVFRQX1BP
U1QgKHRyaW0oOnVybCksIDpyZXF1ZXN0VGV4dCkKPiAgICAgICBpbnRvIDpyZXNwb25zZVRleHQ7
Cj4KPiBJcyB0aGVyZSBhIHdheSB0byBmb3JjZSB0aGUgU1FMIHRvIGVycm9yIG91dCBvciB0aW1l
IG91dD8KPiBJcyB0aGVyZSBhIHdheSB0byBmb3JjZSBxc3lzMi5IVFRQX1BPU1QgdG8gdGltZW91
dD8KPgo+Cj4gVGhhbmtzIGZvciBhbnkgaGVscC4KPgo+IFBhdWwKPiAtLQo+IFRoaXMgaXMgdGhl
IFJQRyBwcm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdAo+IFRvIHBv
c3QgYSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5jb208bWFpbHRvOgo+
IFJQRzQwMC1MQGxpc3RzLm1pZHJhbmdlLmNvbT4KPiBUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJl
LCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAo+IHZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdl
LmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQwMC1sPAo+IGh0dHBzOi8vbGlzdHMubWlkcmFuZ2Uu
Y29tL21haWxtYW4vbGlzdGluZm8vcnBnNDAwLWw+Cj4gb3IgZW1haWw6IFJQRzQwMC1MLXJlcXVl
c3RAbGlzdHMubWlkcmFuZ2UuY29tPG1haWx0bzoKPiBSUEc0MDAtTC1yZXF1ZXN0QGxpc3RzLm1p
ZHJhbmdlLmNvbT4KPiBCZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2
aWV3IHRoZSBhcmNoaXZlcwo+IGF0IGh0dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vcnBnNDAw
LWw8Cj4gaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9ycGc0MDAtbD4uCj4KPiBQbGVhc2Ug
Y29udGFjdCBzdXBwb3J0QHN1cHBvcnQubWlkcmFuZ2UuY29tPG1haWx0bzoKPiBzdXBwb3J0QHN1
cHBvcnQubWlkcmFuZ2UuY29tPiBmb3IgYW55IHN1YnNjcmlwdGlvbiByZWxhdGVkIHF1ZXN0aW9u
cy4KPiAtLQo+IFRoaXMgaXMgdGhlIFJQRyBwcm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwp
IG1haWxpbmcgbGlzdAo+IFRvIHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5t
aWRyYW5nZS5jb20KPiBUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBv
cHRpb25zLAo+IHZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3Rp
bmZvL3JwZzQwMC1sCj4gb3IgZW1haWw6IFJQRzQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2Uu
Y29tCj4gQmVmb3JlIHBvc3RpbmcsIHBsZWFzZSB0YWtlIGEgbW9tZW50IHRvIHJldmlldyB0aGUg
YXJjaGl2ZXMKPiBhdCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29tL3JwZzQwMC1sLgo+Cj4g
UGxlYXNlIGNvbnRhY3Qgc3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNj
cmlwdGlvbiByZWxhdGVkCj4gcXVlc3Rpb25zLgo+Cj4KLS0gClRoaXMgaXMgdGhlIFJQRyBwcm9n
cmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdApUbyBwb3N0IGEgbWVzc2Fn
ZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tClRvIHN1YnNjcmliZSwgdW5zdWJz
Y3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMsCnZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJh
bmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQwMC1sCm9yIGVtYWlsOiBSUEc0MDAtTC1yZXF1
ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQpCZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21l
bnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwphdCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29t
L3JwZzQwMC1sLgoKUGxlYXNlIGNvbnRhY3Qgc3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBm
b3IgYW55IHN1YnNjcmlwdGlvbiByZWxhdGVkIHF1ZXN0aW9ucy4KCg==