DSXchange

What values are you trying to pass in the Arguments? Also do you really mean both are functions For the first condition, there is a value either Null or '' passed, I checked the result of first condition, it is giving 1 for secound condition, i am passing value other than 12345, I checked the resul...

or you can create a function

I have two functions defined as NullChecking() if ((Trim(%arg1%, ' ', 'B') = '') Or (isnull(%arg1%))) Then 1 Else 0 Trimlt Trim(%arg1%, ' ', 'B') When I use this in the transform as, if NullChecking(arg1) And Trimlt(arg2)=12345 Then 'wrong' Else 'right' I always get value as wrong. I have checked in...

You are using variables PathName, error without assigning them any values.

for DSJ.* check the number of arguments

uvconfig file

Where does the uvconfig file reside & does it suffice to select autopurge on Datastage Administrator or do we need to set it somewhere else as well?

Test out the optimal performance by kicking off the jobs simultaneously and see how much the server can handle. Use top, glance etc. to monitor the server load.

Do we need to monitor the network traffic as well (for the data coming in from the clusters) ?

This job was not part of the design, so I wouldnt be bothered if its gone, We have backup of the job which are part of the design. But the log file from this is creating space problems. (just found from another version, that it gives plenty of warnings) The RT_LOGnnn is still in there. when I open t...

I just saw that the job has been deleted from the project. What shall I do in this cae?

I am having a huge RTLOG file, although I have kept autopurge for every 10 days option.

Why will happen as such and any way to remove it, as its causing space issue.

Thanks a lot - cleared lot of questions. I guess this would be the last questions through my mind (hopefully :lol: ) a) Will the people responsible for Enterprise Scheduler able to see the echo statements? (it might take long time to ask this question to the concerned ppl, hence posting them over th...

Is saying extracting from a cluster equivalent to saying extracting from a server

Or do they both mean differently.

So is your scheduler controlling the process by reading return codes or your job sequence is? The Enterprise Scheduler kicks off the scripts (containing dsjob) to initiate all extracts and so it gets the return value from the script. Actually my follow-up question is based on this. First of all, th...

I am using files to synchronize extracts from different clusters. If in case extract fails from any cluster and it take days to fix it, then we might be waiting for days. If everything goes well, then we might have to wait for 2-8 hrs. Is it good to involve Enterprise scheduler for these scenarios (...

Wait for File Activity can be used to wait for files to appear, is there any ADVISABLE time limit to use this stage.

i.e any under 4 hrs , we can use this stage or anything under 1 day etc..

I am not using any transformations in the transformer and the sequential file is place in a directory other than where datastage is installed. So I guess I need not worry about disk space in this case, is it??? Its only the memory space I would need to think. How can we know the memory space on the ...