How does one increase the number of messages in the messaging system on SQL remote since we keep getting the message "The maximum number of messages in the messaging system has been reached"
asked 04 Oct '16, 05:19
The maximum number of messages in the FILE, FTP and HTTP messaging system is
26 + (26 * 26) + (26 * 26 * 26) = 18,278As opposed to asking how to increase the number of messages, IMHO, the better question is why are so many messages being generated and not being picked up? Are remotes hainvg trouble picking up messages, is there a massive amount of data being transfered, or is it maybe a combination of both of those things?
To answer your immediate question, there is no way to increase the maximum number of messages, but you can increase the size of the messages with the -l switch. This switch will need to be change and both the sending side and the receiving side. The default message size is 50kb (pre-compressed), so increasing this value won't allow you to increase the maximum number of messages, but will allow you to send more data with the number of messages that are allowed.