Tagged Questions

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 ...

learn more… | top users | synonyms

0
votes
1answer
372 views

how to set up shared memory and make it available?

I try to setup shared memory for Sybase ASE 12.5 on CentOS. My server has 17G memory, I want to make 14G (=17-1-2)available for sybase. (1G for os, 2G for ramdisk 14 = 17-1-2). here is the info: ...
0
votes
0answers
66 views

What would prevent “set statistics io on” returning data?

I am using sqsh to connect to Sybase IQ 12.7 and I want to see statistics for queries so I do the following: set statistics io on go select count(*) from some_large_table go and I expect to see the ...
2
votes
1answer
475 views

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 ...
0
votes
0answers
120 views

nl__write_defer: write failed on socket nnn. : The device does not recognize the command

nl__write_defer: write failed on socket nnn. : The device does not recognize the command. This is frequently reported in a Sybase ASE 12.5.4/EBF 14925 ESD#7/P/NT (IX86) on Microsoft Windows Server ...
6
votes
2answers
2k views

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 ...
1
vote
0answers
355 views

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 ...
3
votes
2answers
545 views

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 ...
0
votes
1answer
117 views

How do I find the current page lock promotion value in sybase?

I've done this before but I lost my notes. There's lots of web pages from sybase infocenter explaining how to SET it, but I need to find the current value on two machines so I can compare them.
1
vote
2answers
451 views

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 ...
1
vote
1answer
113 views

Sybase:-where to save a new database? [closed]

I have downloaded "SQL Anywhere-12" trial version from the Sybase website. I use Windows Vista It installed itself in two locations.The Sybase related folders are in:- 1) "C:\Program Files\.." ...
2
votes
1answer
763 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
1answer
191 views

ASA Anywhere v9 - MS SQL 2005 : Conversion Tools

im hoping for some advice and hopefully information regarding the conversion of an ASA Anywhere v9 Database to MS SQL 2005 Standard Edition. Basically our v9 ASA database is no longer supported by ...
0
votes
1answer
3k views

Are Sybase ASE ODBC drivers for Windows x64 available for free?

Are Sybase's own ASE ODBC drivers for Windows x64 available for free? If not, does anyone know of a cheaper (preferably free!) alternative? I believe the ODBC drivers are available as part of the ...
2
votes
2answers
3k 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 ...
0
votes
1answer
397 views

Sybase 15.0 : Improving simple insert/select speed

What are the ways to improve performance of the following procedure: Every day I take a datafile, bcp it into an intermediate table without indexes (so that data import is as fast as possible), and ...
1
vote
2answers
1k views

Expected IOPS for log writing on PS6000X SAN?

Customer is experiencing poor Sybase ASE 15 performance on a PS6000X SAN with 16 X 450GB 10K in RAID-50. The server is a Dell R710 running 2003 server R2 64bit in ESX 4.0.0,256968 I've used sqlio to ...
0
votes
1answer
822 views

sybase ase 15.0.3 64 bit install error

I have a 32bit machine installed with 64 bit suse10 linux. I then tried installing a 64bit sybase on it but the sybase installation fails the moment i launch ./setup with below error: Searching for ...
3
votes
3answers
5k views

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 ...
0
votes
2answers
651 views

RHEL 4.8 / Sybase 12.5.4 64 bit install error - I have libaio i368 installed I need libaio x86_64 installed

I am trying to install Sybase ASE 12.5.4 64 bit. I know the machine has a 64 bit processor It is giving me an error during install saying: "error while loading shared libraries: libaio.s0.1" I run ...
0
votes
3answers
743 views

Techniques for keeping logins and password synchronised between two dataservers in Sybase ASE

Sybase ASE 12.5.4 As per the title, I'l looking for a way where creating a login or changing it's password on dataserver A also happens on dataserver B, and vice-versa. Would it be possible to ...
0
votes
1answer
158 views

Migrate a Sybase 12.5 DB to MSSQL 2005

I was wondering if anyone can help me. I want to Migrate a Sybase 12.5 DB to MSSQL 2005. But have no Idea where to start. and will all the Procedures still work that has been created in Sybase?
1
vote
2answers
128 views

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?
1
vote
1answer
272 views

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.
0
votes
3answers
1k views

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 ...
0
votes
1answer
156 views

How do I determine the size of a DB instance? (Sybase 12.5)

I've got an instance with dozens of DB's, and I need to know the total spaced used by all the DB's. I don't want to have to do sp_spaceused on each of them. Could I do a foreach loop and add them ...
2
votes
3answers
1k views

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 ...
2
votes
1answer
1k views

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 ...
0
votes
1answer
142 views

PHP4 and sybase_ct on Novell SuSe 10.2

Am migrating an existing Ubuntu8.04 server running PHP4 and the sybase_ct driver to SuSe 10.2 The trouble is the sybase_ct driver that I need to connect to our MSSQL2000 / 2005 database. On the ...
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 ...
0
votes
3answers
760 views

Sybase/isql/Transact-SQL - how to terminate sql on same line

I have a query that is generating further queries, things like this: select 'exec uspd_thing "'||name||'"' from sometable Which produces this : exec uspd_thing "name1" exec uspd_thing "name2" ...