DSXchange

Watch this space. IBM has standardized on Eclipse across the board as the client development tool, which is totally Java based. Among other things, this means that they ought to be able to produce clients that can execute in non-Windows environments. Whether or not they choose to do so is an entirel...

A Search should have found this post among others.

There is no "time" component on the FILELOCK statement. Perhaps you are confusing this with the task synchronization locks, which are locked by a LOCK statement, which does have a timeout capability.

Import the table definition and use whatever is imported. When there is more than one key column, you have to be correct with the order of the columns within the key as well as the columns within the data record. Storage in a hashed file record is by field number, not by name, although the UniVerse ...

One of the recent webinars ("Files and DataStage Job Sequences") at the DSXchange Learning Center shows precisely how to do this with a loop in a job sequence.

A hash file is for trimming a block of hash. DataStage uses hashed files.

I create a synonym for the table name (such as MY_AUDIT) and import that. Then rename the imported table definition. This means that the actual metadata remain untouched by human hands, which I always strive to achieve. To create the synonym COPYI FROM VOC 'DS_AUDIT','MY_AUDIT' To delete the synonym...

DS_JOBS load discrepancy can be ignored - it's not fatal, and will correct itself in time (next time the server is shut down). Why did you only run UVFIXFILE on DS_JOBS? Did you check permissions, as I asked?

Basically the network topology is irrelevant. There is no mechanism to transfer a running job from one machine to another, even in a grid environment.

Moderator: please move to parallel forum

What happens if you configure the APT_PERFORMANCE_DATA environment variable?

What happens if you create a parallel job without a Data Set stage? Say a Row Generator writing to a Copy stage?

I too would suspect that you have not installed the DataStage patch required for successful operation under XP sp2.

The world economic downturn in the 1990s led to a surge in data warehouse/data mart activity as businesses sought ways to focus on getting good data with which to concentrate on the strengths of their business. There is no reason, in my opinion, why the same would not be true now.

Routines do not create logs unless coded to do so. Routines can add entries to job logs. Job log information can be examine with the Director client (which has a Print option) as well as the two ways mentioned by Craig.

"Parameter not resolvable" probably means that you have used parameters for these three properties (ignoring the DSCAPIOP_ part of the name) but, for whatever reason, the values supplied for the parameters (check in the job log) could not resolve into anything that the Oracle connection co...

There is a table called JCL_TEMPLATES in the Repository and there should be a tool in the Manager client for editing JCL templates.