DSXchange

Your DB2 DBA would probably be able to help. As noted in your other post, the error is coming from DB2.

Please complete the picture with an id command to prove that you're in the dstage group, and a df command to show whether the disk is full. After the touch command it would have been good to echo ? to get the exit status of touch.

with this the performance will be atleast improved. Your proof? How are you moving the records from Oracle to the text file(s)? Why not just effect the lookup directly against the virtual Data Set created by using the text file as the source for the reference input to a Lookup stage? There is no ne...

It *could* be done in an Execute Command activity in a sequence. It *could* be done in a before-job subroutine in a job. You shouldn't try it in a stage in a job, because you would be deleting the Data Set - unsuccessfully apart from the first time - for every row processed. :idea: The orchadmin com...

No.

Templates are stored in the client tier.

Job definitions are stored in the engine and repository tiers.

It might also be Information Analyzer. in which Rule Sets exist but they're totally different from those of QualityStage.

Therefore please identify which product's "Rule Set" you're talking about. It would waste our time to guess wrongly.

Iconv() is smart enough not to need the [2,2,2], as documented in this article.

There are no errors in what you have posted. Whence does it come? What has your official support provider had to say? Has the operating system changed along with the hardware upgrade and, if so, are all required patches in place for the new operating system version?

"d6" is not a valid argument for Iconv(). You need something like "DMDY". All date arguments for Iconv() and Oconv() must be in upper case.

Resist stupid requirements.

Use server job.

Continue to experiment, particularly with Format properties.

In short, "no". You use the orchadmin command to view the contents of a Data Set. Beware, though, that Data Sets can contain huge amounts of data.

This question has been asked and answered recently. Search for it.

Another possibility, if all have the same record structure, is to read them all using a Sequential File stage with the "read as File Set" property enabled.

It may be that the number of service units you've contracted to buy has been exceeded.