DSXchange

(1) Write a after job sub routine to capture the status of the job sequence. Call dsjobfatal() iff the job sequence is finished with warnings. This will abort your job. (2) In the job sequence properties, enable the check boxes "Add check points so that sequence is re-startable". HTH Can ...

No worries... sometimes people search for "too much", too specific of a search string. Can help to cut it back, to use a more generic portion of the message. Sure it gives you more to weed thru, but your fish is in the net. Somewhere. :wink: Do you still need help? If so, please do give u...

chulett wrote:Search just for "newTime". That and give us some idea of your job design. ...

Hi Chulett,

Thanks for the suggestion as well as apologies for not searching the topic with all permutations and combinations.

chulett wrote:Yes... as long as it's just "old" files as you've noted. ...

As per my experience I know that it can reduce the possibility of IIS jobs getting killed abruptly or getting corrupted. But does it help in increasing the performance in any way?

Hi All, I am getting following warning in one of the job that has 10 million plus records to be loaded in the table in Oracle 10g database. buffer(10),0: APT_BufferOperator warning: newTime < startTime, 1242920537.63075 1242920538.07821 I had been trying to find anything matching in the forum but co...

I Donot have that manual with us because we are using evulation version of DS.
And this documents are not installed on any system

We have installed the Teradata .. Now we need to connect it with the datastage . Are there any environment variables, the same way that we used while connecting datastage with Oracle (like LIBPATH , ORACLE_HOME etc....) If there are any please let us know. Or if there is any other way to connect the...

It probably works fine but then they get added right back on. How about more details about what exactly you are doing where and what the end result is you are trying to achieve? ... We had similar problems in our case where a Char(0) characted is getting appended at the end of the string. Even thou...

Right... it's in the log because they "used it" but I'm wondering where they found out about it to use it as it doesn't seem to be documented anywhere that I could find, unless it is new for 8. This APT_PERFORMANCE_DATA is used to dump the details about performance of any job. It can give...

Hmmm... the only mention of either APT_PARAMETER_DATA or Illegal flavor keyword in the bajillions of posts here is in this one. Googling for the latter phrase gets me one hit in the 8.0.1 Release Notes where they post the 'workaround' as 'Contact IBM customer support'. Hi Chulett, Thanks a lot for ...

one of our job is taking long time in SIT compared to development env. i.e., 4 hrs in SIT and 2 mins in development. While doing analysis we used an environment variable APT_PERFORMANCE_DATA. After running the job errlog got generated in $DSHOME. Got the following message in errlog: Fri Mar 13 08:30...

I am facing an issue of the jobs getting aborted abruptly(No message of Fatal or warning found in Director log and log is incomplete). When the job is restarted it is showing the following error message: Error setting up internal communications (fifo RT_SCTEMP/BIW_Dimen_Vehicle_Vehicle_01_SIT1.fifo ...

Hi Kandy, Any other option with Datastage. Thanks There are two options for processing Delta Data. These are CDC (Change Data Capture) and SCD (Slowly Changing Dimension). Both are almost same as per functionality but SCD is faster as far as processing speed is concerned. But there is a problem wit...

I searched about sparse lookup but did not find relevant information regarding my query.Hence posting it here : I need to do a lookup of field ADDRESS_LINE_4 in one table on another field COUNTY of reference table (two diff. tables) and bring PROVINCE as a lookup result from reference table. The con...

Actually we are getting review comments from the external contractors who are working as a DataStage professionals about removing the Sort stage. They are saying that Sort stage is not needed as the partition will be preserved.