Questions tagged [sybase-ase15]
120 questions
0
votes
1 answer
Installation failed - SAP Adaptive Server Enterprise 16.0 SP03
I am try to install SAP Adaptive Server Enterprise 16.0 SP03 (evaluate version).
I have a win 10 OS. Installation show error message when try install. Any idea why it is fail?
I shared logs files here
Daniel Vera
- 77
- 1
- 10
0
votes
1 answer
sybase table Lock with semicolon at end of insert statement
can terminating insert statement with semicolon in Sybase cause Lock on table on which insert takes place?
I tried to insert 95 rows in a sybase table with each insert terminated by ; is it possible it could cause huge db lock
Prateek Gupta
- 135
- 1
- 2
- 11
0
votes
1 answer
Sybase ASE 15.7: Create Trigger such that before inserting I want to modify row being inserted
I am using Sybase ASE 15.7. I wish to create trigger before insert such that before inserting, I want to modify some fields in the inserted row.
Please help Thanks!
joe
- 77
- 2
- 9
0
votes
1 answer
Query log segment usage for a Sybase database where data and log are in same device
Is there a way to get log usage from a database where data and log segment are in the same device for Sybase?
I have searched and there are examples of queries that show all databases and usages, but many commented that when a database segment = 7…
Anell Zheng
- 25
- 5
0
votes
1 answer
Sybase identity_gap attribute is not maintaining specified gap
I am using Sybase Adaptive Server Enterprise 15.7 and I have created a table like
create table student(
rollNum int identity,
name varchar(16),
primary key(rollNum)
)with identity_gap = 50
When records are inserted, rollNum jumps
from 3 to 51 -->…
Bifrost
- 417
- 5
- 23
0
votes
0 answers
Sybase ASE 15.7 : Pass Result set of one sp to another & invoke 2 SP in parallel
As per sybase documentation for creating global temp tables.
Which says create a global temp table in tempdb. So that it can be shared by among different process.
Session 1: Here I create the global temp table through a proc.
Create procedure…
Divyaansh Bajpai
- 232
- 1
- 8
0
votes
0 answers
How to Calculate Size of Individual Tables in Sybase ASE
I need to calculate the total size of individual tables in databases hosted on Sybase ASE system. The release of Sybase ASE system that we are using is 15.7.1.
The goal is to determine the total disk storage used by each table in the databases…
Rich_Cit
- 1
- 1
- 1
0
votes
1 answer
Sybase 12.5 vs 15.0 client connect libraries: 10x slower insert using 15.0 when inserting into 15.7 ASE
I maintain some legacy code that runs on RH Linux that sends inserts over the network to a client's Sybase. We were using Sybase 12.5 libraries and have just migrated to use Sybase 15.0 client libraries.
My application logs the time at which it…
totsubo
- 323
- 4
- 17
0
votes
1 answer
Conversion failed because the DateTime data value overflowed the type specified for the DateTime value part in the consumer's buffer
i have a stored procedure in Sybase ASE with date params in it, so when i created a OLE DB Connection and passing the date parameters to the OLE DB Command,And we are mapping to the parameter with OLEDBType.DBTimeStamp type, datetime param type in…
user10168930
- 11
- 1
0
votes
1 answer
Restore database in Disaster Recovery site
Our DR sybase solution is based on restoration of a full backup and then the dump of the transaction log from the main site. The sybase is an old version: ASE15.0
However, the solution is not working.
After having restore the full backup (without…
0
votes
0 answers
Sybase 15.7: Aggregating data in a large table
We have a fairly simple stored procedure that aggregates all the data in a large table (and then puts the results in another table). For a 5M rows table this process takes around 4 minutes - which is perfectly reasonable. But for a 13M rows table…
Dmitry S
- 151
- 5
0
votes
0 answers
Unable to connect to Sybase 15.0.3 Server using Isql
I have installed Sybase ASE 15.0.3 on Read Hat Linux. ASE server is up and running. However, i am not able to connect to the server via iSql.
[sybase@ip-********* install]$ isql -SCLGETCLD -Usa -Pnull
Unable to retrieve localized message for ID…
Pavan
- 11
0
votes
1 answer
what does it mean about that sybase error
it is about sybase Insufficient account permissions？
[sybiq@db ~]$ isql -U abc -P abc -S abc3
1> sp_spaceused
2> go
Msg 504, Level 11, State 0:
SQL Anywhere -265: 'sp_spaceused'
1> select @@version
2> go
@@version …
jiaqiang liu
- 7
- 1
- 5
0
votes
0 answers
Sybase ASE - List table names, column names, constraint names in a DB
Can I get a query to list out parent and child table names, parent and child column names, constraints, and constraint types in a Sybase ASE DB?
Mano
- 601
- 10
- 32
0
votes
0 answers
SYBASE Cluster on RedHat Pacemaker Cluster
I am trying to setup a SYBASE cluster on RedHat 7.5 using Pacemaker. I want the Active/Passive mode, where SYBASE will be running only in a single node a the time, but when I configure in such way it's work fine during the configuration, but when…
Helio Aymoto
- 303
- 2
- 5
- 16