AS/400 listeners at some point stop working

, ,
1

Hi,
We have AS/400 adapter that we use to connect to data queues and pull data for processing. It seams like at some point they stop working and I have to reset them and everything back to normal. Here the setting:

Connection Type DATAQUEUE
Adapter Type AS400Adapter
Connection Properties
Server Name server
User user
Password password
Initialization Service
Current Library
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 50
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000

Any help is welcome! Thanks in advance.

2

The min pool size in production should always be 0. This avoids stale connections.

The block and expire timeouts of 1 second are probably far too short. Increase those as appropriate for your environment.

3

Rob,

Thanks for the suggestion. I can not change “Minimum Pool Size” to zero, because right away I receive error “Enable Connection Pooling” can not be set to “true”. It has worked just fine for about 5 years. It is fine to set it to zero for JDBC adapter and we have it, but for AS400 adapter does not work. Any other idea> Thank you.

4

That’s an odd error. If it cannot set “Enable Connection Pooling” to true, then min/max connections are meaningless. But your posted config shows that it is true. I’m confused.

My suggestion was based on the suspicion that the resource to which the adapter connects was reset/restarted for some reason. Thus, the adapter connection was stale and for whatever reason it cannot move past that. My suspicion may be off, however.

If tweaking the connection parameters doesn’t do the trick (or cannot be done!) then it’s probably time to open a ticket with support.