Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Full Transaction Log

5 posts in Windows NT Last posting was on 1997-09-24 20:47:20.0Z
Peter Horwood Posted on 1997-08-15 19:06:29.0Z
Message-ID: <33F4A8B5.411B@arendeeco.com>
Date: Fri, 15 Aug 1997 13:06:29 -0600
From: Peter Horwood <madman@arendeeco.com>
Reply-To: madman@arendeeco.com
Organization: aRenDeeco Inc
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Full Transaction Log
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5575
Article PK: 1081654

I'm currently in a situation where I have a very full transaction log.
I have been extending it continuously to keep the DB operation. The only
reason I was forced to resort to this is because my dump transaction
logs have been unsuccessful at freeing up my DB log. I have tried

dump transaction Web with no_log

and

dump transaction Web with truncate_only

and

dump transaction Web to "c:\backupfile"

but the log is still full. Also now when I do a dump transaction command
I get the WIsql.exe losing the connection to my SQL Server and I have to
restart the connection. If there is a set of tried and true commands
that I can execute to clear my log, please tell me

Thanks in Advance,

Nigel


Rey Bango Posted on 1997-09-24 20:47:20.0Z
Message-ID: <34297C58.289139B6@netrox.net>
Date: Wed, 24 Sep 1997 16:47:20 -0400
From: Rey Bango <rba@netrox.net>
X-Mailer: Mozilla 4.02 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Re: Full Transaction Log
References: <33F4A8B5.411B@arendeeco.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 35
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5506
Article PK: 1081584

Peter,

Is SQL Server the DBMS for a PB app? If so, you'll have to handle
transactions differently. I recall there being an issue with PB apps that
use Sybase and the fact that a transaction is started when they connect.
Since the transaction isn't committed until the user logs out, your log
can't be dumped because there's still an open transaction. If I recall
correctly, you'll have to set AutoCommit to true and handle DB transactions
yourself usingthe EXECUTE IMMEDIATE PowerBuilder phrase.

Rey Bango...

Peter Horwood wrote:

> I'm currently in a situation where I have a very full transaction log.
> I have been extending it continuously to keep the DB operation. The only
> reason I was forced to resort to this is because my dump transaction
> logs have been unsuccessful at freeing up my DB log. I have tried
>
> dump transaction Web with no_log
>
> and
>
> dump transaction Web with truncate_only
>
> and
>
> dump transaction Web to "c:\backupfile"
>
> but the log is still full. Also now when I do a dump transaction command
> I get the WIsql.exe losing the connection to my SQL Server and I have to
> restart the connection. If there is a set of tried and true commands
> that I can execute to clear my log, please tell me
>
> Thanks in Advance,
>
> Nigel


David Lance Wolf Posted on 1997-08-18 16:29:03.0Z
Message-ID: <33F8784F.47F0A44B@sybase.com>
Date: Mon, 18 Aug 1997 09:29:03 -0700
From: David Lance Wolf <dwolf@sybase.com>
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.01 [en] (Win95; U)
MIME-Version: 1.0
Subject: Re: Full Transaction Log
X-Priority: 3 (Normal)
References: <33F4A8B5.411B@arendeeco.com>
Content-Type: multipart/mixed; boundary="------------A249368FA8562DB4E7678E02"
Newsgroups: sybase.public.sqlserver.nt
Lines: 52
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5572
Article PK: 1081649

Peter-

Check the following to see why your log wont truncate

1) Was rep server or SQL Remote installed once?? They set a truncation
point in the log. I think the command is dbcc gettrunc() to look at
truncation points

2) Is there an old transaction laying around open?? Checl
master..syslogshold. Try rebooting.

Dave Wolf

Peter Horwood wrote:

> I'm currently in a situation where I have a very full transaction log.
>
> I have been extending it continuously to keep the DB operation. The
> only
> reason I was forced to resort to this is because my dump transaction
> logs have been unsuccessful at freeing up my DB log. I have tried
>
> dump transaction Web with no_log
>
> and
>
> dump transaction Web with truncate_only
>
> and
>
> dump transaction Web to "c:\backupfile"
>
> but the log is still full. Also now when I do a dump transaction
> command
> I get the WIsql.exe losing the connection to my SQL Server and I have
> to
> restart the connection. If there is a set of tried and true commands
> that I can execute to clear my log, please tell me
>
> Thanks in Advance,
>
> Nigel


Download VCard vcard.vcf


Shannon W. Miles Posted on 1997-08-17 00:40:33.0Z
Message-ID: <33F64881.325CAC04@ix.netcom.com>
Date: Sat, 16 Aug 1997 20:40:33 -0400
From: "Shannon W. miles" <shanm2@ix.netcom.com>
X-Mailer: Mozilla 4.01 [en] (WinNT; U)
MIME-Version: 1.0
Subject: Re: Full Transaction Log
X-Priority: 3 (Normal)
References: <33F4A8B5.411B@arendeeco.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 32
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5574
Article PK: 1081650


Peter Horwood wrote:

> I'm currently in a situation where I have a very full transaction log.
>
> I have been extending it continuously to keep the DB operation. The
> only
> reason I was forced to resort to this is because my dump transaction
> logs have been unsuccessful at freeing up my DB log. I have tried
>
> dump transaction Web with no_log
>
> and
>
> dump transaction Web with truncate_only
>
> and
>
> dump transaction Web to "c:\backupfile"
>
> but the log is still full. Also now when I do a dump transaction
> command
> I get the WIsql.exe losing the connection to my SQL Server and I have
> to
> restart the connection. If there is a set of tried and true commands
> that I can execute to clear my log, please tell me
>
> Thanks in Advance,
>
> Nigel

Make sure that your context is correct. If I remember correctly (a
bit shaky here), you can't be in the DB that you're attempting to dump.
Also, in File|Options, make sure that return SQL Server messages is
selected, it is very strange for you not to get an error of some kind. I
have used the dump transaction DB with truncate_only on a 11.0 and a
11.5ASE beta and it works fine.


Doug Klear Posted on 1997-08-18 11:19:28.0Z
From: "Doug Klear" <doug.klear@bea.doc.gov>
Subject: Re: Full Transaction Log
References: <33F4A8B5.411B@arendeeco.com>
Organization: BEA
Message-ID: <01bcabd1$6c529fc0$e80319ac@w3029-a>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.sqlserver.nt
Date: Mon, 18 Aug 1997 07:19:28 -0400
Lines: 26
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5573
Article PK: 1081651

With MS SQL Server you can use "dbcc checktable(syslogs)" to jar the trans
log into dumping. Of course, if there is an open transaction, this will not
get you very far either.

Peter Horwood <madman@arendeeco.com> wrote in article
<33F4A8B5.411B@arendeeco.com>...
> I'm currently in a situation where I have a very full transaction log.
> I have been extending it continuously to keep the DB operation. The only
> reason I was forced to resort to this is because my dump transaction
> logs have been unsuccessful at freeing up my DB log. I have tried
>
> dump transaction Web with no_log
>
> and
>
> dump transaction Web with truncate_only
>
> and
>
> dump transaction Web to "c:\backupfile"
>
> but the log is still full. Also now when I do a dump transaction command
> I get the WIsql.exe losing the connection to my SQL Server and I have to
> restart the connection. If there is a set of tried and true commands
> that I can execute to clear my log, please tell me
>