Kbase P8939: Error 43 when connecting to multiple databases from batch script.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
HP-UX 11 32-bit
Progress 9.1D
SYMPTOM(s):
Error 43 when connecting to multiple databases from batch script:
Cannot find or open file <file-name>, errno = <number>. (43)
Cannot find or open file <file-name>, errno = 24. (43)
Databases start ok when started manually.
CAUSE:
Errno 24 ("Too many open files") in the 43 indicates a resources problem. The issue can be caused by not enough file descriptors being available for use.
FIX:
1. The ulimit command can be used to display and change certain resource limits -
ulimit -a shows all the existing limits that can be modified by the ulimit command.
ulimit -n shows the number of file descriptors available.
2. Increase the number of file descriptors using the ulimit -n command, e.g. if ulimit -n returns 1024, the command
ulimit -n 2048
will increase this limit on the fly.
3.- If a permanent fix is required, increase the kernel parameter maxfiles; this is limited by the maxfiles_lim parameter.
4.- In some extreme cases where a large number files are opened it may be necessary to increase nfile if the previous steps didn't work.