DSXchange

The ability to capture execution statistics for active stages should be your first port of call, noting what Ken (kbland) had to say. By this means you can identify the "hot spots" where, say, a Transformer stage is spending most of its time, and address those areas first.

I've never heard of BCI code knocking out the entire machine. Here's how I prefer to log BCI errors. ErrCode = SQLError(hEnv,hConn,hStmt,SQLState,DBMScode,ErrText) Message = "Error in ODBC interface" Message<-1> = "SQL State = " : SQLState : ", DBMS code = " : D...

Don't know what point-to-point is. That may be a personal failing. In the early days "do-it-yourself" was the main competitor to DataStage (and, back then, DataStage was cheap). But it was readily shown that maintainability was a big factor, and the need to rewrite from scratch if you ever stop bein...

Can you create the Category ODBC\ATRIUM in the Table Definitions branch then attempt the import?

Arnd left out the "[4,2,2]" which might result in a single digit month or day number. Just for laughs here's an alternative. Fmt(Fmt(Field(InLink.TheDate,"-",1,1),"R%4") : Fmt(Field(InLink.TheDate,"-",2,1),"R%2") : Fmt(F...

Check that you have write permission to all objects in the DataStage project directory, and are credentialled to update the common IIS Repository.

might be easier as the inner command. Just an alternative. Thank you for the script.

How do you specify the lookup if your table doesn't have a key? As fridge says, you need to have an index of some kind. Without an index on the lookup key (whether or not it's a primary key) you need to perform a table scan for every row processed in your job. There is no way this can be efficient. ...

RMM stage

Look in the DSParams file in each project. Where APT_NO_JOBMON is defined as user-defined does it still exist in the Reporting category? If so remove the user-defined definition, which will reinstate the Reporting one. Also, document that it is not acceptable to override any of the supplied APT or O...

The format string is telling DataStage that there are 10 characters in the date fields (such as CREDIT_VALIDITY) but the null field value does not have ten characters. Use a schema that reads DATE_TIME, CREDIT_VALIDITY and SERVICE_EXPIRY as string[max=10] and convert them to date within the job desi...

Another reason that rows/sec is a useless metric is the case where the extraction query involves sorting. The clock starts running but the query returns no rows until the sorting is complete. Then rows are probably delivered at quite a fast rate but, because the clock has been running since the quer...

QualityStage also looks like DataStage. A zebra also looks like a horse. They are not the same.

Welcome aboard. DataStage doesn't have a problem with it, but some databases do and trapping the use of reserved characters (such as "%" and "$") in passwords and other identifiers is coded into appropriate stage types. You will find some information in the appropriate manual about how to deal with ...

I used the word "explicit" to differentiate a Failure trigger from a Custom trigger. If you have a Failure trigger, then that takes precedence in the automatic handling. Which, if you had read the help or the manual, you would have realized.