Hi,
We have a job to write request string to a Message Queue Request Queue.Our job design is given below
Oracle Connector ----->Transformer------>MQConnector
We have to cleanse around 300000 records and we are passing 10 records at a time to queue in a loop (loop logic is written in sequence).But after cleansing around 10,000 requests the message queue service is getting down because the requests are not getting expired even though we are getting responses.
Please let us know whether we have any option to set expiry time for request while we place the request in datastage
Thanks,
Mani
Expiry Time for message queue request
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Thu Jan 15, 2015 5:21 am
- Location: India
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Hello Mani,
The property is at the Queue Manager level, probably you won't see it while using the connector as a target.
Normally expired messages should be discarded by any MQGET command issued by a consumer, in your scenario best approach will be to set the expire Interval (EXPRYINT) on the Queue Manager if you could ask the MQ administrator to find out if your version allow this setting or if the value needs to be adjusted
Regards
The property is at the Queue Manager level, probably you won't see it while using the connector as a target.
Normally expired messages should be discarded by any MQGET command issued by a consumer, in your scenario best approach will be to set the expire Interval (EXPRYINT) on the Queue Manager if you could ask the MQ administrator to find out if your version allow this setting or if the value needs to be adjusted
Regards
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
-
- Participant
- Posts: 17
- Joined: Thu Jan 15, 2015 5:21 am
- Location: India
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
-
- Participant
- Posts: 17
- Joined: Thu Jan 15, 2015 5:21 am
- Location: India
Hi Rodriguez,
Thanks for your response.
We are trying to clear the messages put in the queue by datastage only and not trying to clear the messages from any other application. Has it needs to be cleared from queue level or setting the expiry time in datastage will automatically clear the messages in queue?
Thanks
Mani
Thanks for your response.
We are trying to clear the messages put in the queue by datastage only and not trying to clear the messages from any other application. Has it needs to be cleared from queue level or setting the expiry time in datastage will automatically clear the messages in queue?
Thanks
Mani