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.

dbcc tune(doneinproc, 0) ??

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-09-03 17:37:35.0Z
David Lance Wolf Posted on 1997-09-02 17:26:11.0Z
Message-ID: <340C4C32.E05A6CEA@sybase.com>
Date: Tue, 02 Sep 1997 10:26:11 -0700
From: David Lance Wolf <dwolf@sybase.com>
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: dbcc tune(doneinproc, 0) ??
Content-Type: multipart/mixed; boundary="------------FAB5EE0A7BECA5E6905C32D2"
Newsgroups: sybase.public.jdbcconnect
Lines: 28
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:332
Article PK: 252082

Will turning off doneinproc packets break jConnect?? I know DB-LIB
didnt care, but CT-LIB seemed to? Just curious about whether its
possible to reduce network I/O by diabling the doneinproc packets?

dbcc tune(doneinproc, 0)
go

Dave Wolf
Sybase Professional Services


Download VCard vcard.vcf


David Clegg Posted on 1997-09-03 17:37:35.0Z
Message-ID: <340DA05F.18331083@sybase.com>
Date: Wed, 03 Sep 1997 10:37:35 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: David Lance Wolf <dwolf@sybase.com>
CC: lancea
Subject: Re: dbcc tune(doneinproc, 0) ??
References: <340C4C32.E05A6CEA@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:322
Article PK: 252073

No, jConnect doesn't need the doneinproc packets. If you are
executing a number of statements in your stored procedure and
you want to know how many rows were affected by individual
statements in the procedure, then you would need to leave the
doneinproc tokens on so that you could get that info using the
stmt.getMoreResults(), stmt.getUpdateCount() methods, but if you
are only interested in the final results of the stored procedure,
you don't need them.

If you give the dbcc tune command below through IsqlApp or Isql
applet sample programs, things should continue to work fine. I
tried it with executing sp_who -- which returned 9 doneinprocs
before the dbcc command, and none after. Both executions returned
the same info.

>
> Will turning off doneinproc packets break jConnect?? I know DB-LIB
> didnt care, but CT-LIB seemed to? Just curious about whether its
> possible to reduce network I/O by diabling the doneinproc packets?
>
> dbcc tune(doneinproc, 0)
> go
>
> Dave Wolf
> Sybase Professional Services
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for David Wolf