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.

Sybase 11.9.2

2 posts in Windows NT Last posting was on 2000-05-30 14:05:48.0Z
Rotem Fogel Posted on 2000-05-30 12:26:28.0Z
Reply-To: "Rotem Fogel" <rotemf@pansw.com>
From: "Rotem Fogel" <rotemf@pansw.com>
Subject: Sybase 11.9.2
Date: Tue, 30 May 2000 14:26:28 +0200
Lines: 11
Organization: Panorama
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <y1F3Jsiy$GA.110@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: IDI-FW.ser.netvision.net.il 194.90.88.53
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2088
Article PK: 1089784

Hi all,

I have just upgraded to Sybase 11.9.2 from 11.5 and i'm having difficulties
with lock on objects.
All the procedures are getting timed out !!!
What do i do ????????
Thanx.
Rotem.
mailto:roetmf@pansw.com


David Wein Posted on 2000-05-30 14:05:48.0Z
Message-ID: <3933CABC.489F941@sybase.com>
Date: Tue, 30 May 2000 08:05:48 -0600
From: David Wein <dwein@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Rotem Fogel <rotemf@pansw.com>
Subject: Re: Sybase 11.9.2
References: <y1F3Jsiy$GA.110@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 20
NNTP-Posting-Host: dwein-pc2.sybase.com 157.133.80.104
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2085
Article PK: 1089780

It is possible that you have an optimization issue. Set showplan on and see if
you are table scannig where you previously index scanned. This is fairly
common on upgrades from 11.5.1 to 11.9.2. If you are table scanning, your
procs will most likely run much slower and will probably be accumulating far
more locks. If you can determine that you are table scanning incorrectly,
check out sybase.public.sqlserver.performance+tuning or open a case with Sybase
tech support.

Cheers,
David Wein
Sybase Boulder

Rotem Fogel wrote:

> Hi all,
>
> I have just upgraded to Sybase 11.9.2 from 11.5 and i'm having difficulties
> with lock on objects.
> All the procedures are getting timed out !!!
> What do i do ????????
> Thanx.
> Rotem.
> mailto:roetmf@pansw.com