sybperl-l Archive

From: abe dot crabtree at citicorp dot com
Subject: RE: Handling log full issues with DB-Library
Date: Sep 4 2002 8:08AM

Rather than answer the perl question, how about:

Lower thresholds that dmp the log.  Generally speaking you should have these 
(but obviously it depends.)

It sounds as if the database should have "abort tran on log full" too, unless 
this one single query is the only one that should abort when the log fills.

I hope this helps,

Regards,

Abe Crabtree

-----Original Message-----
From: dsrao [mailto:dsrao@wilco-int.com]
Sent: 04 September 2002 04:58
To: SYBPERL-L
Cc: dsrao; duggineni.rao; andre.wong
Subject: Handling log full issues with DB-Library


Hi,

	I have a situation where I am executing a query through DB-Lib
command in a Sybase database. If this query fills up the log to the
threshold limit, the data server suspends the execution of the query till
the space is made available in the log. But I want to catch that warning in
my script and want to cancel the connection to the database. I am actually
using the message handler in my script. So, whenever this happens, the
control goes into the message handler. I am trying to kill the connection
using dbclose/dbcancel, but It doesn't seem to work.

	Basically I want the control back to the script when this happens. 
	I am getting the "Segmentation fault(core dumped)" error when I
tried to close and reopen a connection with the same db handler inside the
message handler.

	Did anyone come across situation like this??
	Please pass on any idea that can handle this situation.

Regards,
Srini.


This message is confidential and may also be legally privileged. If you are not 
the intended recipient, please notify postmaster@wilco-int.com immediately. You 
should not copy it or use it for any purpose, nor disclose its contents to any 
other person. The views and opinions expressed in this e-mail message are the 
author's own and may not reflect the views and opinions of Wilco.