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.

"online database" command causes log suspend

4 posts in General Discussion Last posting was on 2012-10-02 14:51:06.0Z
djmodica Posted on 2012-10-02 13:19:30.0Z
Sender: 10ba.506ae857.1804289383@sybase.com
From: djmodica
Newsgroups: sybase.public.ase.general
Subject: "online database" command causes log suspend
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <506ae9e2.1116.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Oct 2012 06:19:30 -0700
X-Trace: forums-1-dub 1349183970 172.20.134.41 (2 Oct 2012 06:19:30 -0700)
X-Original-Trace: 2 Oct 2012 06:19:30 -0700, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31401
Article PK: 74290

hi folks. i loaded a dump from one database into another
and when i issued the "online database command" i got a log
suspend condition. i was able to use an earlier dump that
worked fine.
would i have been able to use "dbcc settrunc ('ltm',
ignore)" to resolve this rather than use a different dump ?
how could i execute the dbcc command if the database is
offline ? it was suggested to me that the dbcc was the
correct response.
version:
Adaptive Server Enterprise/15.0.3/EBF 16549
ESD#1/P/x86_64/Enterprise Linux/ase

thanks.


offline Posted on 2012-10-02 14:14:26.0Z
Sender: 129e.506af00d.1804289383@sybase.com
From: offline
Newsgroups: sybase.public.ase.general
Subject: Re: "online database" command causes log suspend
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <506af6c2.1435.1681692777@sybase.com>
References: <506ae9e2.1116.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Oct 2012 07:14:26 -0700
X-Trace: forums-1-dub 1349187266 172.20.134.41 (2 Oct 2012 07:14:26 -0700)
X-Original-Trace: 2 Oct 2012 07:14:26 -0700, 172.20.134.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31402
Article PK: 74291

You could run following on offline db's
dbcc dbrepair(<dbname>, ltmignore)

> hi folks. i loaded a dump from one database into another
> and when i issued the "online database command" i got a
> log suspend condition. i was able to use an earlier dump
> that worked fine.
> would i have been able to use "dbcc settrunc ('ltm',
> ignore)" to resolve this rather than use a different dump
> ? how could i execute the dbcc command if the database is
> offline ? it was suggested to me that the dbcc was the
> correct response.
> version:
> Adaptive Server Enterprise/15.0.3/EBF 16549
> ESD#1/P/x86_64/Enterprise Linux/ase
>
> thanks.


Vishi Posted on 2012-10-02 14:26:01.0Z
From: "Vishi" <vishiyy@gmail.com>
Newsgroups: sybase.public.ase.general
References: <506ae9e2.1116.1681692777@sybase.com>
In-Reply-To: <506ae9e2.1116.1681692777@sybase.com>
Subject: Re: "online database" command causes log suspend
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3555.308
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3555.308
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <506af979@forums-1-dub>
Date: 2 Oct 2012 07:26:01 -0700
X-Trace: forums-1-dub 1349187961 172.20.134.152 (2 Oct 2012 07:26:01 -0700)
X-Original-Trace: 2 Oct 2012 07:26:01 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31404
Article PK: 74293

Hi

You can use the below command to make the database online, good luck ..

use master
go
dbcc dbrepair ( dbname, ltmignore )
go
online database dbname
go

Regards, Vishi
+91-9962528947


"djmodica" wrote in message news:506ae9e2.1116.1681692777@sybase.com...

hi folks. i loaded a dump from one database into another
and when i issued the "online database command" i got a log
suspend condition. i was able to use an earlier dump that
worked fine.
would i have been able to use "dbcc settrunc ('ltm',
ignore)" to resolve this rather than use a different dump ?
how could i execute the dbcc command if the database is
offline ? it was suggested to me that the dbcc was the
correct response.
version:
Adaptive Server Enterprise/15.0.3/EBF 16549
ESD#1/P/x86_64/Enterprise Linux/ase

thanks.


djmodica Posted on 2012-10-02 14:51:06.0Z
Sender: 161e.506afead.1804289383@sybase.com
From: djmodica
Newsgroups: sybase.public.ase.general
Subject: Re: "online database" command causes log suspend
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <506aff5a.164f.1681692777@sybase.com>
References: <506ae9e2.1116.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Oct 2012 07:51:06 -0700
X-Trace: forums-1-dub 1349189466 172.20.134.41 (2 Oct 2012 07:51:06 -0700)
X-Original-Trace: 2 Oct 2012 07:51:06 -0700, 172.20.134.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31405
Article PK: 74294

thanks everybody !