DSXchange

There's at least one thing you can't do without the UV account, and it's a biggie.

Without the UV account you can't start DataStage. Recall that the UV account contains its system tables, including records of the existence and locations of projects.

Wrong. CONNECT localuv connects to the project itself, not to the UV account. And it locks you into a DataStage/SQL environment.

Preston?

Preston?

I have recently installed two production systems on virtual images of Windows Server 2008 R2. They are quite happy and stable.

All of my suggestions relate to parallel jobs, because the original post was marked as "parallel" job type and was posted in the forum for parallel jobs.

What do you mean by "pattern"? The Index() function can be used to detect the presence of a substring within a string. In a BASIC Transformer stage the Matches operator can be used to determine whether a string matches a particular pattern. Here the pattern is idiosyncratic to the product,...

My suggestion is to use the "generate operational metadata" option. This collects operational metadata into XML files that can be loaded into your metadata repository and analysed and reported on using Metadata Workbench. You can also use DataStage's internal Performance Analyzer. Again yo...

Oracle DATE data type allows for storage of time. In effect, it's a timestamp.

Oracle is... different.

Objects in the design canvas are managed via an OLE Automation server. There has been a failure in this mechanism. This particular error code can be a huge number of things, so I'm not going to try to guess. It may, for example, that you have limited access on Windows XP/2000. May I suggest an inter...

Welcome aboard. The dsjob command has a hierarchy of "list" options. dsjob -lprojects dsjob -ljobs dsjob -lstages dsjob -llinks dsjob -lparams These should deliver all the information you seek. Where a link is an input link you have a write stage. Where a link is an output link you have a ...

Their approach to the local repository leaves a heap of orphan entries in DS_JOBOBJECTS. You still need to delete all the job's RT_ entries and DS_TEMPnnn table, so you still need to know the job number before deleting the job entry from DS_JOBS. I prefer the following approach, using DataStage SQL:...

No APAR of which I'm aware. This comes from private communication with Tony Curcio at IOD 2011 and subsequently.

You can't. But you can generate the timestamp outside the loop, and mark that activity "do not checkpoint" if that is appropriate.

No. These are not system tables. Indeed the DS_ and RT_ tables do not occur in the UV account. I mean system tables such as UV_SCHEMA, UV_TABLES, UV_USERS, UV.ACCOUNT.

Presumably the relevant Cognos manual or the Cognos Informaiton Center on the IBM web site.