DSXchange

I doubt this problem really related with APT_MONITOR_TIME or APT_MONITOR_SIZE? I mean I didnot understand why they these causes job failures, There are not many users connected to the UNIX box at the time of the runs happening. it could be a datastage bug, or a unix issue or something not related t...

As mentioned, you spedifically need an additional check for Stopped state, you can go for Job control code(BASIC).

'Automatically handle activities that fail' - It deals with the failure of the JobActivity/RoutineActivity that fails in the JobSequence.

The checkpoint will be assigned to the stage before/after it where you marked as check point restart.
But it will not make sense, as the Ray mentione, the job will always run.

Welcome Aboard :D

Availabe resource, (money) and the amount of data to be process with in the batch window should be the main criteria you should lookup on.

Hi us1aslam1us, Can you explain briefly what happens when we use multiple active stages without having any dummy stages in between. For example, i need to extract data based on keys which i cannot use them in one lookup stage or join stage. Don't we run out of memory. Yes the many stage you use, th...

You can acheive the same using sime If-Then-Else in Transformer.
Or Pivot and a aggregator/sorter.

Hi DS Don't you think, you forgot to seperate the conditions with brackets. Thanks Sam Do you mean t say like this COL_NAME = 'Y' OR COL_NAME = 'BRZ' OR COL_NAME = 'KC' OR COL_NAME = 'T' OR COL_NAME = 'TK' AND (SUBSTRING(ID,1,1) BETWEEN 0 AND 9) AND (SUBSTRING(ID,2,1) BETWEEN 'A' AND 'Z') AND NOT (...

Its merged product of Server Edition and Metastage.

Hi Harish,
Welcome Aboard :D
As suggested you have the detail explainatin in the pdf comes with the client installation.
Else you just give a search, you can find more useful information available here in this forum with real life scenario.
Happy Searching.

4. I have logged on to a second PC which has datastage I get the same result when opening an OCI stage 5. While logged on to the second PC I had a another user login to datastage on the pc - get the same result when opening an OCI stage 6. The other users have no issues if they log into either pc I...

Yes it is possible. Make sure you have updated you uvconfig accordingly.

The actual use of Inactive timeout is different. If you have you client machine inactive for the specified time, the connection between the client and server will be lost. For the lock, you need to kill the PID which hangs up. You can also try with addtitional option to reduce the deadlock timings, ...

Hi Gil,
Welcome Aboard :D
Do you mean to say that, there is a scheduler which called the job using dsjob.exe.
You have -wait option which will wait till the job ends.
You have -jobinfo to know the information about the job status.
But May I know what exactly you need.

Use to get the latest file and cut it to get the filename alone and pass it as parameter as specified.

Try to use dsadm if required.