Questions tagged [sybasease]

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
0answers
29 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
39 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
267 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
23 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
376 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
73 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
283 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
147 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 ...
1
vote
1answer
192 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 ...
0
votes
1answer
283 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
81 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
435 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
96 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
634 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
313 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
338 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
161 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
730 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
363 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
277 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
904 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
281 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
677 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
313 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
592 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
590 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
898 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 ...
1
vote
0answers
303 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
624 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:...
5
votes
2answers
3k 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
241 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
473 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
463 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
321 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
3k 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
51 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
45 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
480 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 ...
2
votes
1answer
501 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
270 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
825 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 ...
2
votes
2answers
5k views

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

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 ...
2
votes
1answer
204 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 ...
4
votes
1answer
745 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 ...
1
vote
2answers
310 views

Preventing sysquerymetrics from being created ASE 15.7

Can I prevent Sybase ASE 15.7 from creating the sysquerymetrics view for a database upon creation? And also, if the view is dropped how can it be added later?
0
votes
1answer
2k views

Single DELETE statement deadlocking in Sybase ASE

I've got a fairly straightforward process running on ASE 15.7, that creates rows in two tables and later deletes them. The tables are both configured to use datapages for the locking scheme, and the ...