DSXchange

Sir,

I have a situation like this:

I have a sequencer with lot of jobs,Before running one of cleanup job i have tp look for particular file in directory.Please put light on me.

It's windows OS.

Thanks for help.

Narasa

Hello Guys, I created single Transform with 2 links one for update and another for Insert .like this TX------>UPDATE | | INSERT I am updating and inserting SQL SERVER DATABASE. while running the job it's locking the table. I am getting following message: LoadCustomerMasterPDROETest..Transformer_39.D...

Hello Datastage Gurus,

Some of my Jobs has locked when i try to release with DS.TOOLS interestingly i didn't see any Processid's for those jobs,i tried with DS admin also no luck.

Please help me out.

Thanks
Narasa

I am sorry guys it's not locking error it's not updating correctly.

please help me.

Thanks for prompt reply.

Hi Guys, Based on Customer type i would like to update or insert records in to a sqlserver database table. I created Transform with 2 links one for update and another for Insert I am getting database locked error. It works fine for Informix database. Please help me out how to solve this problem. Tha...

Hello Sirs,

Suppose somebody else updating table with table lock or record lock
then Datastage job waits for some time or aborts.
one morething is if it is record lock what i observed is datastage job
rejecting locked rejects.

Please explain me still i am confusing state

Thanks a lot
Narasa

Hello Sirs,


Can i avoid Deadlock situation with Transaction Isolation levels.

Please help me on different Isolation levels when and where to use.

Thanks
Narasa

Hello Gurus,

Some of my jobs are failing some times because of Timeout (even we are not using hash files) problem and some are locking database tables

Please give me suggestions on how to rectify these problems.

Thanks in advance.

Thanks
Narasa

Hi Guys,

Thanks for Replies.Now it's working after i enable row buffer.

Thanks for help

Narasa

Hi All,

I have a simple job with link partioner and link collector but i am getting
error message like this
"Link collector stage doesnot support in-process active -to-active inputs or outputs"

Please help me out .

Thanks in advance.

Thanks
Narasa

Let us take a step back. You designed a job to 'create' an hash file whereas the other developer is using it to 'reference' from an hash file. So where is the hash file now? I see a 'missing link' there. Sainath, I created shared container for the job that outputs hashed file like this simple input...

That is because a transform stage does not support reference links emerging from it. Hi Sainath, Thanks for reply.My client asked me to create shared containers for all Hash file creation jobs and use these shared containers in the master job. What i did is just created shared containers for all th...

Hi Reddy, Didnt we answer the same post on 06/24/05 in a different thread?. Is this problem a different one? Here is your old thread http://www.dsxchange.com/viewtopic.php?t=93631 Hi Chowdary, Thanks for replies. This is u previous response ODBC -------------> Tranformer -------------> Hash File --...

Hello Sir, Datastage Gurus please help me: I created Hashed file as a Stream line in a Shared container (just dumping from database table) and using this shared container as a Lookup (Reference link) in another job. I am getting compilation error of mismatch link (Stream link in shared differ with r...

Hi Guys,

How to find total no.of jobs from my project using datastage administrator

or command line mode.

Thanks in advance.

Thanks
Narasa