DSXchange

If other file is working fine, you may defenitly need to check the difference between the two file or the metadata of the two files been used.

You need to have a seperate job with a BASIC transformer or a BASIC routine which will have simple code Call DSSetUserStatus(Arg1) Ans = 0. The argument can be used as input parameter to the forth comming jobs. If you do a search on Userstatus, you can find lot many post. But calling the job or the ...

Have you check K:/Ascential/DataStage/Datasets/ and /tmp for space. Try placing some 500MB-1GB file in these directries and check if it can hold without any error or waring. Per Ray's comment, try running the job alone in the server when RAM is idle for this job to get utilize.

Is it related to other post of yours?
Just give a try to restart JobMonApp
The command is
To start or stop JobMonApp
-----------------------------------
goto $DSHOME/PXEngine.
and then run
./jobmoninit stop - to stop
./jobmoninit start - to start.

As mentioned earlier, its one of the process you like to follow in you development. Error processing tables will mostly be the one which collect all the rejects with the error code. There are several approaches, based on you methodology. Its more flexible if you stored procedure. Audit table will be...

Hi Ray, I noticed that, but the point I like to mention is if its a network congestion, Director view should also slow down right. If it doesn't get affected, then as you mentioned it may be due to some permission lack for that user to the core hashed files.

As Ray mentioned, if Network is the bottleneck, you can ensure by exploring options like listing logs in director or look out for all the list of jobs irrespective of category, it should also take very log time to refresh, hence it extracts the data from server at every point. If permission is the i...

At the max you can prioritize the process, and hence restricting the utilization of CPU time. But again it is based on the internal process id's. The commands like nice or renice can be used for this. Again not sure how far its possible to automate.

Btw is this your job desing?
user variable activity------>job1 nested conditional activity----->job1
user variable activity------>job2 ------>job2
Or you would like to align it, as others did for you.

Version Control pdf sent in the CD will give lot more datastage related information.

Thanks for clarifying.

Hi pradkumar,
You can let us know, what is this regards to.
It can be either the either the normal naming conventions used in your site or project for the details given by Ray or it can be referred to the database internal tables.

Hi kirankota79,
If you got a solution, you can mark the topic as resolved. Also add up with the method you solve the issue, so that, the other enthusiastic participants can work on other post rather than a post posted a month back.

What Ray and DSguru2B is suggesting is, use either in BeforJobSubroutine or using a Execute command in JobSequence where the job been called, and read the Newfile.txt for you lay out.

What happens when we use a upstream database stage to find the max value, and pass it to surrogate key generator stage??? Sorry I dont have access to PX now.