DSXchange

Mine is to but I get the same issue now and then. I look in Process explorer and I can see the designer or director processes its just that they loose the connection to the dsapi_server and slave process. I usually just close the client and reconnect and its fine. This usually happens when I leave t...

As far as question 2 I also have a batch which I run nightly that compiles all my jobs clears all the status clears all the logs and releases all the locks I run this job in the scheduler everynight at 8:00pm before my data warehouse build begins. Works great as well so the moral to the story is it ...

Actually I have a batch job which clears all the RT_LOGS for a project. or you can run it to just clear one job log. I use the one job log alot when a developer runs a job which has a million rows and it produces a warning for each row and they did not set a max warning. Wow try to clear that from d...

Could you elaborate on what it was?

I really don't see why you would want to to that unless like chulett says if you wanted a service. Then I would create the datastage job to run as a service. Otherwise if you really wanted to do it, write a shell script to either execute your job or sequence using dsjob then x= 1 y=2 while y > 2 Do ...

What is the rest of the job log
and did you look at the core dump?

First I am assuming that you are checking for nulls to determine if the lookup stage did not find a match. If thats the case then put an output file off from the lookup stage and set the properties so that if a match is not found the record goes there otherwise the record goes through with the flag ...

I guess it would depend on the value or values you do want.

FIELD1='SOMETHING'
this is simpler then then other

but again it depends on the values you want.

First off I would not touch this file, unless of course you are 100% sure of how the px engine works and all the processes it uses when running a job .... so on. This is the file that creates the pipes and osh processes for your job. I would look at the core dump and the job. Something in the job is...

I would use a parameter in the hashfile name so that each one is related to the run it was loaded in. I agree with previous posts that they should not be removed. 1) for trouble shooting reasons. 2) disk space. What I mean by that is if the files maintain approx the same size each time they will hol...

If I understand what you are doing. You are using a text file to control the loop in a sequence. If so why don't you just have a single continous line with delimited values. 123,234,543,2345,4567,........... The reason I say this is because if you set the count to a parameter list the value in the l...

If you're on 8.5 use the looping functionality.
or use the combine records stage under the restructure tab in the palette

ERASE THE LOG? hope you don't need to recover! You should get with your DBA If your transaction logs are filling up then most likely backups are not being done or they are definitly not being done frequently. Is XMETA local on DB2 or on another server, Oracle or SQL server. Either way you need to ge...

Right now I am running all my legacy batchs from 5.0 - 6.0 on 8.5 32 bit and 8.5 64 bit and everything runs with out issue.
I had to modify the runbatch routine to handle multiple instances but that was easy enough.

The batch compiler compiles my 2000 + jobs way faster then the gui does.

Ya when he was working for ascential I had a class with him in Texas call building dataware houses with datastage about 9 or 10 years ago