DSXchange

Looks like you have a few extra stage types registered in Proj2. Can you please verify whether the indexing on DS_STAGETYPES is intact? LIST.INDEX DS_STAGETYPES ALL If any of the indices shows "build required" then rebuild the indexes at some convenient time when you have exclusive acces t...

"The current selection cannot be cut/copied because it includes a plugin stage (ODBC_PRC) with not DS_STAGETYPES entry." This message should be of substantial concern - it suggests that you don't have read access to DS_STAGETYPES or that someone has been removing items from there, which i...

Probably a Data Set in most cases, but you need to factor in the amount of resources needed to populate that Data Set in the first place.

1. Try Information Center at IBM.
2. There is none. Create the columns and load them upstream with constant values.

Your assumption is indeed incorrect. Take a look at the code for the routine, to see how locking is handled. A row level lock is taken and held only for the duration of the update.

Welcome aboard. In server jobs all you have in the ODBC stage is positional parameters - in this case row numbers within the Columns grid.
The columns that end up in the SET clause are not marked as Key. The columns that end up in the WHERE clause are marked as Key in the Columns grid.

DataStage is an "FTA" - one of many ways for transferring money from your pocket into IBM's.

FTA = Funds Transfer Application

Yes, provided that a VOC pointer exists to the hashed file.

Note - it's hashed file, not hash file.

A current client has reports in Cognos and in Microsoft SSRS, who wants to import the details of both into the unified metadata repository of Information Server. Cognos is not a problem. The SSRS report definitions are stored as XML documents in Microsoft SQL Server database. The question is what th...

Disable operator combination, that you may learn which operator (stage) is actually throwing the error. It might be easier to diagnose what is happening once you've done that.

Everything we can tell you is summed up in the diagnostic message "OutOfMemoryError, cannot create anymore threads due to memory or resource constraints". You need more memory in the machine and/or the ability to create a greater number of threads in a process. Either is an operating syste...

Actually server jobs can do it, if you specify use of the read cache. In parallel jobs it's very obvious what's going on if you look at the score. A Lookup stage generates a composite operator containing the two operators LUT_CreateOp (which loads the reference data set into memory and creates an in...

You could Search DSXchange for PWD and find answers.

OK, the name of the product (unless you have an older version) is WebSphere Transformation Extender. Whether you have an older version or a new one, the installation instructions are in a PDF document that comes with the software.