cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase IQ 16 On Linux recomendations

Former Member
0 Kudos

Hi experts , i just  want to ask your suggestions about Sybase IQ on Linux. What Linux distribution and version do you think it´s the best option to install sybase IQ 16(and what SP and patch for IQ do you recomend)?

I'm asking this because we are in a Sybase IQ implementation project and we did it on windows server 2012 R2, however, we had so much problems that the client is proposing changing to linux, but we want to be sure what´s the best option(stability,reliability,etc)

Some of the problems we had on windows are:

-The RLV functionality it's failing on identity columns(duplicate identitys generated)(as you can see on my post ), SAP has told us that this is solved on SP 10.04, however, this patch its avaliable only on linux).

-The ETL process(using SAP Data Services 4.1 SP4) sometimes fails with message "connection was terminated"

-And the worst of all our problems, is that sybase IQ is very unstable , it stops sudenly when it's under heavy loads, it hasn't worked fine for more than 2 days. A certificated consultant has reviewed everything and has no clue on whats wrong, tickets had been posted to SAP and they don't  have idea , the log files simply say : UNKNOWN ERROR  or UNKNOWN STATEMENT .

We'll appreciate your suggestions on what's better based on your experience.

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Luis,

    If using RedHat Linux IQ latest versions are certified on RedHat Linux 6.x versions. Certification is in process for RedHat 7 version.

    I would recommend that you use IQ 16 SP10 latest patch level, if you are planning to use RLV feature for IQ.

Regards

Shashi

Former Member
0 Kudos

Thank you so much! And another question. We have one SSD and multiple common drives, what are(or where can i find) the best practices in order to improve performance with the SSD? Actualy in the windows installation, the SSD is assigned to the temp dbspace, is this correct?

Thank you!!

Answers (0)