Kbase P97052: dbman not working
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2008 |
|
Status: Verified
SYMPTOM(s):
dbman not working
dbman returns database is running: false
admserv.log file shows error 1093 when running dbman against this database
Warning: only 250 wait semaphores are available.(1093)
Database is set up in conmgr.properties
Environment variables for DLC and PATH have been set correctly
FACT(s) (Environment):
UNIX
Progress/OpenEdge Product Family
CAUSE:
Database has never been started by dbman, so it makes sense that status is reported as false because dbman is not aware of proserve'd databases.
The reason that the 1093 error is returned when running dbman against this database is that when using dbman, it references the conmgr.properties file, where the setting for -n against this database is higher than the default (20) -n used when proserve is issued against this database. So when reading the conmgr.properties we try to allocate more SEM* and errors out because the system settings for semaphores is not high enough.
FIX:
STEPS:
1.) Address the SEM* parameters, for example on Linux in /proc/sys/kernel/sem
and make the changes permanent at the next reboot in /etc/sysctl.conf
2a) Stop the databases,
2b) Stop and Restart the AdminServer,
2c) Start the databases which are managed through the AdminServer with dbman commands