DSXchange

Hi All, One of my DataStage Parallel job got stuck without any progress and when i checked the director there was a warning in the job log: DSD.INTclose unable to open VOC file. As this job is in production, i didn't have much time to go through the log details and restart the batch immediately. I h...

Hi All, Thanks for the information. We were able to engage network team to see what exactly is happening on the Server when the job is running for a long time. We could see some of the packets were getting dropped. The Query completed successfully on database side could see the message "SQL*Net...

Hi Ray, Sorry for missing the requested information. Here are contents of Configuration file and disk usage: { node "node1" { fastname "XXXXXXX.YYYYYYY.ZZZZZZZ" pools "" resource disk "/opt/IBM/Datasets1" {pools ""} resource disk "/opt/IBM/Datas...

Thanks Craig, When ever we face the issue of long running job, the CPU utilization clocks 99% . Now we are considering the timings when the job is getting triggered is causing the problem. Ray, We are using a default.apt configuration file which is indeed pointing to Node01.apt we have 2 Resource Di...

Hi All, My question is regarding a weird issue we are facing in datastage with respect to extracting data from an oracle table. We are extracting around two hundred and fifty million records from the table and loading it into a dataset. some days the job finishes in 19 minutes with 200k rows/sec and...

I was thinking of something below. Any suggestions would be helpful. 1. Create Java Class to reuqest and response functions by connecting to ActiveMQ. 2. Integrate the code in Java Integration Stage in DataStage to pass the input data to the class and output from the class as response. Have this app...

Thanks for the reply Craig.

I was in an assumption that we can connect to any of the Message Queues using thie MQConnector stage,when you integrate the ActiveMQ with IBM Message Broker.

Is there any other way i can connect to the ActiveMQ from Datastage?

Hi All, I am doing a PoC on Message Queue's in my project. I need to connect to Apache ActiveMQ from my DataStage MQConnector Stage to post a request and read the replies as well. When I am checking the MQ Connector Stage in CLient Mode, it is asking me for Queue Manager Name, User Name and Password...

Hi All, I am performing cleanup activities on our server. I want to know when was last time (anyone logged on to particular DataStage Project) the project was used or did anyone access that project recently? I have been trying the STATUS command it doesn't provides much information. Any help around ...

Thanks Ray and qt_ky for the prompt replies.

Hi All, I am passing a Comma Separated File as my Input to a sequential file. In the properties, I am enabled the "Reject Property = Output". My Input Data: Col1(Not Nullable), Col2(Not Nullable), Col3 (Nullable) ,a,b ,,c a,b,c a,,c When I am running the job instead of rejecting 3 records,...

Thanks Ray for the quick tip.

Now i have enabled Retain Scripts as part of the project.

Hi All, We are carrying out an Data Quality Profiling exercise using Information Analyzer, however facing below issues. 1) IA jobs failed with but nothing in the logs 2) IA jobs completed but no output result. We are trying to find the log details in the below path: IBM\WebSphere\AppServer\profiles\...

Hi All,

Any solutions please?

Thanks,
Mohsin Khan

Hi All, I am trying to configure MQConnector Stage in Request/Reply Mode. I am trying with the below scenario: Job Design: RowGen -> MQ Connector -> SeqFile I have created the Queue Manager, 2 Queue's one for request and 1 for reply. In the MQ Connector Stage properties, I am configuring the Propert...