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.

tempdb locking issue

3 posts in Windows NT Last posting was on 1997-07-03 09:44:53.0Z
Trinity Computer Services Posted on 1997-07-01 16:23:33.0Z
From: "Trinity Computer Services" <trinity@foothill.net>
Subject: tempdb locking issue
Organization: TCS
Message-ID: <01bc8645$0b43f640$2bafaace@trinity.foothill.net>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.sqlserver.nt
Date: Tue, 01 Jul 1997 12:23:33 -0400
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5594
Article PK: 1081670

Are there any common problems encountered concerning file locking related
to the tempdb database and SQL server? We are experienceing a problem with
a powerbuilder application that seems to be locking the tempdb database for
its own use - while it is running, no other programs may access tempdb.

Any thoughts, ideas, or solutions will be greatly appreciated!!

Please e-mail me at:

mailto:trinity@foothill.net


or reply by mail to this post!


Christophe GOGUYER DESSAGNES Posted on 1997-07-03 09:44:53.0Z
X-Newsreader: Microsoft Outlook Express 4.71.0544.0
From: "Christophe GOGUYER DESSAGNES" <cgd@haute-savoie.cci.fr>
References: <01bc8645$0b43f640$2bafaace@trinity.foothill.net>
Subject: Re: tempdb locking issue
Date: Thu, 3 Jul 1997 11:44:53 +0200
Lines: 20
Organization: ADSM Informatique
X-MimeOLE: Produced By Microsoft MimeOLE Engine V4.71.0544.0
Message-ID: <OcY2t04h8GA.151@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5592
Article PK: 1081669

Trinity Computer Services a écrit dans l'article <01bc8645$0b43f640$2bafaac
e@trinity.foothill.net>...

>Are there any common problems encountered concerning file locking related
>to the tempdb database and SQL server? We are experienceing a problem
with
>a powerbuilder application that seems to be locking the tempdb database
for
>its own use - while it is running, no other programs may access tempdb.

If you use data definition langage commands on tempdb within transaction,
your system may hang up.
The DDL commands hold locks on system tables such as 'sysobjects'.

Regards

Christophe GOGUYER DESSAGNES
ADSM Informatique - FRANCE
cgd@haute-savoie.cci.fr


Christophe GOGUYER DESSAGNES Posted on 1997-07-03 09:44:53.0Z
X-Newsreader: Microsoft Outlook Express 4.71.0544.0
From: "Christophe GOGUYER DESSAGNES" <cgd@haute-savoie.cci.fr>
References: <01bc8645$0b43f640$2bafaace@trinity.foothill.net>
Subject: Re: tempdb locking issue
Date: Thu, 3 Jul 1997 11:44:53 +0200
Lines: 20
Organization: ADSM Informatique
X-MimeOLE: Produced By Microsoft MimeOLE Engine V4.71.0544.0
Message-ID: <t81zr04h8GA.183@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5593
Article PK: 1081672

Trinity Computer Services a écrit dans l'article <01bc8645$0b43f640$2bafaac
e@trinity.foothill.net>...

>Are there any common problems encountered concerning file locking related
>to the tempdb database and SQL server? We are experienceing a problem
with
>a powerbuilder application that seems to be locking the tempdb database
for
>its own use - while it is running, no other programs may access tempdb.

If you use data definition langage commands on tempdb within transaction,
your system may hang up.
The DDL commands hold locks on system tables such as 'sysobjects'.

Regards

Christophe GOGUYER DESSAGNES
ADSM Informatique - FRANCE
cgd@haute-savoie.cci.fr