DSXchange

Thanks Ray and Karthik for the response. Currently I am checking the time in a shell script and executing the Job, it works fine. I want to simplify the design to get rid of shell script and also I don't want to use touch or done file. I am more inclined towards Ray solution. Could you please elabor...

A Sequence job is scheduled to trigger daily at 10 PM and it runs multiple jobs . There is one Parallel DataStage job(say X) in that sequence that has to run at a particular time at 2 AM. Even if the Preceding jobs finish early before 2 AM, the sequence job should keep running and wait till 2 AM to ...

Is it possible to write 1 record in a sequential file ? I want to run the job in 4 node config I am reading 10 records from Database and want only 1 record in a file. I used the Filter option ( head -1) in sequential file stage. The job aborted with error. Export failed, write() failed. Broken Pipe....

Thanks Ray.

Currently the jobs are in production in 8.5. The client wants to migrate the code to 11.3 with no change. Installing patch will help to fix this issue? Need suggestions.


Current version is
DataStage Core/Client Rollup Patch V2
11.3.1.0

We are in the process of migrating the jobs from version 8.5 to version 11.3. In version 8.5, the job runs with out warnings. In version 11.3 , the same job runs with a warning. warning: "Ignoring duplicate entry at table record 003; no further warnings will be issued for this table " Job ...

What does Code1 error mean ?

Yes. Thanks Ray. I am able to successfully connect to the Queue manager using the test button in the connector.

I am writing a message to MQ using WebSphere MQ connector stage. on a server mode config, with Queue manger, Username, password and Queue name defined. job aborts with a fatal error. there are no other error message in the log except below. Parallel job reports failure (code 1) Could someone help me...

Thanks Ray.

No meaningful messages other than the below.

node_node2: Player 2 terminated unexpectedly.
main_program: APT_PMsectionLeader(2, node2), player 2 - Unexpected exit status 1.

main_program: Step execution finished with status = FAILED.

job reads a comma delimited flat file and creates a XML. All the source fields are mapped ( totally 9 fields) and none of the columns have NULL or any special character data . The job aborts with the below fatal error message. XML_304,0: Fatal Error: CDIER0401E: An error occurred during XML parsing ...

could you please help me to locate the property in assembly XML editor.

can we send the count as a parameter to the XML ?

There is a job which creates a very large XML. Requirement is to split the single large XML to multiple XML's based on count. For an example : large XML has 900 records, I need to split into 3 small XML's of 300 each. The count 300 does not vary. Is that doable in new XML stage in Version 8.5 . I ne...

We tried to increase the heap size in XML stage, from 512MB to 1024 MB , job gave the following the error. XML_22: [Input link 0] The JVM could not be created. Error code:-6 (::createJVM, file CC_JNICommon.cpp, line 454) XML_22: Error occurred during initializeFromArgs(). Error occurred during initi...

Thanks for the reply Ray. There are only 2 options for Hjoin stage join types: 1. Disk Based 2. In-memory. Earlier I had the DISK BASED join, job did abort frequently. IBM had suggested to use IN-MEMORY join in all documentation , so I changed to In-Memory and this could help to process only up to 2...

XML job has multiple source links with HJOIN steps being performed on each source links. The job ran fine for 2000 records in XML. The XML schema is complex with over 250 elements and multiple complex groups which are unbounded. The job fails for more than 2000 records in target with the below error...