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.

Net-Library error???

2 posts in Windows NT Last posting was on 2000-02-28 18:56:42.0Z
Cristinel Popescu Posted on 2000-02-26 05:24:30.0Z
Message-ID: <38B7638E.5382E5B5@telemobil.ro>
Date: Sat, 26 Feb 2000 07:24:30 +0200
From: Cristinel Popescu <Popescu_Cristinel@telemobil.ro>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Net-Library error???
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 22
NNTP-Posting-Host: pool-108.suntel-lems.ro 194.102.106.108
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2496
Article PK: 1089948

When I've try to run update statistics on a table with records after
some minutes because server not finish on time, I receive this error.
Similar error if I use SQL Advantage (with 999 sec as max. time for
connection)

How can I run update statistics on 1987460 rows (huge) table in this
conditions? Also this table suffer very big daily modification - is
data traffic table for our cellular network an contain traffic data.

"D:\>isql -Uccbs -Sbackup -c
Password:
1> update statistics TF_Posted_01
2>
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error:
Net-Library operation terminated due to disconnect
CT-LIBRARY error:
ct_cancel(): network packet layer: internal net library error:
Net-Library operation terminated due to disconnect"


Cristi Popescu
TELEMOBIL DBA


AnaMaria Stirbet Posted on 2000-02-28 18:56:42.0Z
Message-ID: <38BAC4EA.EE0A10F8@sybase.com.no.spam>
Date: Mon, 28 Feb 2000 13:56:42 -0500
From: AnaMaria Stirbet <astirbet@sybase.com.no.spam>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Net-Library error???
References: <38B7638E.5382E5B5@telemobil.ro>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 28
NNTP-Posting-Host: astirbet-pc.sybase.com 172.31.140.205
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2492
Article PK: 1089945

Hi Cristi,

Few questions for you:

1. Are you using ISQL?
2. Did you check the errorlog?
3. Are you at the latest version on 11.9.2?

Toate cele bune,

AnaMaria Stirbet
Sybase TS

Cristinel Popescu wrote:

> When I've try to run update statistics on a table with records after
> some minutes because server not finish on time, I receive this error.
> Similar error if I use SQL Advantage (with 999 sec as max. time for
> connection)
>
> How can I run update statistics on 1987460 rows (huge) table in this
> conditions? Also this table suffer very big daily modification - is
> data traffic table for our cellular network an contain traffic data.
>
> "D:\>isql -Uccbs -Sbackup -c
> Password:
> 1> update statistics TF_Posted_01
> 2>
> CT-LIBRARY error:
> ct_results(): network packet layer: internal net library error:
> Net-Library operation terminated due to disconnect
> CT-LIBRARY error:
> ct_cancel(): network packet layer: internal net library error:
> Net-Library operation terminated due to disconnect"
>
> Cristi Popescu
> TELEMOBIL DBA