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.

No more to start it with new log files?

2 posts in iAnywhere General Discussion (German) Last posting was on 2006-05-25 13:11:58.0Z
I.H.Chung Posted on 2006-05-24 11:55:19.0Z
From: "I.H.Chung" <chungih1@paran.com>
Newsgroups: ianywhere.public.german.general
Subject: No more to start it with new log files?
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 124.216.28.40
Message-ID: <44744943$1@forums-2-dub>
X-Original-Trace: 24 May 2006 04:53:39 -0700, 124.216.28.40
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 May 2006 04:53:40 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 May 2006 04:55:19 -0700
X-Trace: forums-1-dub 1148471719 10.22.108.75 (24 May 2006 04:55:19 -0700)
X-Original-Trace: 24 May 2006 04:55:19 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.german.general:291
Article PK: 1038

Hi

we are running Adaptive Server Anywhere 6.0. But, Since April , we can not
backup them, selecting the option(:Starting DB with new Log file).
After back up the DB(about 3 GB), Log(about 1.9GB) and then it says "Waiting
for transations to complete..", Waiting for transations to complete.."...
How can we start DB with new Log file? any other solutions?

Thank you for your help:
========
chungih1@paran.com

** we are using ASA 6.0 utility for backup


Rob Waywell Posted on 2006-05-25 13:11:58.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.german.general
References: <44744943$1@forums-2-dub>
Subject: Re: No more to start it with new log files?
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <4475ad1e$1@forums-1-dub>
Date: 25 May 2006 06:11:58 -0700
X-Trace: forums-1-dub 1148562718 10.25.98.235 (25 May 2006 06:11:58 -0700)
X-Original-Trace: 25 May 2006 06:11:58 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.german.general:292
Article PK: 1039

In version 6.x we did not support having transactions cross multiple log
files. This meant that the backup process had to wait until there was a
point where there were no open transactions in order to close out the old
log file and start a new one. Depending on how active your server is, this
can take awhile.

Note that if you are really using version 6.0.0, then you may want to
consider upgrading to 6.0.4 and the last ebf build for that version. The 6.x
codeline has been end of lifed for quite awhile. You might also want to
consider upgrading to the current 9.0.2 version which does support
transactions spanning multiple log files.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"I.H.Chung" <chungih1@paran.com> wrote in message
news:44744943$1@forums-2-dub...
> Hi
>
> we are running Adaptive Server Anywhere 6.0. But, Since April , we can
> not
> backup them, selecting the option(:Starting DB with new Log file).
> After back up the DB(about 3 GB), Log(about 1.9GB) and then it says
> "Waiting
> for transations to complete..", Waiting for transations to complete.."...
> How can we start DB with new Log file? any other solutions?
>
> Thank you for your help:
> ========
> chungih1@paran.com
>
> ** we are using ASA 6.0 utility for backup
>