DSXchange

DataStage issues a COMMIT when processing its end-of-data condition (unless an earlier error means that a ROLLBACK must be issued).

Both options will have the overhead of a Collector, since access through the DB2 API stage (necessary to talk to the AS/400) also implies sequential execution mode. Can you send a text file to the AS/400 and bulk load DB2 there?

Theoretically you can have a mix of Lookup Failed rules. You may have uncovered a bug in the parallel job compiler. Ask your support provider.

Reorder the date components, and format into a timestamp. Simple string manipulation. Col1[5,2] : "/" : Col1[7,2] : "/" : Col1[1,4] : " " : Col2[1,2] : ":" : Col2[3,2] : ":" : Col2[5,2] : " " : (If Col2[1,2] < 12 Then "am" Els...

This is an internal problem with DataStage/SQL (GTAR = general technical assistance request). Try it without AS introducing the alias name, and try it with a different alias name. cmd = \SELECT DS_JOBS.NAME AS JOB_NAME, \ cmd := \ EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'POPAPPL.ANALYSIS_VERSI...

You can also use the Data Set Management tool in Manager to copy the data set. Beware, though, that only the control file lives in the directory; the actual data files live in the directories identified in the configuration file as resource disk. The utilites are aware of this, and will copy the dat...

You "make" them using ordinary mkdir command. You use the configuration file to tell DataStage where they are. Make sure you have plenty of disk space. More than one resource disk and more than one scratch disk per node can be beneficial in alleviating bottlenecks in the I/O subsystem, particularly ...

If "log warning if job fails to finish successfully" is checked before the job sequence is compiled, a warning WILL appear in the job sequence's log, and you can check for it.
The most recent run start date can be retrieved using the DataStage API.

You are doing a normal lookup. The query will finish in the LUT_Create operation, and release any lock it may hold. The table will be updated downstream of the LUT_Process operation. There will be no lock issues from this quarter.

Welcome aboard.
You have posted this in the server edition forum. You will get server edition answers here, which will mislead you and not help at all. Post your question in the enterprise edition (parallel job) forum.

Specify a temporary directory (-t option) for the sort command. A directory with lots of free space.

Please specify EXACTLY what you want to get out, including its data type.

Welcome aboard. There are no performance implications. Processing 91 rows will take longer than 0 rows and less time than 10000 rows, but that's not a performance implication. Do you mean 91 columns? In that case make sure you have plenty of memory, otherwise it will need to use scratch space on dis...

Surely you should be asking that question of your support provider!

I'm not aware of any.