DSXchange

Hi,

When I try to clean up resources, I encounter the following message:

"Cannot find any process numbers for stages in job LOAD_PS_RO_LINE".

What does that mean?

Cheers,
Mohan

Hi, I observed a weird thing today while I was running the job. I ran a job and after it loaded around 200,000 records, I have aborted the job. Later when I reset and ran the job again, the performance statstics shows 210,000 rows, 0 rows/sec. After sometime, again I aborted, rest and the ran the jo...

Hi Anand,

Thanks for your response. But may I know where can I get the Microsoft JVM as I couldn't get it from Microsoft site.

Cheers,
Mohan

Hi Sainath,

Where shld I substitute the word 'mail'? In the hosts file or in the Notificatio Activity?

Cheers,
Mohan

Hi, I have a Notification activity. It's running successfully but I'm not able to receive the mail. The IP entry for the mailserver is available in the 'hosts' file on the server. Even then, I'm unable to receive the mail. May I know is there anything else that needs to be configured on the Unix box...

Hi, I have a sequence which in turn triggers off a few other jobs to run. A peculiar case has happened. The sequencer aborted, but one of the jobs that it has triggered off is still Running. I tried to run the sequence again, but the sequence failed. I need to know how can a job still be Running whe...

Hi,

Thanks a lot for your inputs.

Let me consider your inputs as a starting point and proceed further.

Thanks again..

Cheers,
Mohan

Hi, Thanks for the response. Let me explain what I need. We have developed the sequence (and a set of jobs) catering to the requirements of the client. Now, as part of the deliverables, we need to submit the test case document. So, if you can let me know the different test cass (cases/conditions whi...

Hi,

I have developed a sequence and a set of DS PX jobs. I need to write the test cases for them. Can I have a list of indicative test cases that can be run on the sequence and the jobs?

Cheers,
Mohan

Hi, I am unable to send a mail using the Notification activity. The things is that I'm able to do so if the server is on my local machine. But when I developed a job on a different Unix server, the mail is not being sent though the job is complting successfully. I was told that I need to configure t...

Hi.. Thanks for the response. Infact, the word POSITION is a SQL*Loader keyword. And SQL*Loader is used by DataStage to load the data. And interestingly the column POSITION is used by one of the PeopleSoft tables that I wanted to load. If I change my target table column to POSITION1 or something els...

Hi, I need to load data from a Oracle table to another Oracle table. My source and target tables are one and the same and the tables contain a field by name POSITION. When I try to load the data, I'm encountering a sqlldr error. When I opened the log file, I could see that there is a keyword POSITIO...

Hi, I want to know is it possible to configure my DataStage EE to do a parallel read from a file or from a database? I know it's a weird question to ask whether a parallel read is possible from a database, but I need to know different options to optimise my loading strategy. So, please let me know w...

Hi, I'm trying to run a parallel job from a Oracle table to another Oracle table on the same database. For two of my columns, the data type in Oracle is NUMBER. While importing metadata, the data type that I could see in the DataStage is Decimal (38,10) and while running the job, I face the Warning ...

Hi, I have a scenario where I need to execute a shell script in the Before and After Job Routines. I could run the job but could not execute the shell embedded in the job. When looking at the log file for the job, the third entry is Environment Variable Settings in which I could find an entry which ...