DSXchange

While these are on AIX, they should transfer happily. We are connecting (successfully) from DataStage to Informix 7.3.1. Only pertinent sections of the three files are shown. uvodbc.config <Policies> DBMSTYPE = ODBC .odbc.ini [ODBC Data Sources] DB2 Wire Protocol=DataDirect 4.2 DB2 Wire Protocol Dri...

It might be interesting if the startup overhead for PX could be described. Has anyone got time to synthesise the Orchestrate mechanism (conductor, section leaders, players, etc.) and how these interact with the fact that there are N processing nodes mentioned in the configuration file? Might be a us...

You can do this easily with a Server job, using the XMLReader stage.

Protected projects bring in a whole new factor; it may not be as easy as changing the READONLY property. I am surprised to have Rich allege that DS_ROUTINES lacks such a column. It's been there on every DataStage site I've ever used. To be sure I created a protected project (on AIX) and executed the...

Please share your solution. The error message suggested that you were trying to create a pointer to the directory /u05/PRODDSS/data3/srcfiles/cmd/hash, rather than to the hashed file /u05/PRODDSS/data3/srcfiles/cmd/hash/H_Cmd_HS Your correct syntax therefore should have been SETFILE /u05/PRODDSS/dat...

You can continue to use ODBC for SELECT without much difference to performance. The DB2 API is very close to the ODBC API for SELECT. For loading, you will need to decide whether you always want to bulk load into DB2, or sometimes to use INSERT statements. The easiest way to convert is to create job...

Would it be a priority for Ascential to add more functionality (like this one) into the scheduler?

No. Ascential is not responsible for the at scheduler. To get added functionality in at you would have to approach UNIX and Windows vendors. I wish you luck!

The only piece of advice above that does not apply in the Windows environment is that about the dsenv file. All the rest applies just as much in the Windows environment. ODBC.INI is a Registry entry rather than a file, and maintained through the ODBC Administrator on Windows, but it's still relevant...

As far as I know, at least Informatica sales persons are telling that they have a CWM based tool to automatically convert DS jobs to Informatica mappings.

When did you start believing anything an IT sales person tells you?

If it's RT_LOGnnn errors, CLEAR.FILE RT_LOGnnn should help. If it's RT_CONFIGnnn errors, CLEAR.FILE RT_CONFIGnnn followed by recompiling the job should help. If it's RT_STATUSnnn errors, CLEAR.FILE RT_STATUSnnn (or Clear Status File from Director) should help. With these hacks you do, of course, los...

You can stage your data wherever and however you please. Fastest is text files. You can create DataStage jobs to extract from source and stage the data in text files on the DataStage server machine. Once all data have arrived, you can then process them through DataStage jobs to perform whatever tran...

First, what rate do you get if you add a constraint of @FALSE into the Transformer stage? This will prevent any rows from being loaded into the hashed file, but will demonstrate an upper limit on the rate at which DataStage can read a sequential file on your platform. Second, remove the constraint, ...

DataStage is "integrated" - as much as it can be preserving functionality across UNIX and Windows platforms - with the operating system at scheduler. There is an easy-to-use interface to at in the Director client. With this you can do pretty much anything that at can do on both UNIX and Windows oper...

Yes. Your support provider can help you out with this. That's part of what you're paying for.

It is DataStage's philosophy to log anything you need, or may need, to know about. This is not just errors, it's also unusual events that would not happen on every run, such as table creation, or a message from a database created with no logging that transactions are not supported. While it's true, ...