-
Title
"cannot fork: no swap space" warning when starting Sybase agent -
Description
After installing a Sybase MDA agent on Sybase ASE 15 on a AIX host, the following error in AIX is observed:
cannot fork: no swap space
The following lines may be observed in the MDA agent log:
<SybaseCartridge/5.5.8.39/Sybase_MDA/Sybase_MDA_on_MyServer.Mycompany.com-agent> ERROR [JFogbankAgentSocketListeners[20]-0] com.quest.glue.core.jfogbank.JFogbankAgentImpl - Agent log: There are missing MDA parameters, some collections may not work. Missing parameters list=[ statement cache size]
and/or
<SybaseCartridge/5.5.8.39/Sybase_MDA/Sybase_MDA_on_MyServer.Mycompany.com-agent> ERROR [JFogbankAgentSocketListeners[20]-0] com.quest.glue.core.jfogbank.JFogbankAgentImpl - Agent log: Collection [TopSQL_callback] is ready to run but the following items will not be collected: [Top Hash dashboard] [Top Hash dashboard]
-
Cause
-
Resolution
Execute the following command in ISQL or similar client session and restart the Sybase MDA agent:
sp_configure 'statement cache size'
— example: sp_configure 'statement cache size', 0, '50M'
-
Additional Information
The following tables list proprietary Sybase flags and the Sybase_MDA agent tables that are dependent upon them. If any of the settings do not have values that fall in the recommended value range, data collection will issue complaints and fail to collect successfully, indicating that some MDA table collection was canceled as a result of one or more flags being set incorrectly. To prevent these alerts from occurring, use the appropriate Data Management properties to disable the collection that is failing to collect. Below is a listing of Sybase_MDA agent tables and the configuration settings on which they depend: Foglight Table -Sybase MonTable (MDA) Configuration Settings TopHash enable stmt cache monitoring = 1 statement cache size = size_of_cache enable literal autoparam = 0 or 1 Note: Setting enable literal autoparam to 0 causes Sybase to treat each SQL statement separately; setting it to 1 produces bind variables for each search argument in an SQL statement. ....