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
0 answers
46 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-...
user avatar
  • 87
0 votes
1 answer
585 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 ...
user avatar
  • 87
0 votes
1 answer
39 views

CREATE TABLE and transactions

Is there a way to use CREATE TABLE inside of a transaction in Sybase?
user avatar
  • 207
0 votes
2 answers
209 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"? ...
user avatar
  • 170
0 votes
1 answer
664 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 ...
user avatar
  • 103
1 vote
0 answers
224 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 ...
user avatar
  • 170
0 votes
1 answer
163 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, ...
user avatar
0 votes
0 answers
198 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 ...
user avatar
  • 264
0 votes
1 answer
116 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 ...
user avatar
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 ...
user avatar
  • 167
0 votes
1 answer
39 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, ...
user avatar
0 votes
2 answers
951 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:...
user avatar
  • 23
0 votes
1 answer
539 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, ...
user avatar
3 votes
2 answers
926 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 ...
user avatar
0 votes
1 answer
265 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 ...
user avatar
  • 23
0 votes
1 answer
289 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 ...
user avatar
  • 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 ...
user avatar
  • 23
2 votes
0 answers
132 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 ...
user avatar
  • 121
0 votes
1 answer
948 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 ...
user avatar
  • 23
2 votes
0 answers
129 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 ...
user avatar
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 ...
user avatar
  • 131
0 votes
1 answer
594 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 ...
user avatar
  • 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 ...
user avatar
  • 183
0 votes
2 answers
500 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 ...
user avatar
  • 183
4 votes
1 answer
1k 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 ...
user avatar
  • 101
0 votes
1 answer
740 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 ...
user avatar
  • 1
1 vote
1 answer
515 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 ...
user avatar
-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.
user avatar
1 vote
1 answer
881 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 ...
user avatar
  • 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 ...
user avatar
  • 1
2 votes
2 answers
570 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 ...
user avatar
  • 220
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
2 votes
0 answers
478 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 ...
user avatar
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:...
user avatar
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 ...
user avatar
-5 votes
1 answer
546 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
0 votes
1 answer
834 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
user avatar
  • 121
0 votes
1 answer
545 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 ...
user avatar
0 votes
1 answer
4k 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 ...
user avatar
  • 207
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 736
3 votes
0 answers
690 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 ...
user avatar
  • 31
3 votes
1 answer
637 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. ...
user avatar
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. ...
user avatar
  • 103
1 vote
1 answer
316 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 ...
user avatar