DSXchange

There is an entry in VOC that records the most recently accessed/executed jobs. This changes every time a job is accessed/run. Therefore VOC changes.

Are all the files on the same file system? Do you have the flexibility to spread the files over multiple disks?

Can you please verify that there are no non-printing characters, including extraneous linefeed characters, in the file, especially around where the problem appears to be occurring?

It's really useful for vendors like Peoplesoft who deploy their application on different database types but can ship a standard set of DataStage jobs with the database type parameterized. It's also sometimes useful when there's a bug in the alternative (ODBC especially) and - for whatever reason - t...

Not a reinstallation. A reboot of the client machine (the "Microsoft solution") will probably do it. Maybe even just closing all DataStage clients and opening new instances will solve this.

Which one occurs first depends on which option you choose. Obviously you only invoke the sequence in a custom INSERT statement - for an UPDATE statement you must already know the key value.

Contact Customer Support Services? Could it be that the executing user lacks sufficient database/table privileges to be able to create a query plan? Could it be that the table where query plans are recorded does not exist? It is unlikely that the problem is internal to either DataStage or the ODBC d...

When you start DataStage services, you should get messages about NLS maps being loaded into memory. Do these appear?

Only one way to find out!

Not really. The question is akin to - and has the same answer - is it OK to use 80 variables in a program? And the answer is, of course, yes. And, just like in a program, if you use computationally intensive techniques to assign values to these variables, then your demand for computational resources...

Please advise HOW you create the values file.

Run this message text by your DBA. "ISDMG03" does not have the privilege to perform operation "CREATE IN" on object "DB2T.DSADM.DB2ESQL8.()". Get your DBA to show you the privileges that "ISDMG03" has. Not sure about the second message; it appears to state tha...

The parameter is NLSMODE in the uvconfig file. 1 = enabled, 0 = disabled.

If NLS is not installed the NLS options in uvconfig are not available at all.

Any change to uvconfig requires a regen to be performed.

dsjob -jobinvocationid will return a zero length string if the job has no invocation ID. However, since it is possible to run (one instance) of a multi-instance job with an empty invocation ID, this won't help. I suspect your command line will need to invoke dssh and use one of the methods that a se...

Just the obvious one - put one in.

Without one there is, as you note, no way to identify the newly inserted record (unless you can scrape the transaction log using a product such as Q-replication or CDC).