Troubleshooting WAS 8.5.5.19 Connection to DB2 on i
"Jacob Banda" <[email protected]>
| Newsgroups | gmane.comp.lang.as400.java |
|---|---|
| Message-ID | <[email protected]> |
We have an app that runs on Websphere (v8.5.5 FP19). This app functions on Server A, but has quirks. When attempting to perform process X on the app, it takes a VERY long time to complete. On the developer's box, it has no issue. We redeployed the app to Server B for testing under WAS 7.0.0 FP45, and it works fine there. Both are Windows servers with minimal differences in network configuration. This app opens connections to DB2 on i (V7R4, PTFs current as of 6/18/21). The development team though it was network related, so I went down my list and performed traces on both Windows (Wireshark) and the IBM box (TRCCNN). Both show the exact same thing: traffic flowing successfully, but then several pairs of PSH,ACK packets with a "TCP ACKed unseen segment" message. I'm 99% sure it is not network related, as both Server A and Server B are successful in opening database connections, ping times are down to less than 1 ms, and routes are defined appropriately. I can't explain that string of packets, however. Supposedly they are placeholders when viewing in Wireshark that indicate data was not captured, but received by the sender of the ACKs. They say the typical cause for this is a poor capture, but I don't really think that is the case here. We have scoured the SystemOut and SystemErr logs, enabled toolbox trace, and examined the job logs for the connection pool. We have also used SQL Performance Center in ACS to review the queries running at the time of the bad process (Process X) in the app, but according to the developers, nothing stands out and I/O time is acceptable. Is there something else you all can recommend as far as logging is concerned? I'm trying to get as much information out of this issue as possible. I know the simple answer is that there is something wrong with the WAS 8.5.5 configuration, but we can't figure out what it is. TIA. ----------------------------------------- Jacob Banda ----------------------------------------- -- This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org Before posting, please take a moment to review the archives at https://archive.midrange.com/java400-l. Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com