DSXchange

UniVerse is a database product (as is DB2, as is Oracle and so on). Until recently UniVerse was owned by IBM, though they've now sold it. UniVerse was the original engine and metadata store for DataStage. Version 8.0 of DataStage introduced the unified (for all products in the Information Server sui...

Is the error message actually DSJE.BADVALUE ?

If so, you have provided a value for a job parameter that is not a legal value, for example "FRED" if the parameter type is Date.

What happens if you export the project using a dscmdexport command?

Or read the file as a single string per row, and parse the different record types in a downstream Transformer stage.

Or read the file parsed according to RecordType2 metadata, with missing columns rules in place, and handle RecordType1 in the downstream Transformer stage.

I normally use isadmin, who has been given DBA privileges in XMETA. Or db2admin, ditto.

There is no way to implement "no logging".

Auto-purge will not help, because this is only triggered by successful completion of a job.

However, it is perfectly safe to submit a partial or full log purge request even if a job is running.

You don't "need" to execute uvdlockd (or its replacement, dsdlockd) at all.

Configure the deadlock daemon to auto-start. This can be done from the DEADLOCK.MENU or by editiing the dsdlock.config file.

Does the last line in the file have its record terminator character? This error often occurs when it doesn't, but is expected to be there.

Welcome aboard. Resolve it the same way - make sure that the output from the Match Frequency stage (which includes these qf... columns) makes it in to the Data Set.

laxmig21 wrote:I cannot use MQ Stage as we are trying to connect to remote queue.

It is my understanding that the MQ Stage in version 8 CAN connect to remote queues. It can certainly connect to remote (that is, not co-resident) MQ servers.

APT_DUMP_SCORE causes one record to be written to the job log. This may increase your job execution time by a millisecond or so. APT_NO_PART_INSERTION prevents DataStage from inserting partitioners where they are required, which will probably lead to incorrect results (and performance is a non-issue...

Prefer importing Oracle table definitions using the Orchestrate orchdbutil facility. It is known to be more accurate in how it retrieves metadata.

There is also a table in XMETA recording existence and location of projects - you may need also to delete the pertinent row from this table. The table name includes the string "PROJECT" so it should be easy to find.

No such records are kept. You might like to lodge an enhancement request, either through DSXchange or through your support provider.

When you were in the Web Console for Information Server and, having created the user definition, did you scroll down and click "Save and Close"? Changes made on the screen are not automatically saved, and the "Save and Close" button is not visible by default, you have to scroll d...