DSXchange

Whenever a *.so file can not be found, in my experience, the problem is almost always an improperly-set shared library search path - the environment variable LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH, depending on your particular operating system.

The version of DataStage can be obtained with

If you're using TextPad to create the DAT file, for what purpose are you using DataStage? Are the Oracle environment variables, especially NLS_LANG, correctly set? If you are using TextPad it is unlikely that the characters are encoded using SHIFT-JIS - it is far more likely that some form of Unicod...

If you have specified node or resource pools in your configuration file then you can constrain any stage to execute only in those pools. They are not a whole lot of value in an SMP (share everything) environment. However, an example: if you need to execute a stored procedure once (rather than once p...

What read method are you using to get the data out of DB2? Use the Resource Estimator and/or Job Monitor to give more targeted metrics. If the import really is the resource hog, this is the area upon which your investigations need to be more closely focussed.

"Resource" in this case means the file or table used to decode the message code which is given. The error message advises you to "Check that DSHOME or APT_RESPATH is set". Either of these can be used to determine the location of the resource file/table. In versions earlier than 8.0 the name of the t...

... and divide seconds by 60 to get minutes.

yeah...everytime i was able to guess it in the range of (+/- 2)....but not exactly...& that i trust just because we can't know what operator DataStage is gonna create...even if we disable the Combinabilty mode. Not true. You can always know (with sufficient understanding of how DataStage intera...

Does anyone know what this warning message means: Cannnot read phantom output file SH_84948_14928 This is a production job running every month without any warnings. These two statements are mutually inconsistent. Every phantom (background process) in DataStage has its stdout and stderr redirected t...

Search for dslictool - it has a cleanup mode.

(From memory) right click on the job name in the Repository and choose Resource Estimation from the menu. There's also a tool in the Toolbar if you have the job open in Designer; hover the mouse pointer over the tools to get tool tips.

It is expecting whatever date format is specified by your current date format string setting - probably "%yyyy-%mm-%dd" as noted.

Fold() is a better function for dividing a string.

There is no max start value for any substring operator or function - if the values used refer to a non-existent position, a zero-length string is returned with no error or warning being generated.

Yes, but can it INSERT into saved queries? Quoting identifiers is a long-established practice and is not the same as changing the column names. However you may find that MS Access requires backquotes rather than double-quotes - another fine example of MS not following an MS-published standard (ODBC).

I doubt it. Use the reporting capabilities of the Web Console for Information Server.