Kbase P133720: Retrieving records from a second database that is connected to using a CONNECT statement within an A
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/22/2010 |
|
Status: Verified
SYMPTOM(s):
Retrieving records from a second database that is connected to using a CONNECT statement within an ABL program is slow.
Record retrieval from the first database, connected to by using the -db <database name> parameter of the mpro command, is fast.
Record retrieval from the second database, connected to using a CONNECT statement within the ABL program, is slow.
FACT(s) (Environment):
The ABL program uses a CONNECT statement to connect to a second database.
At some point in the past, records retrieved from both databases was fast.
IBM AIX
Progress 9.1E
CHANGE:
The /etc/resolv.conf file was modified by adding several new DNS servers.
CAUSE:
The additional servers defined in the /etc/resolv.conf file cause a longer search time to resolve the host name supplied in the CONNECT statement within the ABL program. The additional servers were added in front of existing entries.
FIX:
Reorder the entries in the /etc/resolv.conf file so that the the host referenced in the CONNECT statement is found first.