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.

Bulk Insert/Update Without Logging

2 posts in General Discussion Last posting was on 2009-06-06 15:10:33.0Z
Mike Faltys Posted on 2009-06-04 20:03:57.0Z
Sender: 6904.4a282814.1804289383@sybase.com
From: Mike Faltys
Newsgroups: ianywhere.public.general
Subject: Bulk Insert/Update Without Logging
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a2828ad.691f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Jun 2009 13:03:57 -0700
X-Trace: forums-1-dub 1244145837 10.22.241.41 (4 Jun 2009 13:03:57 -0700)
X-Original-Trace: 4 Jun 2009 13:03:57 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7593
Article PK: 5992

For version 9.0.2, there is a way to disable deletions from
being logged to the transaction log via STOP SYNCHRONIZATION
DELETE. Is there any way to prevent updates and inserts
from being logged? This is for windows mobile 5 and windows
xp versions.

Thanks,
Mike


Breck Carter [TeamSybase] Posted on 2009-06-06 15:10:33.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Bulk Insert/Update Without Logging
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <5m1l259i7ak9d42bu3ldvkjpadee6babcn@4ax.com>
References: <4a2828ad.691f.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 6 Jun 2009 08:10:33 -0700
X-Trace: forums-1-dub 1244301033 10.22.241.152 (6 Jun 2009 08:10:33 -0700)
X-Original-Trace: 6 Jun 2009 08:10:33 -0700, vip152.sybase.com
Lines: 31
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7597
Article PK: 5994

See the "bulk insert mode" switch dbsrv9 -b in the Help...

ASA Database Administration Guide

The Database Server

The database server

Database server options

-b server option


Breck

On 4 Jun 2009 13:03:57 -0700, Mike Faltys wrote:

>For version 9.0.2, there is a way to disable deletions from
>being logged to the transaction log via STOP SYNCHRONIZATION
>DELETE. Is there any way to prevent updates and inserts
>from being logged? This is for windows mobile 5 and windows
>xp versions.
>
>Thanks,
>Mike

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com