Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sybase-ase]

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.

A single stand alone installation of ASE typically comprises one "dataserver" and one corresponding "backup server". In multi server installation many dataservers can share one single backup server though. A dataserver consists of system databases and user's databases. Minimum system databases that are mandatory for normal working of dataserver are 'master', 'tempdb', 'model', 'sybsystemdb' and 'sybsystemprocs'. 'master' database holds critical system related information that includes, logins, passwords, and dataserver configuration parameters. 'tempdb' is used for storage of data that are required for intermediate processing of queries, and temporary data. 'model' is used a template for creating new databases. 'sybsystemprocs' consists of system supplied stored procedures that queries system tables and manipulates data in them.

ASE is a single process multithreaded dataserver application, it means when server is up and running there is one single OS process.

58 questions
6
votes
2 answers

datetime fractional seconds

I am reading the description of the datetime datatype from Sybase ASE 15.7 documentation: datetime columns hold dates between January 1, 1753 and December 31, 9999. datetime values are accurate to 1/300 second on platforms that support this level…
Marcus Junius Brutus
  • 2,869
  • 6
  • 26
  • 40
4
votes
1 answer

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 scenarios previously in un-partitioned database & it took…
Dharam Thakkar
  • 41
  • 3
4
votes
1 answer

Why does truncate table put inside a transaction fail with ASE error 226?

Spotted some answer excerpts on the question entitled "Why use both truncate and drop?": "TRUNCATE is logged, and it can be rolled back. ... Let me rebut these falsehoods. I am writing this rebuttal from a SQL Server perspective, but everything…
Raymond
  • 101
  • 6
3
votes
2 answers

Numbered stored procedures: introduction and deprecation?

SQL Server and Sybase ASE both support the highly dubious feature of grouping stored procedures by appending a number: CREATE PROCEDURE Foo;1 AS ... CREATE PROCEDURE Foo;2 AS ... The only tangible benefit is that DROP PROCEDURE Foo will drop all of…
Jeroen Mostert
  • 173
  • 7
3
votes
0 answers

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 migration; an acceptable downtime is 6 hours. We have…
Oyvind
  • 31
  • 2
3
votes
1 answer

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. we are running sybase adaptive server version…
bokswager
  • 39
  • 1
2
votes
2 answers

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. Thanks.
Daria
  • 153
  • 1
  • 7
2
votes
1 answer

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 running the dbisql executable in the…
Nishanth Reddy
2
votes
1 answer

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 current date is used within the table name. I am…
Drew
  • 23
  • 2
2
votes
1 answer

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 ,CollectionDateTime smalldatetime not null ,PhysicalWrites…
Kin Shah
  • 60,908
  • 5
  • 111
  • 230
2
votes
0 answers

Get extract of Sybase data as INSERT statements, with order considering table dependencies

I want to create a SQL script to populate a DEV database using INSERT statements. (Preferably using INSERT statements, rather than binary form, so that I can safely check-in the script to version control). I can easily extract the INSERT statements…
Ben
  • 121
  • 2
2
votes
0 answers

Sample Sybase ASE 15.0.3 database

We are trying to migrate a database from Sybase ASE Server 15.0.3 to SQL Server 2016 with the help of a migration assistant application. We tried doing this by creating sample databases in the Sybase Server and then migrating it to the SQL Server…
C V KASHYAP
  • 21
  • 1
2
votes
2 answers

Is there performance difference between "SET ROWCOUNT" and "TOP"?

I need to select batches of N rows from a large table. I know of two ways of doing this: SET ROWCOUNT SET ROWCOUNT #### SELECT something FROM table WHERE clauses SET ROWCOUNT 0 -- rowcount is only needed for the one query above. TOP SELECT TOP…
DVK
  • 183
  • 8
2
votes
2 answers

how to confirm or refute that performance degradation is due because of too many indexes maintained

We know that indexes improve select statement and at the same time, indexes have a cost of maintenance on every update/insert/delete statement. I don't know how to measure/evaluate this cost. Some context: There are a dozen key tables involved with…
Horaciux
  • 220
  • 3
  • 15
2
votes
1 answer

DELETE statement not working

I'm running my database on a Sybase ASE 15.7 server. A simple delete statement fails without printing any error , I presume there is no permissions problem as I used to delete rows by the past. Here is what I did from an isql console. 1> select…
storm
  • 121
  • 5
1
2 3 4