I'm on Sybase 11.5.1 / AIX 4.33 (I know, it's old).
I'm urgently scrabbling around for space and I've found three devices
with free space on. Two of these devices have a portion of space added
to the log and a portion added to data. One has a portion just added

okie.. here is the segment i am using to begin transactions...
##################################
sub TransBegin{
    my ($self, $params) = @_;

Happy Thanksgiving to everybody! Before going back to work after the
holidays, I thought it might be best to try to get the distilled wisdom
of seasoned Sybase people (thus creating a 'gravy') regarding the best
way to rewrite all our stored procedures to make better use of #temp ...

I have a table (5 million rows) containing duplicate records (around
500K) that needs to be deleted.
The following sp filled up the transaction log though I gave a begin
tran /end tran after each delete. I do not have enough privileges to

I while back we had this Sybase sales person coming  and given a sales
speech, he said that now a days new Sybase versions are great by using
file system, not like the old days using raw device?
I can't find any documentation on this, and I would to see it, he is

Our ASE12.0.0.6 (ROLLUP#10390) has been running very well in the 24/7
production envrionment.
I notice Sybase has provided quite a few new EBFs after that. The
latest is EBF#11875, which will raise ASE to 12.0.0.8.

When i bcp-in a quiet large size of data into a table, the bcp process was
halted and message shown out the log was almost full.  I try to exec dump
tran with no_log command, but the below error return:
"DUMP TRANSACTION for database 'aip_db' could not truncate the log. Either

had a Sybase ASE server  12. sumthing (downloaded the latest version )
. Everything was working fine untill we swithced to mod perl...and we
started getting getting this error.. (when our application tries to
connect to to the database)

What is the syntax in a select statement when I want to select from a table
on a database on a remote server?
To make a select from another database on then same server I do:
select * from DB_name.dbo.Table_1?

Hi Everyone...
Running Sybase 7.0.3 under win2k
After a little while the sybase dbeng7.exe starts to eat
almost 100% of the cpu for days on end...

I am in the process of migrating an application which runs on a Sybase
ASE 11.5.1 server to a new box running ASE 12.5.2.
I was able to migrate and update the application database relatively
painlessly. However when I came to synchronise the server logins,

I am reading the manuals a bit thoroughly to prepare for the ASE 12
Certification. At some places, I get confused.  Please help me.
In What's New, under Distributed Transaction Management, the following
is mentioned :

Most of the time I use oracle and now I'm also using sybase, does
anyone know what is the equivalente of oracle spool test.log in
sybase? I do know that while creating a database inserting etct you
can do a -o for out, but while inside of sybase if you do a select and

I would like to know the max possible upload rate for ASE 11.9. Some
one told me it is about 8000rows /5 minutes. This seems ridiculous.
What about bcp ?
The table have one/tow unique indexes and one foreign key.

I have a stored procedure, which was running for 15 seconds now takes
20 minutes.
If I recompile it it takes only 15 seconds but from 3rd day it starts
to take more and more time.