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

0
votes
0answers
10 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 ...
1
vote
2answers
37 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
143 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
1answer
93 views

Unable to drop a table in Sybase ASE

I can't drop a table in Sybase ASE 15. I launch a drop table SORTING_PLAN_SOURCE command in SQuirreL SQL, and it just goes on and on, without answering. After a while (like 5 minutes), I cancel the ...
0
votes
0answers
132 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
113 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 ...
4
votes
3answers
257 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 ...
0
votes
2answers
82 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
390 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 ...