Kbase P117396: Getting BAD MM Swap file message connecting to database from ODBC program.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/07/2006 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Getting BAD MM Swap file message connecting to database from ODBC program.
Permissions on working directory of _sqlsrv2 processes is correctly defined to allow files to be created, written to, and read from.
Database structure recently changed to add additional extents.
CAUSE:
The system has run out of file handles.
FIX:
Review the ulimit settings for the owner that started the Primary Database Broker process.
Review the Unix Kernel settings looking for the values which pertain to File Descriptor limits.
Example for HP-UX:
The file /stand/system indicates that maxfiles = 60 and maxfiles_lim = 1024.
These values may be insufficient to launch the Progress executables and touch all the files for the database and network sockets (which may also use file descriptors).
If necessary increase either ulimit (see the Unix man pages for which value to change within ulimit) or the kernel settings related to maximum file descriptors.
Changes to the kernel may require a rebuild of the kernel, or a reboot of the machine, or possibly both.
Changes to the kernel may also be dynamic depending on the operating system.