MQ; queue depth check via DS job
Posted: Tue Jul 01, 2008 3:25 pm
Hi
We are using DataStage 7.5 on AIX 5.1
In our job we are pulling data from MQ stage. We are expecting about 100K messages by year end....
We r working on loop approach to read 5000 messages at a time, perform xml parsing and load to target and after that running 2nd job to perform destructive read with 5000 messages. So, we can occupy less memory.
Wondering is it anyway we can check qdepth() and control the loop to terminate when there are no messages into MQ??
Thanks..
We are using DataStage 7.5 on AIX 5.1
In our job we are pulling data from MQ stage. We are expecting about 100K messages by year end....
We r working on loop approach to read 5000 messages at a time, perform xml parsing and load to target and after that running 2nd job to perform destructive read with 5000 messages. So, we can occupy less memory.
Wondering is it anyway we can check qdepth() and control the loop to terminate when there are no messages into MQ??
Thanks..