DSXchange

what is the command to check the path of C++ Compiler installed on Solaris box.
Thanks

Yes, will contact IBM Support.
Thanks

I have the same question.
Anyone pls

DSEenable_impersonation.sh

Did you try removing the shared memory segments (If they are still present) ?

Hi Stefan,

Appreciate your reply. The Cleanup on Failure is set to False and Non-Recoverable Transactions= True.

So if we set Cleanup on Failure to True, will it rollback all the data which is updated or loaded in case of abort?

Thanks

hi, Can someone please tell me how DataStage reacts when a DB2 Load Job failed due to resource contention and then we reset the job from Director. Will it terminate the load and bring the table into consistent state? We had the same situation where load job failed and after resetting the job from Di...

I am wondering, if Ray ever wrote a book on DataStage

we are having difficulties loading to DB2 .

seq file --DB2

The error message is

DB2load,6: Failed to prepare buffer for writing record #3265. Reason: write() failed: Broken pipe

DB2load,6: The runLocally() of the operator failed.

any help is appreciated.
thanks

no phantom process found, no locks found..... any other

extracting records from db2 dbase, couple of lookups on files, transformation then sorting and writing to seq file.
we already suppressed warnings by using message handler.
the job finished but log is still filling up.

a job which is in finsihed state, but log is still being written.
cannot open the log , it's increasing and increasing..
please advise


Thanks

Once the data is extracted from the database it goes through a sort stage and then written to a dataset.

A px job aborts sometimes with this abort message

Job fails with SourceRecs_db2,2: Write to dataset failed: Broken pipe error

It is a db2 enterprise stage extracting around 100 million records, the same job will finish if we re-run it after sometime.

Please advise
Thanks

hi, what is this error: Seq_File_source: Short read encountered on import; this most likely indicates one of the following possibilities: 1) the import schema you specified is incorrect 2) invalid data (the schema is correct, but there is an error in the data). Seq_File_source: Expected 469 bytes, g...