DSXchange

I have a log file that reached the 2 gigabyte limit. Director is unable to clear the log. When I tried DELETE FROM RT_LOG1360 WHERE CAST(@ID AS VARCHAR) NOT LIKE '//%'; in Administrator I got the following error: FATAL: Cannot write to transaction cache file. What would be the bad consequenc...

My DataStage Designer client froze while I was signed on as the dsadm user, so now I have two job that are locked. I know how to UNLOCK USER ##### ALL but the last time I did this for the dsadm user, I also brought down our media management system, which depends upon a couple connections kept open b...

ray.wurlod wrote:It may also be beneficial to increase scratch space, etc. in uvconfig.

It turned out that the UVTEMP parameter in uvconfig points to a directory
that is "only" 500 MB. Our support provider recommends we use a directory
with much more space available.

We have a job that creates a dynamic hashed file that is used as the input to a transform stage. We use an after-stage ExecTCL DELETE.FILE command in the job's ultimate transform to clean up the hashed file. The hashed file's output link contains the following SELECT clauses in the Selection tab: @I...