DSXchange

I can imagine.

Everyone really hopes you are right!

Hi Eric Thanks for that, we are talking about just the engine tier. From what I can work out, an MPP Topology setup allows all the engine to be used at once. But if one goes down it says "A failure of single server will have a corresponding fractional impact on the total server resources that a...

Thanks for the replies. Just to clarify: With Grid the workload is shared over the available machines. If one goes down the work continues on the available machines. This has a cost though. With two boxes, there is the performance option, or the HA option. HA: Run on one box and the other box is sta...

The "Architect" here has decided that we will run a cluster configuration running the engines on 2 x 8 cpu linux boxes. He seems to think that this will give us high availability. I was wondering if this this is likely to be more performant than running the engine on a 16 cpu box. Also whi...

It's a bit late now I know, but I had this problem and found this https://www-304.ibm.com/support/docview.wss?uid=swg1JR38599 JR38599: Surrogate Key Stage generates spurious message: RUNLOCALLY() DID NOT REACH EOF ON ITS INPUTDATA SET 0. Problem conclusionThe surrogate-key stage was misinterpreting ...

kittu.raja wrote: For example my input 3 columns are

Code: Select all

Col1   Col2    Col3
  1      a     1
  2      b     1/2
  3      c     1/2/3
  4      d     1/2/3/4

And which Column would be used for the key?

Run it sequentially If the data get partitioned it won't do what you want. False. If the data are partitioned properly it will do what is required. ... This is not false, this is what fixed the problem. The stated fix In "sequential file stage, the option 'Keep File partitions set to false'&qu...

Run it sequentially

If the data get partitioned it won't do what you want.

blewip wrote:Both sides of the join need to be sorted on the key.

Thanks Soumya

So that's how you do a Sort

It's not entirely clear from your example, however the 1,2,3,2 appear to be the key. Both sides of the join need to be sorted on the key.

In which case they should appear 1,2,2,3

Duplicates in the key will duplicate the output, there should be 4 output records of key 2.

Yes there does appear to be IBM ODBC drivers (8.5).

However they appear to be in addition to the existing ODBC drivers

Is the problem actually passing the details of which value file to use in the sequence? In the sequence parameters you can hard code it to any of the values. However the sequence doesn't seem to let you define a variable that will contain which value file to use? The only option I can think of is to...

I don't think there is a problem, the holes in the numbers will be inserted next time the table is loaded.

To resolve run sequentially

Depending which SK Stage you use and you get two different ones even with 8.5, the numbers are allocated to partitions in chunks. Therefore each partition goes through the numbers in the chunk and once finished asks for a new chunk. Therefore when comparing the numbers in each partition, it will pro...

greggknight wrote:Also you don't need a peek stage to see the contents of a state file.
Just a generator and set the View stet file property to yes.

Sorry are you saying you can view the State file using the SK Generator Stage?

It's just that I can't see how.