DSXchange

Moderator

Please move this thread to the "Looking for Talent" forum

Your job is a complex one to use that many processes. I hope that your hardware is sufficiently beefy to support that type of job and that level of parallelism. Look back at your job that is using 60Gb of swap space regardless of the number of rows processed. I am certain that you are loading a look...

I see, you are right. The next part will always fail then... Strange coding

Thanks Steve!!! Your result means that it isn't an AIX issue (unless this box has some odd configuration setup); so it looks like it is a V8 issue. Now, in order for DSXchange to do much of IBM Support's work, we need one more volunteer from a Version 8 system on some other platform I've opened up a...

Craig - that chunk of code won't work but will just return the original handle number so it looks like it works

You need to start the job with different instance names, otherwise you will get the error message you have seen. If your job is called "MyJob" then you need to start it with "MyJob.FirstInstanceName" and "MyJob.OtherInstance" and so on.

Maveric - Many thanks for your help!!! It does narrow down the problem so that now it is no longer a general issue common to all implementations, so now we'll look at OS and/or Version related settings. It would be great if someone could try just the Job portion on AIX and 7.5x - Aakash, are you aro...

Here is an easy example. If anyone here has a minute or two time to see if they have the same problem (perhaps someone not on V8 or AIX): 1. From your UNIX command line enter echo "\000" | tr '\000' '?' | wc This should give an output of 1 1 2 {1 line, 1 word, and 2 characters as UNIX will...

Programs do not really allocate swap space; this is done by the system when pages no longer fit in physical memory. What could be happening is that you are starting up a number of processes, each of which is using memory space for its programs and data. Have you added APT_DUMP_SCORE to your jobs and...

I wrote a simple script which does the tr command. When I call the script from my shell session it works correctly. When I call the same script from DataStage (either from a Job Sequence or from the Before-Job tab in a job) it doesn't work the same way and all nulls are stripped out. I have not been...

I don't know - this might be a problem with the V8 connectivity to the repository. I have a similar issue in that when I try to save my table metadata my designer gives an error message (I can't recall if it is the same one) and then it gets itself into such a state that I need to close it down, wai...

Now it gets even stranger. If I do a "cat testfile.txt | tr '\000' '?' > testfile2.txt" on a file from my default shell, sh, or from a ksh it will work as expected and have the same length but replace 000 characters. DataStage here is set up so that the default shell is ksh and I've verified that it...

I have a fixed width sequential file that contains \000 (null) characters coming from a mainframe. From UNIX, I can execute cat TestFile.txt | tr '\000' '?' and it successfully replaces all nulls with the question mark character. But I cannot get that to work from the filter command in the sequentia...

Ok, so we'll assume for the moment that the IBM documentation is wrong.

Did you successfully install Oracle and set up the TNSNAMES.ORA and other files as documented?

I would ask your admin people (again) what they actually changed and if they could revert the changes to see if you can access once again.

If not, I would call your support provider for assistance. It really looks like an IIS Websphere connectivity issue and not (directly) a DataStage one.