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
1
vote
2 answers

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 benchmark the sequential write performance of 4KB…
dss
  • 11
  • 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
  • 442
  • 1
  • 9
  • 22
1
vote
3 answers

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 replace master..syslogins on B with a proxy_table…
Robert Brown
  • 125
  • 6
0
votes
2 answers

how to use awk or sed command (OS level commands) in Sybase level

I have one text file in host level Ex: /tmp/file.txt. So I have one script and I need to read the line by line from file.txt, so I used sed command. So I am using while loop in the script and I have logged in to DB level, how can I use sed command…
DhanaTeja
  • 1
0
votes
1 answer

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?
Fearl3SS
0
votes
3 answers

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" But isql requires a 'go' statement after each…
Chris Kimpton
  • 723
  • 9
  • 18
0
votes
1 answer

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 all up, or something like that? Or is there some…
theog
  • 111
  • 3
0
votes
1 answer

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: [sybase@myserver ASE-12_5]$ free -g total used free…
KentZhou
  • 101
  • 1
  • 2
0
votes
1 answer

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.
Stu
  • 2,198
  • 2
  • 16
  • 23
0
votes
1 answer

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 Ubuntu install I found a package on…
Dave Mateer
  • 171
  • 1
  • 1
  • 9
0
votes
1 answer

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 Sybase, due to the costs involved upgrading it to a…
Kristiaan
  • 442
  • 1
  • 9
  • 22
0
votes
1 answer

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 Sybase SDK, but I only require the ODBC drivers, not…
Brisbane Mango
  • 69
  • 2
  • 5
0
votes
1 answer

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 then move it to a second table which has a lot of…
BarsMonster
  • 724
  • 4
  • 12
  • 26
0
votes
1 answer

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 Java(tm) Virtual Machine... ........ Running…
Inv3r53
  • 163
  • 1
  • 8
0
votes
1 answer

Redhat 7.3 Sybase 16 (edge) issue with systemctl auto startup process

After installing Sybase 16 (Edge) and successfully upgrading a 15.7 instance to Edge, and then trying to add the sybase service with systemctl so that sybase starts up automatically when the Redhat 7 server is booted I am getting this error==>…
Will Landstrom
  • 1
1
2
3