DSXchange

The OCI Stage appears in the palette for Datastage Server jobs, not for Parallel jobs. This stage cannot be parallelised by DataStage. So far as I can determine, its functionality is identical to the Dynamic RDBMS Stage in Parallel Jobs (when attached to an Oracle database). Like the OCI stage, the ...

Both suggestions work perfectly. Thanks guys.

I have a job that uses the Change Capture Stage to identify differences between two similar data sets. Both data sets are pre-sorted and partitioned on the change-key. Each data set has 1M rows. I want it to stream the output straight through, but it is writing the entire thing to scratch disk befor...

I'm working for a client where DS 8.0 is installed and maintained by a centralised group (not my team); they give us a project to develop and test our jobs. The jobs on this environment are just plain SLOW. For example, a Server job that reads and writes a single row from one sequential file to anot...

I'll take that overwhelming round of silence as a "dunno". Either that or I didn't express the problem clearly. Anyway, as a heads-up to anyone who searches on this in the future, I'll give an update on how we proceeded. Rather than use DS to fetch the rows to delete in an Enterprise Stage...

We have an archiving process that deletes rows from a top level table, which then uses DELETE CASCADE RI constraints to remove rows from subordinate tables - potentially many levels deep. In some cases, a low level table may have two parent foreign keys - ie. two different paths by which it may be a...

Beware of to_char(sysdate,'D')=1

Depending on your NLS settings, the numbering of days can vary. I once had this problem (and I think it was with DS) because DS set the NLS init params differently.

Try using to_char(sysdate, 'DY') = 'MON'

... the explain plan is the same. I just restarted the DS job and checked to confirm that. How did you confirm it? Did you perform a SQL Trace? Or check V$SQL_PLAN. If you used a GUI, then it is possible that it re-planned the SQL rather than showing the actual execution plan. If the plan is the sa...

Don't have DS at the moment, but from memory, dont you have to specify -local and execute from the PROJECT directory to retain $ENV values from the current environment?

OK. I think I have enough information for my purposes. It seems likely that Craig and I were both right. Why is that not surprising with Oracle? In a RAC, I believe that the NORMAL operating procedure is for applications to nominate a single database instance in the RAC that it will use. This is don...

Thanks Craig, that makes sense. My DBA hasn't worked with RAC before - nor have I. I was making some round assumptions about how it would work based on a rudimentary knowledge of the architecture. I'm not actually looking to do this - yet. I just want to be able to document a plausible upgrade path ...

I thought this was going to be an easily confirmed thing, but I can't find anything on ibm.com, Google, or - surprise surprise - here. I have used DS Enterprise in its simplest form - parallel processing on a single box, writing to a single Oracle instance. I understand that it can be configured to ...

I believe you can only set NextSurrogateKey() to output link columns - kind of limits it's usefulness.

To convert 1 input row into 2 or more output rows. For example, you could pivot a row that contained: into In this example the output would contain 12 rows for every input row.

In the INPUT tab of the hashed file, check the "Clear file before writing" box.