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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
20 views

Reliable way(s) of finding home directory of Sybase DB (ASE) on Linux and Windows

I need to write a script that finds Sybase installation on a system if there's any. For testing I've installed ASE 16 on CentOS system, but the installer is apparently based on InstallAnywhere (Java). ...
0 votes
0 answers
54 views

Sybase lead blocker in chain

What would be a query to list a blocking chain in Sybase ASE 16? In SQL server I'd use something like this: https://blog.sqlauthority.com/2015/07/07/sql-server-identifying-blocking-chain-using-sql-...
  • 87
0 votes
1 answer
725 views

Map login to user in restored database in SYBASE ASE 16

After restoring a database from other environment is there a way to map a user in the database to a login in the server. I can drop and recreate or alias but in MS SQL Server there is a way: EXEC ...
  • 87
0 votes
1 answer
52 views

CREATE TABLE and transactions

Is there a way to use CREATE TABLE inside of a transaction in Sybase?
  • 217
0 votes
2 answers
314 views

Why Are Table Scans Bad?

At my work, I am often told that I shouldn't do a table scan because it could negatively impact the database and the app using the database. What exactly do they mean by "negatively impact"? ...
  • 170
0 votes
1 answer
813 views

How to mark a Sybase ASE DB as offline for startup

I need to load a database dump into a target database, on Sybase ASE 16. In order to do that, the target database must be offline. Sybase ASE doesn't have a command to put a database offline, so my ...
  • 103
1 vote
0 answers
274 views

Sybase and SQL injection

I am maintaining a legacy system that uses Sybase ASE as the database. Because the system is a legacy system, the only way to create an SQL query is string concatenation (prepared statements are not ...
  • 170
0 votes
1 answer
211 views

How many databases does a sybase instance have?

I'm a newbie to sybase and could not find the clear answers on Sybase tutorials/docs How many databases can one Sybase instance have? Oracle has one instance which corresponds to only one database, ...
0 votes
0 answers
228 views

Sybase ASE 16.0 BCP in character problem

I am using SYBASE ASE 16.0 and in my tables i have some values like "KOCAELİ", "İZMİR", "TALATPAŞA" . They are readable in csv file however when i put database with bcp in command, i have ...
  • 274
0 votes
1 answer
130 views

Split Backup of MSSQL VS Stripe Backup of Sybase ASE

I recently came to know about concept of split backup in MSSQL Server whereas I have been working on stripe backup in Sybase ASE. Stripe backup in Sybase ASE is faster than normal backup and if we ...
0 votes
1 answer
1k views

Determing when a stored procedure was last compiled

Is there a way to find when a procedure last had an execution plan compiled in Sybase ASE 16? I don't see a "modified" datetime column in sysobjects, and I haven't been able to find a Sybase ...
  • 167
0 votes
1 answer
43 views

Find Source & Details of APL Heap Table Insert

I have been running system monitor(sysmon) on Sybase ASE 15.7(SP139) on HP-UX(Itanium) with below command: sp_sysmon "00:10:00" go Observed that number of inserts are very high in any time of a day, ...
0 votes
2 answers
1k views

Lock a table in Sybase ASE 15.5

I would like to lock a table to only allow users to perform read operation in Sybase ASE 15.5, how can I do it? I have tried the below command, but seems there is some confusion. Any idea? Session A:...
  • 23
0 votes
1 answer
643 views

Size of Log Backup is not reducing from past three days

Recently we implemented Incremental(Enabled allow incremental dumps) and Log Backup(Disabled trunc Log on chkpt) for Sybase ASE(15.7 SP139) running on HP-UX Itanium server and to our great surprise, ...
4 votes
2 answers
974 views

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 ...
0 votes
1 answer
286 views

Problem creating subscriptions on Replication Server version 15.7.1

if anyone knows what is the error? Can not use active or standby connection names for subscriptions I got this error when I'm trying to create my subscriptions. I have already created a repdef WITH ...
  • 23
0 votes
1 answer
315 views

Clarification on steps creating Database Replication Definition

I am being asked to create database replication definitions for a couple of databases (around 20 databases). I just wanted to clarify is the below-mentioned steps are the correct steps to be carried ...
  • 23
-1 votes
1 answer
1k views

Permission denied to run set Identity_insert to table

I have just setup the ASE-ASE replication with a column as IDENTITY, when I tried to resume my DSI connection of my replication server, I'm hitting the error Message from server: Message: 10369, State ...
  • 23
2 votes
0 answers
140 views

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 ...
  • 121
0 votes
1 answer
989 views

Problem replicating IDENTITY columns from Sybase ASE 15.5 to Sybase ASE 15.5

I am trying to perform replication from Sybase ASE 15.5 to Sybase ASE 15.5 for a list of given tables via replication definitions and subscriptions defined in Replication Server(REP) Version 15.7.1. I ...
  • 23
2 votes
0 answers
131 views

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 ...
0 votes
2 answers
1k views

How to login to Sybase ASE using OS credentials?

I come from an Oracle background, and I'm used to the concept of OS users that can login to Oracle with DBA privileges in the machine the DB is installed on using their OS credentials as long as the ...
  • 131
0 votes
1 answer
633 views

Replication Server version 15.7.1 - Sybase ASE 15.5, how to change primary data server in RSSD?

Recently, I am requested to migrate the current Sybase data server to a new Sybase data server (let's say, from pub1 to pub2). To do this, I need to rebuild all the RepAgents which have been set up ...
  • 23
2 votes
2 answers
1k views

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 ...
  • 183
0 votes
2 answers
550 views

What happens to replication if rows have been deleted on a target already?

In a normal replicated world, the following sequence happens: MAIN ASE: delete N rows issued RS: delete N rows sent to replication target TARGET: delete same N rows However, what happens ...
  • 183
4 votes
1 answer
2k views

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 ...
  • 101
0 votes
1 answer
818 views

How do I change the usage of a device_fragment?

As can be seen below an index device_fragment usage is log only when it should be data only, and a log device_fragment usage is data only when it should be log only. name db_size owner ...
  • 1
1 vote
1 answer
533 views

ip address record in sybase ASE auditing database? [closed]

everone. I installed the sybsecurity database for auditing in sybase ase 15.5. The installation is OK. I configured the audit commands, for example, for auditing the sa user, and other users of the ...
-1 votes
1 answer
2k views

How to move databases to another drive in same server for sybase ASE 16 on windows.

I am trying to move sybase user database from one drive to another drive, can you please help me with procedure. My database : Sybase ASE 16 OS windows.
1 vote
1 answer
899 views

SQL query output to Sybase temp table

I need to query a MSSQL 2008 db for 4 columns of data where one column (an ID) is used to join a number of tables from a Sybase ASE 15 database then output all 4 columns from the SQL query with a ...
  • 11
0 votes
2 answers
1k views

Need script for new login creation in sybase ase

I have 470 new database accounts in SYBASE ASE I certainly don't want to do it manually since it is definitely time consuming. Here by I have old script which I try to add logins Can someone help ...
  • 1
2 votes
2 answers
579 views

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 ...
  • 250
2 votes
1 answer
1k views

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 ...
  • 121
1 vote
1 answer
1k views

Passing a table name to a stored procedure

Once a new table is created, we have to execute the same SQL code segment, that grants some users rights to the table and does similar maintenance. This code is identical for all cases, differing only ...
  • 225
2 votes
1 answer
2k views

how do I know whether I am currently in chained or unchained mode

In Sybase server-side language how can my code test whether it's running in chained or unchained (auto-commit) mode? Examining the status of @@TRANCOUNT is not really conclusive. I gather that there ...
2 votes
0 answers
499 views

why is the 'Dynamic Ownership Chain' mode of a stored procedure mutually exclusive to "chained" / "unchained"?

How is the "chained" / "unchained" / "any" transaction mode for a stored procedure related to the "[no] dynamic ownership chain" mode? Reading the Sybase ASE documentation on the sp_procxmode system ...
2 votes
0 answers
1k views

allow multiple NULL values in unique key

I am trying to allow for multiple NULL values in a unique key as allowed by ANSI SQL. E.g. in the below table I want to allow multiple NULL values in column f1 and still have a unique constraint on it:...
6 votes
2 answers
5k views

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 ...
-5 votes
1 answer
577 views

why this huge disparity in maximum row sizes between PostgreSQL and Sybase ASE [closed]

PostgeSQL has some ridiculously ample field and row size limits (1GB and 1.6TB respectively). Sybase ASE on the other hand has row size limits in the neighborhood of 4 or 8KB. E.g. on a Sybase ASE ...
0 votes
1 answer
1k views

Sybase server build error, missing library files

I'm trying to build sybase ase server through sample resource file and i got this error. "error loading shared libraries: libXm.so.4: cannot open shared object file: No such file or directory". So ran ...
1 vote
2 answers
4k views

How to see where the default database is configured for a particular username or login name?

Once I connect to a database server without specifying a particular database, e.g. with: sqsh -Usomeuser -Ssomeserver … I can do a: select db_name(); … to see the default database ...
0 votes
1 answer
880 views

Sybase ASE server request logs

Is it possible to log each SQL query statement received from clients for a Sybase ASE server 15.7 , same as SET general_log = 1; command for mysql. Thanks
  • 121
0 votes
1 answer
553 views

Sybase ASE monitoring tool of choice [closed]

I have inherited an Sybase ASE 16 database server and my initial task consist on deploy some Key Performance Indicators to monitor the RDBMS instance performance. I have 3 tools available in the ...
0 votes
1 answer
5k views

SQL Central for Sybase 16 SP 02

ALL, First time post here in DB Administrators, so please be patient. In the past long time ago I was working with Sybase SQL Anywhere on Windows. There I got the actual server, ISQL utility, and a ...
  • 217
1 vote
1 answer
59 views

What are the things to looks for or capture when there are blockages in Sybase

Currently i look for SPID which are blocking other spid's,enable traceon(3604) to capture SQLTEXT, Showplan. If blockages keep re-occuring over time especially when certain query is executed, what ...
1 vote
2 answers
63 views

How to identify when to move all or part of the data from Sybase ASE to Sybase IQ?

Is there an easy way that any of you guys use to determine this? Ok, we have more than x gb of data, we should go for IQ! Ok, we have more than x reports going, we should go for IQ! Ok, we have a lot ...
  • 255
1 vote
1 answer
2k views

Sybase ASE: How to know if a device has free space to extend a database on it

I am new to sybase ASE. I would like to know what are all the databases that have been using a device in sybase instance. sp_helpdevice or sp_helpdb are just giving not enough information. Is there ...
  • 766
3 votes
0 answers
724 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 ...
  • 31
3 votes
1 answer
647 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
2 answers
2k 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. ...
  • 103