DSXchange

Try the pattern \[**\]$

I don't see any mention of scratch space in the logged events that you posted. Resolve the issues with shared library search path first, then resolve the scratch space issue if it persists. Failure to access scratchdisk usually means one of two things; space or permissions. It may be the case that y...

Thanks, Ray and Paul. This is pretty much how I understood things to be. But my client is hyper-cautious and requested me to ask around.

Are you just informing us of this, or do you have a question?

No Teradata at my current site; others will need to answer that question.

Can anyone please share their experiences with (and any technical documentation describing) the interaction between execution of DataStage jobs on a grid and the DataStage workload management (WLM) system?

Values files are not created when you set parameter values in job properties. Rather, these parameter definitions are stored in one of the repository tables that stores job details (specifically, as associated multi-valued fields in the local repository table DS_JOBOBJECTS). Values files may be crea...

My thought: "Resource temporarily unavailable" is fairly clear as a diagnosis.

As a general observation, bulk loaders (for any database) do not use SQL.

Instead, they use a load script particular to the database. So this would be a FastLoad script in the case of Teradata.

If you really do want two engine machines (for example to keep different streams of processing separate) then the topology is: 1 x repository (XMETA) 1 x services (WAS) 2 x engine For preference the services and repository tiers should be on the same physical machine. If not, make sure that there is...

Welcome aboard. Probably the easiest approach is to execute each in a separate script, invoked via the Execute Command activity. The output of each Execute Command activity is available via its $CommandOutput activity variable. Alternately you could create a job (a server job for preference) to exec...

Create a Data Connection object.

Attach a Parameter Set to the Data Connection object.

Within the Parameter Set create a values file for each environment.

Load the Data Connection object into the Stored Procedure stage.

Associate the input argument with a column from the input link to the Stored Procedure stage.

Teej's "we" is not my "we", and we will agree to disagree on that. I would agree that the BASIC Transformer is contra-indicated for huge data volumes, but would counter that with the observation that the majority of DataStage jobs that I have encountered process only small to med...

You can ask for level 5 for every country, it's just that you may not get it. You will get the best level that's available for the country currently being processed.