SQL suite from Sybase

learn more… | top users | synonyms

4
votes
1answer
1k views

Script / command to drop all connections / locks in Sybase SQL Anywhere 9?

I've recently become responsible for administering an application which is essentially a front end to a Sybase SQL Anywhere 9 database, including the database itself. I'd like to use unload table to ...
0
votes
0answers
16 views

High latency from clients accessing SQL Anywhere backed application

Apparent high latency from clients accessing SQL Anywhere backed application The setup: Server: Running Windows Server 2012 R2 Standard /w Hyper-V role VMs on this server: -2 DCs -1 terminal server ...
0
votes
0answers
16 views

How to open db v9.0.2 in sqlanywhere v16?

The Sybase Central (v16) returns following response: dbunload -v -c "UID=DBA;PWD=sql;DBF=/home/user/sa16_samples/sqlanywhere/ddd.db" -an "/opt/sqlanywhere16/new_ddd.db" -ap 4096 -ea None -ii SQL ...
2
votes
0answers
43 views

Delay in starting Database services on Server 2012 R2

We have found in the past couple of days (unknown when this first appeared) that services for MYSQL and SQLAnywhere 16 are taking 20 minutes to start when a windows 2012 R2 server is rebooted. After ...
0
votes
2answers
2k views

Listing tables on a SQL Anywhere using iSQL

Is there a way to list all the tables on a SQL Anywhere using iSQL?
-1
votes
1answer
5k views

how to set LD_LIBRARY_PATH on VPS red-hat linux to be visible by apache

Where and how should I set LD_LIBRARY_PATH to be visible by apache? I tried to add following code to .bash_profile: LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/folder_with_library/ export ...
0
votes
1answer
364 views

SQLANYWHERE10 PHP Module

I added the extension to php.ini to get the module to load but now I am getting this error Warning: sasql_connect() [function.sasql-connect]: The SQLAnywhere client libraries could not be loaded. ...
2
votes
1answer
326 views

SQL AnyWhere, how do I set the database ReadOnly property to On?

Does anyone know in Sql AnyWhere, how can I set the ReadOnly property of any database to On? I can only see the way to access the property, but cannot find the way to set it correctly at the first ...
1
vote
1answer
254 views

Change a Database Properties On SQL Anywhere 9

i need to change the property (Casesnsitve = on To Casesnsitve = oFF ) for a Databse created on SQl Anywhere 9
2
votes
2answers
5k views

How to access a SQL Anywhere database?

Currently I have a SQL Anywhere (version 10) database (.db and .log files) - the idea is to extract the data and utilize it for a MS SQL database. The problem is that I start a SQL Anywhere server ...
2
votes
1answer
300 views

SQL Anywhere 10 - Can you combine cache control commands?

So this may seem like a silly question but I have been unable to find documentation that supports either side of the question. SQL Anywhere 10 - dbsrv10.exe has numerous startup options. I'm being ...
1
vote
3answers
1k views

Sql Anywhere 9 cannot access on Network

heres the situation, i have a windows 2008 enterprise server (brand new) so far the only thing installed on it out of the box is SQL Anywhere 9.0.2 and Mysql 5.1 its all setup and working i have ...
4
votes
3answers
1k views

Diagnosing I/O Bandwidth Performance in SQL Anywhere

While diagnosing performance issues with vendor software that runs off of SQL Anywhere (9.0.2), I stumbled upon some interesting data in regards to I/O Bandwidth. According to the 9.0.2 manual, the ...
3
votes
2answers
569 views

How do I control temporary file growth in SQL Anywhere?

We are currently experiencing a growing temporary file problem. Watching one of our sites we can see a growth of 100 - 200 MB a day at one site we are watching. At this site a failure occured when ...