Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sqlanywhere]

SQL suite from Sybase

SQL Anywhere is a SQL suite created by Sybase

http://www.sybase.co.uk/products/databasemanagement/sqlanywhere

13 questions
4
votes
1 answer

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 efficiently export the data for backup and, in the…
nxzr
  • 141
  • 3
4
votes
3 answers

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 database property "CurrIO" shows "The current…
Ralph Wissing
  • 51
  • 4
4
votes
2 answers

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 and attach the database in question to it, but then…
Borislav T
  • 178
  • 1
  • 1
  • 6
3
votes
2 answers

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 the temp file reached 20Gb and a free space issue…
Breck Carter
  • 181
  • 2
  • 9
2
votes
1 answer

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 told by some near me that the service can not…
Hylon Heaton
  • 178
  • 4
2
votes
0 answers

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 this time they run without any issues. We have…
Dustin Bird
  • 21
  • 1
2
votes
1 answer

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 place. Thanks in advance.
Vivien
  • 21
  • 1
1
vote
1 answer

How to access a SQL Anywhere Server without a database to create one?

is it possible to connect to a SQL Anywhere Server without an existing database to create one. In SQL Anywhere Studio i always have to define an existing database. Regards Martin
Martin.Martinsson
  • 113
  • 2
1
vote
3 answers

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 transferred a database to the server and set it up as…
Kristiaan
  • 432
  • 1
  • 9
  • 21
1
vote
1 answer

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
ahmed
0
votes
1 answer

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 LD_LIBRARY_PATH I restart apache but in phpinfo() i still see…
miszczu
  • 119
  • 1
  • 1
  • 5
0
votes
1 answer

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. Please ensure that libdbcapi.so can be found in your…
Robert
  • 207
  • 1
  • 6
0
votes
2 answers

Listing tables on a SQL Anywhere using iSQL

Is there a way to list all the tables on a SQL Anywhere using iSQL?
Pablo
  • 7,249
  • 25
  • 68
  • 83