Tagged Questions

A range of RDBMS and BI products from Sybase Corporation, distantly related to MS SQL Server. Their RDBMS offerings span the full range from an enterprise-grade "big iron" RDBMS down to a lightweight mobile RDBMS. On the BI side, they have a DW/BI solution called Sybase IQ.

learn more… | top users | synonyms

1
vote
1answer
37 views

SQLAnywhere: Visualize in real time CPU and RAM consumption of sql connections

I want to keep track of which connection use most of resources. Within Sybase Central (SQL Anywhere 9, 12), for each server and database, we have pane to check in real time All Connected Users and ...
0
votes
1answer
27 views

how to change sybase sql default port

Is there any option to change the sybase sql default port ? Here I want to change the port number because we can't start two SAP instances at the same time on the same server?
1
vote
1answer
17 views

Find efficient way of migration 2TB GBK table in SybaseIQ to UTF-8 files

My project need to migrate more than 2TB raw data from SybaseIQ to another Database. SybaseIQ using GBK, the target Database using UTF-8, the target database can only load from UTF-8 files. We use ...
0
votes
1answer
41 views

Unable to drop a table in Sybase ASE

I can't drop a table in Sybase ASE 15. I launch a drop table SORTING_PLAN_SOURCE command in SQuirreL SQL, and it just goes on and on, without answering. After a while (like 5 minutes), I cancel the ...
0
votes
2answers
100 views

How to check sybase command line history?

How can I check the previous command line history in sybase command line?
0
votes
1answer
24 views

Don't delete exist data with SSMA

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase 5.3 ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single MSSQL database. The first database ...
0
votes
1answer
41 views

Extra column when migrating Sybase databases to single SQL Server database

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single SQL Server database. All of the tables in ...
0
votes
0answers
24 views

After issuing an Insert using NewId() can you get the Ids that were used in that Insert

I would like to know if it is possible to get the last inserted ID's from an Insert with Select NewId()?
0
votes
1answer
27 views

Getting database usage of all the database at once in Sybase

How can I get the database usage of all the databases at once? sp_spaceused and sp_helpdb <dbname> only gives the usage one at a time. I use the Sybase Central client.
1
vote
1answer
143 views

How does Sybase store datatime information?

We have a Sybase database that currently stores datetime values in some of the tables. If we move that server with the Sybase database to another country which is in another time zone, will the ...
1
vote
0answers
93 views

Transfer an Advantage Database's Schema/Data to a PostgreSQL Platform Using C# Program

I am currently in the process of writing a .NET program with C# to transfer a database on a Sybase/Advantage 9.1 platform to a PostgreSQL 9.3.4 platform. I am doing this transfer in two stages - ...
0
votes
0answers
37 views

Performance tuning in Sybase

Does Sybase have a tool like AWR in Oracle which can be used to identify high load SQL, tell the important waits that are happening, help in understanding the workload? What are the main tools to be ...
1
vote
1answer
10 views

SQLRemote: Implicit synch of connected objects

I'm looking for the best way to synchronise foreign key relations with SQLRemote. So having e.g. this two tables CREATE TABLE table1( id integer not null default autoincrement, name ...
1
vote
1answer
70 views

Date and Time in Log file

I've the translated Sybase ASA 9 log file, and the log looks like --UPDATE-1120-05402698411 UPDATE DBA.titulo_receber SET dt_pagto='2014/apr/28 11:06:08.593', id_situacao='BA', ...
1
vote
0answers
39 views

Sybase Replication rs_subcmp can ignore length?

I want to use rs_subcmp utility to sync one table. I've created a config file but I got the following error: Length mismatch for column #9 between the primary (50) and the replicate (100). ...
0
votes
0answers
30 views

How to select full text in the blob type?

There's some large text segments stored in database table BLOB column, and when I query that column against database , usually only part of that large texts get displayed. I am not sure whether this ...
-2
votes
1answer
131 views

advantage database server current database name

How to get current database name in advantage database server? I don't know which query will answer this question. I have tried select top 10 * from system.logins but I got below error message: ...
1
vote
1answer
447 views

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

I'm trying to access an ASA16 server from IQ16 via ODBC driver. Both servers are installed on the same Linux box. I've installed unixodbc-bin and added a file .odbc.init into home of user running ...
1
vote
1answer
384 views

How to get list of tables, views etc. a users has rights to on Sybase IQ?

I'm looking for a way to get a list of views, tables, procesdures etc, a user has been granted to. A select onto SYSROLEGRANTS helped me to find basic role of users -- but not more like this. So ...
1
vote
1answer
84 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 ...
3
votes
2answers
140 views

What's the best way to get data for sampling points within a timeframe

I'm looking for some advicse, how to setup a set of queries, which are checking for a aggregated value for sampling points within a time period. This should run at an IQ-server, so maybe not this many ...
6
votes
1answer
296 views

OLE DB Sybase Connection Failing

I have a connection to a Sybase database which we stage in a SQL Server 2008R2 database. I can connect the the database and the connection tests out fine. I am using an OLE DB source with a Sybase ...
0
votes
0answers
16 views

ASE 15.03 mixed data and log segements [duplicate]

I have a DB with mixed data & log segments. I also have some log on data device & the other way too.. The target is to have the data & log segments aligned properly , please guide me how ...
0
votes
1answer
112 views

Sybase9, not using full system capacity

The SSD I/O capacity is around 450MB. When I copy files from one folder to another I can see in the Windows Resource Monitor that the sum of read/write speed gets around 450MB. Why the same wont ...
0
votes
1answer
623 views

Limiting memory for Sybase SQL Anywhere

I have to use Sybase's SQL Anywhere for a project so it has been put on a VM. Memory consumption is particularly high for a not overly taxed database and it's putting a lot of pressure on the VM. ...
1
vote
1answer
474 views

How to know spid which is filling tempdb from temp table name in sybase

I received alert that tempdb is going to be full and temp table name aslo provided. Now I want to know how to check which spid is filling tempdb from temp tablename.
3
votes
3answers
195 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 ...
2
votes
1answer
690 views

View with parameters in Sybase SQL Anywhere

A view with Sybase engine cannot take parameters. Is there a way to do this?
4
votes
1answer
7k views

Split/explode comma delimited string field into SQL query

I have field id_list='1234,23,56,576,1231,567,122,87876,57553,1216' and I want to use it to search IN this field: SELECT * FROM table1 WHERE id IN (id_list) id is integer id_list is varchar/text ...
1
vote
0answers
237 views

kerberos authentication in sybase

we are setting up Kerberos authentication in Sybase (linux). DB version is 15.7. We are using Active directory for kerberos. We have done the configuration settings on the DB side and kerberos is ...
2
votes
0answers
91 views

How to calculate the ratio insert/select against a table to manage the index in Sybase ASE?

To create/manage indexes of a table, it is important to know the ratio insert/select or modification/reporting. For instance, if there are more INSERTS than SELECT against a table, we should try to ...
0
votes
1answer
274 views

how to view content of xbase procedures?

I would like to view the code of my xbase stored procedures. I recognize that show procedures gives me the list of procedures. Can anyone instruct me on how to get the actual code for the stored ...
0
votes
0answers
427 views

SQL nested select (query rows after variable), running slow

Have large table (Sybase) rows = 6276225. I'm pulling call status and my query is very slow. In effect what I’m trying to do is pull data for any event after my variable. While querying for just one ...
3
votes
1answer
2k views

update statement with self join

I needed to copy information from one row of a table to another. I noticed I could do the following: update address set col1 = a2.col1, col2 = a2.col2, .....etc from address a1, address a2 where ...
2
votes
1answer
1k views

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

How can I migrate a sybase database to mysql? [closed]

I've been tasked with migrating a fairly complex legacy Sybase database into a MySQL database and I have no idea where to start. I can't use any off the shelf software, so I'm going to have to write ...
2
votes
1answer
182 views

Load sybase .db into new sybase developer server

We've got a few .db files laying around here which were created by Sybase (version 8.x, I guess) and I've the task to extract some data from those old databases. Now I've installed the latest Sybase ...
2
votes
4answers
5k views

Search every column in every table in Sybase Database

I'm been taxed with the task of creating an application that pulls data from our Micros Point of Sales system. The POS is using a Sybase database running on one of our servers. The database schema is ...
1
vote
1answer
315 views

Sybase Databse Migration from 11.5 to 15

I have to migrate the Sybase Database from 11.5 version to 15. I would like to know few things mentioned below - i) What are the neccessary steps i need to follow in this migration. ii) What are the ...
1
vote
1answer
3k views

Difference between reorg-rebuild and index re-create in Sybase ASE

Could someone please explain what the main differences are between reorg-rebuilds and index re-creation in Sybase ASE?
1
vote
1answer
447 views

Does fast bcp replicate in sybase sql statement replication?

Is it possible to replicate fast bcp using sql statement replication in sybase?
1
vote
2answers
3k views

Sybase ASE 15 “reorg rebuild” fixes performance issues - why and how to tell when it's needed?

I had a table of several million rows in a Sybase ASE 15 server which was running extremely slow, even basic queries would take 5 minutes to execute, for example: SELECT COUNT(1) FROM TABLENAME; ...
1
vote
1answer
318 views

Whether it means the end time of the SYBASE LICENSE?

I want to know the meaning of "2013.03010/permanent/0C94 6187 B194 DF07", Whether it means the end time of the SYBASE LICENSE? sybase log 00:00000:00016:2011/01/03 14:15:37.02 kernel SySAM: ...
0
votes
1answer
2k views

Parameter for Sybase Sql Anywhere 12 Serverport

If SQL Server Anywhere is started via "dbsrv12.exe -z -x tcpip " it opens a Serverport. Default is 2638. If more then one database is opened, the other ones are getting "some" serverports. How ...
2
votes
1answer
315 views

How compatible are Sybase and SQL Server clients connecting to the alternate back end?

Given the shared history of the Sybase and SQL Server products, and their use of a similar (identical?) wire protocol in TDS, what definite statements can be made, if any, about cross compatibility. ...
0
votes
0answers
319 views

Which database tool to connect to Sybase 15 servers?

The Sybase servers which I am working on have just been switched to LDAP authentication. I was using DBArtisan before that, and used to input separate login name and password. Now I don't see any ...
0
votes
0answers
568 views

Sybase ASA 9 Central exception on connecting to old database

I have installed sybase ASA 9 i used the sybase central to connect to an old version .db file of ASA version 6, a wizard popup and ask yes or no to unload the database .. for upgrade i click yes ...
1
vote
0answers
212 views

Sybase anywhere sql server connection problems

in my work we have a software system based on sybase adaptive server any where version 6 installed on a windows server 2008. the system work fine but after a period of time from system start problems ...
3
votes
1answer
289 views

How are foreign keys resolved when creating tables in batch?

I am creating a database version management tool with the goal of being able to recreate a database from scratch using text/sql files contained in source control. As part of establishing a baseline ...
1
vote
3answers
5k views

How to import Sybase .db file into SQL Server database?

I've been given a Sybase .db file by a client and I need to import that into a new SQL Server database so that I may see the data as well as the tables and their relationships, any ideas on how that ...