SAP Sybase Adaptive Server Enterprise (ASE) is a high-performance relational database management system for mission-critical, data-intensive environments. It ensures highest operational efficiency and throughput on a broad range of platforms.

learn more… | top users | synonyms

3
votes
0answers
76 views

Options to migrate large database from Sybase ASE to SQL Server with minimum downtime

The problem: Our server database contains 1TB of data. It runs on a Sybase ASE 15.7 server and shall be migrated to SQL Server 2014. The servers will be located in the same data center during ...
0
votes
0answers
20 views

Performance issue for daily calculations - Sybase Adaptive Server

I need an advice from the community, there is no wrong answer I'd like to have as many advice that I can ! I manage a process that does every day a lot of financial calculations and they are ...
2
votes
1answer
34 views

bulk copy out huge table on sybase adaptive server

anyone has a good approach or even strategy to bulk copy out single table with 500+ millions rows. the table encountered unitialized logical page, and we are looking to atleast salvage good records. ...
0
votes
1answer
72 views

Database size limit in Sybase Express edition

I'm currently testing out the Sybase 16.0 Developer edition on RHEL. Turns out the limitation on the max. concurrent connections is a real problem for me, so I'd like to switch to the Express edition. ...
0
votes
1answer
87 views

Install Developer Edition ASE in Vagrant/Virtual Box

It is possible to deploy a development version of Sybase in a Vagrant/Virtualbox instance? I was planning on using a CentOS vagrant box to create a development environment but am not sure if it's ...
0
votes
0answers
17 views

ASE 12.5 - Local variable in stored proc - performance issues

I've been told many times that using a local variable inside a stored procedure (ASE 12.5) will degrade performance because it prevents indexes from being utilized. I've searched allover for more ...
0
votes
0answers
27 views

where does ASE stores values when we enable option “full logging for all” for any database

i've enabled option "full logging for all" on a database, however unlike other options there is no change in status columns in sysdatabase. I just want to know how ASE determines if full logging is ...
0
votes
0answers
188 views

Best way to move sybase IQ table to Sybase ASE

I use bcp to copy Sybase IQ table to sybase ASE server. Actually bcp first creates some bulk file with extracdet sybase IQ table there, and after just loads that file to Sybase ASE. Is it the one and ...
2
votes
2answers
460 views

Sybase ASE find running process

I run UPDATE INDEX STATISTICS on some HUGE table. And it runs already about 1 hour. Is there some procedures/ways to find the percentage of executing this command? sp_who, sp_sysmon don't help. ...
1
vote
1answer
2k views

How to start Sybase server

I have installed Sybase(Developer's Edition for ASE 16.0) on a linux machine. I have executed the setup.bin file, and installed it using GUI. After this, I tried connecting to the localhost server, by ...
0
votes
0answers
173 views

Set-Up ASE Sybase on Debian

I have next problem. I'm trying to set-up ASE Sybase on Debian. root@###/work# ./setup InstallShield Wizard Initializing InstallShield Wizard... Searching for Java(tm) Virtual ...
1
vote
1answer
136 views

Sybase ASE 12 question

I support a database that has many tables that hold very similar data. Over time, much of this data isn't needed, and the table names are dynamic as an application is creating these tables, and the ...
3
votes
1answer
372 views

Backup & recovery strategies for Partitioned Database in Sybase ASE

I need to know about backup & recovery strategies for partitioned Database in Sybase ASE 15.7 . I am not worried about transaction failure & recovery scenarios. We have already faced this 2 ...
1
vote
2answers
122 views

Preventing sysquerymetrics from being created ASE 15.7

Can I prevent Sybase ASE 15.7 from creating the sysquerymetrics view for a database upon creation? And also, if the view is dropped how can it be added later?
0
votes
0answers
510 views

Single DELETE statement deadlocking in Sybase ASE

I've got a fairly straightforward process running on ASE 15.7, that creates rows in two tables and later deletes them. The tables are both configured to use datapages for the locking scheme, and the ...
2
votes
1answer
2k views

Sybase SQL - Truncation error occurred. Command has been aborted and find CACHE QUALITY

Need help with below code, as it fails with truncation error Truncation error occurred. Command has been aborted. create table monCacheQuality ( ServerName sysname ...