DSXchange

Thanks! I had RCP turned on for the job that creates the dataset, but not the one that reads it.

I have one parallel job that creates a dataset and another one which reads it. The first job seems to run without any problem, supposedly writing over 3 million rows to the dataset. But the job which reads the dataset issues these errors: Transform: Error when checking operator: Could not find input...

Thanks, you may be right. Like I said, it happened when we had debugging (DS_PXDEBUG) turned on. Maybe DataStage was busy.

It's in the same job (it's wrapped up in an "after-job" subroutine, called with 'DSJ.ME'). It always runs with the same number of partitions (two). The only thing different about the failed run was that we had DS_PXDEBUG turned on (for other reasons). Maybe that was just a coincidence, tho...

Can you narrow down the 'sometimes'? What stage are you trying to get counts from? ... That's what we're trying to figure out. It happens infrequently, and we haven't been able to find any pattern yet that might help us understand the problem. It's retrieving the number of rows extracted by a DB2 s...

Sometimes it doesn't return the correct row count.

Thanks. Someone here had a parallel job that was calling it from an After Job routine, and it didn't always work as expected (although it ran). I'll ask him to change it to a server job and see if that fixes it.

Can someone tell me if the DataStage routine 'DSGetLinkInfo' is supposed to work when called from a parallel job? Or does it only work when called from a server job? The reason I asked is because it's described in the Server Job Developer's Guide, but not in the Parallel Job Developer's Guide. Thanks.

Hi! I'm getting the "Dropping component <...> because of a prior component with the same name" warning message, which I've searched for and found many references in this forum and others, but none seem to match my situation. First of all, I'm not getting the warning on a Join or Lookup sta...

Thanks. We've opened a PMR. I'll let you know what they say.

Whether or not it makes sense, we just want to know if it's allowed. The person that's trying to use it wants to retrieve the SQL state and save it in the reject file. I don't see much point, the same information should be in the job log, but I'd like to know whether it's allowed, just for my own pe...

Sorry if this is a stupid question, but I'm new to Enterprise Edition. Someone here is developing a job that extracts from a DB2 UDB database, and when he tries to attach a reject link to the source stage, he gets this error: "The reject link is not valid with this combination of input and outp...

We sometimes get this error, but I don't think it's a disk space issue (we still have lots), and I don't think it's a file size issue either. We just resubmit the same job, with same input, and it usually runs OK the second time. Could it be caused by running out of file handles? We're running under...

I'm trying to use an XML Output stage to generate an XML file, but although the job statistics show that rows were written to the output file, no file is being created. I've turned on the "Write output to a file" option on the Options tab, but it doesn't seem to make any difference, althou...

Did you delete/rename the previously scheduled job, and then created another job under the same name? I remember something similar that happened to us in the past. I can't remember the exact nature of the problem, but it had to do with delete/rename of jobs. No, the job hasn't been modified or rena...