DSXchange

Thanks Gurus.

I have got some work around. I am going to use Audit tables instead of trusting ps -ef command.

Hello PaulVL, Regarding your comment Engine thus picked up the shell settings and now datastage engine has a COLUMNS value of 40, which will mess up your ps -ef output. I don't agree as this is happening sometimes. However, regarding the size of 40, i have seen "ps -ef" returned output whe...

Hello Experts, We are using DS 8.7 version with AIX and database as Teradata 13.11.0.07 In my projects, we don't have any scheduler used to schedule datastage jobs. But, indeed we have datastage master sequencer using batch concept. We have database batches created and on run time, our master sequen...

If we use 2 DTS stages, can we use same work queue for both. Yes, you can use 2 DTS stage using single work queue. In case of job failure, do you know how the roll back and replay will happen if we use 2 DTS stages? In case of job failure, your message will reside into work queue. About rollback an...

Can you please explore more on your problem?

1. what SP is this? Oracle/Sybase/Teradata?
2. How you are calling it?
3. Is your procedure working fine, when running as individual?
4. It creates problem only when you are running inside ETL?

50 links will be too much, the performance will not be good.

I would suggest to play a little with your job design, use 2 DTS Stages and distribute the links among them.

There is no maximum input links for the DTS Stage, but it is observed that the performance will be degraded after having more than 32 links in a single DTS.

specify the delimiter as "|" for the target sequential file.

Please elaborate more on your problem.

1. Monitor the job, Out of 16 Lookup's or any other stage, where the job is taking more time. Give more details for this.

2. Has something changed recently ? job design ? servers? configuration?

You may do it by setting the commit interval to 1, but that would compromise the performance.

Yes, it is very much possible. using dsjob -run command.

Below are the possible options, where you can use "dsjob -run" command

1. You can invoke your Job2, in the Before/After Job Subroutine. ExecSH and write it.

2. Use can write script (Perl/Unix/Java) and make a system call.

If you have data like
2312-08-15 12:14:20

existing conversion function

StringToTimestamp(%string%,"%yyyy-%mm-%dd %hh:%nn:%ss")

should able to convert your Varchar data into Timestamp.

Also, try to give a certain length to your VARCHAR fields ( for e.g Varchar(200) ) rather than using VARCHAR(). When we define the column as VARCHAR() by default, it takes the maximum possible value for the column. We have also faced the similar issues and it was crashing our servers. We have modifi...

Exception Handler supposed to react on "Failure" and not on "Warnings". When warning limit set as 50, exception handler catches and throw an exception when the warning count exceeds to 50. When warning limit set to "No Limit". Exception Handler will not give an exceptio...

Perform a lookup 1. For the matched rows, Lookup will provide the ID (Say in Link A) 2. For the unmatched rows, capture the Rejects in the reject link. 2.1 Use a surrogate key generator stage and select the property - Source Type as "Database Sequence" - Generated Output Column Name as &qu...