cancel
Showing results for 
Search instead for 
Did you mean: 

Increase number of messages in the messaging system on SQL Remote

Former Member
0 Kudos
3,073

Hi

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"

Regards Eric

Accepted Solutions (0)

Answers (1)

Answers (1)

regdomaratzki
Product and Topic Expert
Product and Topic Expert

The maximum number of messages in the FILE, FTP and HTTP messaging system is

26 + (26 * 26) + (26 * 26 * 26) = 18,278
As 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.

Reg