DSXchange

No luck Chullet.
Opened a PMR with IBM, they are still looking into it.

No Paul, process 15890 is gone after 8-9 hours.

Only PID 15835 is left.

Hi, I tried with below command dsjob -run -paramfile <Param file> -warn 10 -jobstatus <project Name> <Job Name> Still same behavior, even after completion of parallel job in director, still continues to have the PID for dsjob active in Unix. Observation: I see below PIDs returned till around 7 hours...

Hi, I am running a parallel job which listens to Message queue continuously. This job is triggered thru Autosys using below command. dsjob -run -paramfile <param file> -wait -warn 10 -jobstatus <Project Name> <Parallel Job Name> When an "End of message" is pushed on to the queue (after 12 ...

Is my question too vague?
Please let me know, if more details are required.

Thanks

Requirement: We have two queue managers (one is active, other is fail over). When the active queue manager is down, ETL job should automatically switch to fail over queue manager. Is this possible to in MQ connector stage provided in DS version 8.1? if so, can you please advice steps to do the same....

Issue: If push one message into the queue, and run DS job that reads data from MQ. This message is being read from queue(deleted from queue), but not passed to down stream stages (oracle DB stage); unless I push second message into the queue, then both the messages are being pushed to down stream s...

Finally, I got a way to push custom message (Ex: "Shutdown job") into queue with user defined message type (Ex: 999888). To do this, I developed a datastage job with MQ connector as target stage, hard coded message type into field with data element WSMQ.MSGTYPE. Below issue was still unres...

Ernie, I am looking exactly for the solution suggested in this topic: http://www.dsxchange.com/viewtopic.php?t=125733 Can you please advice me in detail, what options should I set in the MQ connector stage (DS version 8.1)? Also, please suggest what is message I should put on the queue to test the s...

Ernie, When you mean message count, is it property "Record Count" under "Transaction", if so, yes, I am setting this property as '1'. Transaction -> Record Count: 1 Message read mode: Delete Interestingly, as soon as one message is inserted into the MQ, its getting deleted from M...

Thanks Ernie, Now, I am trying to run MQ job continuously below options. Job is running good, data is being loaded. But, one interesting issue is, unless I push two messages into queue, data is not flowing to DB stage. If I push third message, job is waiting until I push fourth message. Kind of odd/...

Enrie, Thanks a lot for detailed response. I unit tested with small values for wait time of MQ connector and its working good. I modified values as you suggested to run continuously and its working good. Can you please explain importance of "End of data message type"; I did not understand ...

Thanks Chulett.

I am still waiting for answer

Hello, I have a requirement to consume messages from MQ continuously as and when available. As per suggestions in this topic, I developed DS job as below. MQ Connector stage ----> Transformer -----> Oracle Connector Stage MQ Connector stage with properties as below Access Mode: As in queue definitio...

Hello, We are looking to build a datastage job to read BAI file and load into DB. Just a quick info on BAI file "BAI, or the BAI file format, is a file format for performing electronic cash management balance reporting. The BAI format was developed and previously maintained by the Bank Administ...