A range of RDBMS and BI products from Sybase Corporation, distantly related to MS SQL Server. Their RDBMS offerings span the full range from an enterprise-grade "big iron" RDBMS down to a lightweight mobile RDBMS. On the BI side, they have a DW/BI solution called Sybase IQ.

learn more… | top users | synonyms

0
votes
1answer
171 views

Script or any method in sybase iq 15.2 that will log user's queries,access to database

I am struggling to get way to log user connection access,queries that are fired to database(SYBASE IQ 15.2). I tried request level logging but it has great performance impact.Is there any way ,script ...
5
votes
0answers
52 views

OLE DB Sybase Connection Failing

I have a connection to a Sybase database which we stage in a SQL Server 2008R2 database. I can connect the the database and the connection tests out fine. I am using an OLE DB source with a Sybase ...
1
vote
0answers
21 views

How to get list of tables, views etc. a users has rights to?

I'm looking for a way to get a list of views, tables, procesdures etc, a user has been granted to. A select onto SYSROLEGRANTS helped me to find basic role of users -- but not more like this. So ...
1
vote
0answers
124 views

kerberos authentication in sybase

we are setting up Kerberos authentication in Sybase (linux). DB version is 15.7. We are using Active directory for kerberos. We have done the configuration settings on the DB side and kerberos is ...
1
vote
0answers
70 views

How to calculate the ratio insert/select against a table to manage the index in Sybase ASE?

To create/manage indexes of a table, it is important to know the ratio insert/select or modification/reporting. For instance, if there are more INSERTS than SELECT against a table, we should try to ...
1
vote
0answers
174 views

Sybase anywhere sql server connection problems

in my work we have a software system based on sybase adaptive server any where version 6 installed on a windows server 2008. the system work fine but after a period of time from system start problems ...
0
votes
0answers
20 views

Sybase ASE 12.5 on VMWare extremely slow cursors

There is a poorly written stored proc in an older Sybase 12.5 database that I need to make faster, but I can't change the code. I can change the database settings, indexes, engines, OS settings, etc. ...
0
votes
0answers
11 views

ASE 15.03 mixed data and log segements

I have a DB with mixed data & log segments. I also have some log on data device & the other way too.. The target is to have the data & log segments aligned properly , please guide me how ...
0
votes
0answers
158 views

Migrating form Oracle to Sybase fails due to missing functions

I generated the DDL from Oracle to Sybase, created the tables with no issues even migrated most tables into Sybase using insert into, however when came to the time functions I get errors: Function ...
0
votes
0answers
231 views

SQL nested select (query rows after variable), running slow

Have large table (Sybase) rows = 6276225. I'm pulling call status and my query is very slow. In effect what I’m trying to do is pull data for any event after my variable. While querying for just one ...
0
votes
0answers
220 views

Which database tool to connect to Sybase 15 servers?

The Sybase servers which I am working on have just been switched to LDAP authentication. I was using DBArtisan before that, and used to input separate login name and password. Now I don't see any ...
0
votes
0answers
453 views

Sybase ASA 9 Central exception on connecting to old database

I have installed sybase ASA 9 i used the sybase central to connect to an old version .db file of ASA version 6, a wizard popup and ask yes or no to unload the database .. for upgrade i click yes ...