We have a program(running in LPAR1) which is accessing table A on LPAR2. The same querry at local server takes time say x, but when run from remote server is taking time 1.6x.
We are using SNA for cross platform access.
Can anyone please suggest the possible reasons and measures to be taken? Also if we use DRDA instead of SNA, will it be of any use?
Thank you for your input. I understand that with remote access there will be overhead. But there must be measures to keep this overhaed at minimum. Any suggestions to bring down the oveahead will be of great help. The program will pull around 12k rows from remote table.
We don't want to replicate the remote table at the local site, due to space constraint.