Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sybase]

Sybase, an SAP company, is an industry leader in delivering enterprise and mobile software to manage, analyze and mobilize information. Sybase marketers several database products, SQL Anywhere, Sybase ASE RDBMs server, Sybase IQ datawarehouse and Sybase Replication Server. Related are Sybase central, isql, bcp, open client, sybase Powerbuilder and Power Designer.

Useful links

Sybase Corporate Site

Sybase ASE online manuals

SQLAnywhere online manuals

Sybase IQ online manuals

Sybase Replication Server

International Sybase User Group To find tons of information.

32 questions
7
votes
3 answers

Php pdo_dblib - cannot find/unable to load freetds

Self-hosted box, RHEL 6 PHP 5.3.3 PDO installed freetds installed pdo_dblib - so far no luck installing My goal is to use PDO with sybase. Attempting to install pdo_dblib from the appropriate version php source code. I have tried a variety of…
MaxPowers
  • 171
  • 1
  • 3
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
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
4
votes
3 answers

Sybase Central issues on 64-bit Windows 2008 Server R2

I can install and run Sybase Central v 4.3 on Windows XP without issues. However, I am not so lucky when I use 64-bit Windows Server 2008 R2. It does install but it will not run. I tried running in compatibility mode (Win XP) but it did not…
Hamish Grubijan
3
votes
2 answers

Re-assigning raw SAN disks from Solaris to Linux

We have a SYBASE IQ database running on Solaris using raw devices as underlying storage for the database. We would like to migrate this environment from Solaris to Linux. Is it possible to just reassign the SAN disks used as raw devices by SYBASE to…
user126330
2
votes
1 answer

Practice management software running in Hyper-V?

It's my first time asking a question, so please let me know if I've done something wrong or can be more clear/concise in my phrasing. I've recently taken over service for a dental office that utilizes Patterson Eaglesoft 18 as their practice…
stephancasas
  • 29
  • 2
2
votes
1 answer

Can't compile PHP with Sybase

Trying to compile Sybase with PHP 5.4.13 in Linux version 3.2.0-4-686-pae (debian-kernel@lists.debian.org) (gcc version 4.6.3 (Debian 4.6.3-14) ) #1 SMP Debian 3.2.35-2 # apt-get install freetds-dev php-5.4.13# ./configure…
Shawn Welch
  • 531
  • 2
  • 4
  • 18
2
votes
3 answers

Sybase ASE 12.5.2 High Disk Queue Length

I have a Sybase ASE 12.5.2 server running on Windows 2003 that is extremely slow for most select queries. The system is a 2 x Dual Core Xeon, 4GB memory and 200GB Raid5 (10k SAS Disks) for data on an LSI megaraid controller with a 128MB cache + BBU.…
Mark Amerine Turner
  • 2,574
  • 1
  • 16
  • 17
2
votes
1 answer

How do I dump a Sybase database in quiesced mode

I am trying to do a cross-platform (Sun -> Windows) dump and load of a Sybase ASE 15 database. The first time I tried, I got an error saying that the database needed to be in quiesced mode during the backup. What does this mean, and how do I achieve…
Mike Sickler
  • 103
  • 1
  • 9
1
vote
2 answers

When I add an index, do I need to do anything else to get it to build?

When I add an index in Sybase, is it built automatically or do I need to do something extra? Is there a way to tell?
Mike Sickler
  • 103
  • 1
  • 9
1
vote
0 answers

Sybase heavy Disk I/O issue

I have a Sybase 15 server that is constantly reading from the hard disk. I noticed that the sqlsrvr.exe is the culprit which is the main database engine. This is a pretty utilized server that is running a 32 bit instance which means the process can…
Super1337
  • 474
  • 2
  • 4
  • 9
1
vote
1 answer

Sybase DBA learning resources

Does Sybase provide learning resources for wannabe Sybase DBAs like Oracle Learn by Example? I am an experienced relational DBA wanting to learn Sybase.
edwards
1
vote
3 answers

can sybase replication be used to synchronize sybase and mysql databases?

I see that mysql replication can synchronize from sybase, but can sybase replication server write to and read from sybase? I'm trying to figure out a migration path of a big old legacy sybase system lots of little applications to mysql and figure I…
Stu
  • 2,118
  • 2
  • 15
  • 21
1
vote
0 answers

Sybase ODBC driver not working over a VPN

I need to run a client's software locally on my machine and have it talk over a VPN link (Team Viewer VPN) to connect to the live database so I can attach a debugger to the client software and figure some issues out that the client is having. When…
Scott Chamberlain
  • 1,445
  • 2
  • 21
  • 37
1
vote
3 answers

What's the most efficient way to reclaim disk space after deleting lots of data from a database on Sybase ASE 15?

As I understand it, based on some research but zero real-world experience with Sybase ASE, the only way to reclaim disk space once it's been allocated to a database is to export that database, create a new DB with the same schema, and reload all the…
Ernie Longmire
  • 11
  • 2
1
2 3