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
1answer
23 views

CREATE TABLE and transactions

Is there a way to use CREATE TABLE inside of a transaction in Sybase?
0
votes
2answers
43 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"? ...
0
votes
1answer
78 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 ...
1
vote
0answers
50 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 ...
0
votes
0answers
18 views

Connecting to a SyBase 12 Database

I have been tasked to perform backups of a Sybase SQL Server 12 database, but was just given the user and password. I tried logging into the server where it runs as a domain admin and ran Sybase SQL ...
0
votes
1answer
30 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
0answers
113 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 ...
0
votes
1answer
61 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
1answer
774 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 ...
0
votes
1answer
27 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
1answer
580 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:...
0
votes
1answer
269 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, ...
3
votes
2answers
630 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
1answer
204 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 ...
0
votes
1answer
244 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 ...
-1
votes
1answer
603 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 ...
2
votes
0answers
123 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 ...
0
votes
1answer
698 views

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

I am trying to do replication from Sybase ASE 15.5 to Sybase ASE 15.5 for a list of given tables via replication definitions and subscriptions in Replication Server Version 15.7.1. I found there is a ...
1
vote
0answers
114 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
2answers
920 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 ...
0
votes
1answer
472 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 ...
2
votes
2answers
720 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 ...
0
votes
2answers
334 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 ...
4
votes
1answer
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 ...
0
votes
1answer
527 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
vote
1answer
416 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
1answer
1k 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.
0
votes
1answer
614 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 ...
0
votes
2answers
954 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 ...
2
votes
2answers
488 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 ...
2
votes
1answer
815 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 ...
1
vote
1answer
820 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 ...
2
votes
1answer
1k 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
0answers
399 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
0answers
910 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
2answers
4k 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
1answer
363 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
1answer
790 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
2answers
3k 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
1answer
668 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
0
votes
1answer
481 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
1answer
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 ...
1
vote
1answer
55 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
2answers
52 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 ...
1
vote
1answer
1k 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 ...
3
votes
0answers
578 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 ...
3
votes
1answer
581 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
2answers
1k 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. ...
1
vote
1answer
295 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 ...
0
votes
1answer
927 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 ...