Search code examples
performancewritersap-iq

Sybase IQ Single Writer?

I've heard a number of my colleagues make reference to the fact that Sybase IQ can only have a single writer. I'm struggling to find documentation on the web that either confirms or denies this so would someone be able to set the record straight in this regard?

What findings I have made lead me to think that perhaps on IQ 12 you were only allowed a single writer but on IQ 15 you are allowed a single writer per table? Is this true.

Any clarification would be much appreciated.

Thanks

Solution

  • Sybase IQ 12.7 only supports a single writer node but multiple reader nodes. Sybase IQ 15 allows both multiple writer and reader nodes. The writer nodes have full write access to the database and there are no restrictions at the table level.

    Thanks Mark DeLaFranier Sybase, Inc.