1
vote
1answer
55 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 ...
0
votes
0answers
44 views

Sybase ASE 12.5 on VMWare extremely slow cursors

There is a poorly written stored proc in an older Sybase 12.5 database that I need to make faster, but I can't change the code. I can change the database settings, indexes, engines, OS settings, etc. ...
0
votes
0answers
16 views

ASE 15.03 mixed data and log segements [duplicate]

I have a DB with mixed data & log segments. I also have some log on data device & the other way too.. The target is to have the data & log segments aligned properly , please guide me how ...
3
votes
3answers
117 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 ...
2
votes
1answer
1k 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 ...