DSXchange

In your ODBC Administrator window (you can get to this via Control Panel on the server, or simply run odbcad32.exe) there is a tab called Tracing. You can go there and enable tracing for a particular ODBC connection. I'd advise not using the default log file pathname, because this is in the root dir...

Guillermo, The dsjob command can take as many -param name=value options as you need to give it. However, it's rather more difficult using dsjob to ensure that jobs are in a runnable state. You can use the -jobinfo option, and parse the result to determine the exit status. But, because of what you di...

Tim and I have had a productive off-list discussion, where I did tell him that I was presenting the class. A question was asked, I wanted a good answer, so I did the research. Part of that research was the question that opened this thread. Totally professional, as always.

If the target is, indeed, a table, you don't even need the link collector. A table can support multiple streams of data being inserted quite happily. It's only marginally trickier if you need to group rows from the multiple sources into a single transaction but, since you don't get this using a link...

Because you specify uvsh.exe, I know that you are on a Windows platform. On this platform, the DataStage services are set up, by default, for automatic start when the system is restarted. Job and stage status is updated into the RT_STATUSxx tables by running jobs. It is entirely reasonable that, if ...

Let me reinforce Ken's post. Read-only components are part of DataStage. You cannot be certain that they are not used within the product itself. If you delete them, therefore, you run the risk that DataStage will no longer work properly without reinstallation. Ray Wurlod Education and Consulting Ser...

It's almost certainly nothing you've done. This message can indicate that an attempt to convert a numeric string to a number (particularly to an integer) has failed because the resultant number is not possible (for example, an "integer" > 2**31-1). It suggests that there exists a bug somewhere in th...

Does this behaviour occur with all ODBC drivers, or just the Client Access driver? If the latter, the fault is not with DataStage. The ODBC standard specifies that the driver should return an "invalid user ID/password" message if this is the case, and DataStage should be able to access this message ...

DSR_IMPPLG is what is called a "helper subroutine" that performs various tasks associated with plug-in stages. Without source code it is impossible to know exactly what action 3 is (contact your support provider); however, from the DSR_UVCONST.H header file it seems to be "next" (DSR.SUB.IMPPLG.NEXT...

Vincent, I really had in mind were there the same number of columns in the Columns grid in the DataStage job. I too perceived that the number of columns in the SQL matched the number of parameter markers. If you subsequently changed the number of columns in the job design, this could lead to the err...

The LD_LIBRARY_PATH environment variable contains a list of the directories in which any libraries that might be needed are stored. Therefore, as well as the DataStage libraries, and any needed to be an operating system user, it must include any libraries required for ODBC drivers and the relevant c...

Try increasing your transaction isolation level.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

You'll be disappointed if you expect the log file for a job to be a file. It's a database table in the repository. Therefore you can't view its contents with a text editor. Each job has its own table, the naming convention you will discover on your search. They can be viewed with the Director client...

Don't forget that, in order to show the dependency of job2 on job1, you need to draw a link in the job sequence from the Job Activity that runs job1 to the Job Activity that runs job2. You will find that the Triggers tab then appears in the Job Activity that runs job1 and you can specify the rule un...

This kind of thing is impossible to diagnose without being able to see the actual repository and use diagnostic tools therein. How to use these tools (and even of which tools to use) is specialist knowledge, which is why Kim advised you to call support. You may, by attempting to clean up the project...