Powerhouse/AIX- MS-SQL Server locking issues

[Goparaju, Vidyasagar]

Hi Joe,
 
Thanks for your input.
 
I have tried few suggestions mentioned in the list. Nothing really worked for me.
 
Looks like the SQL server database has not been releasing the record locks on the previous record even after going to the next primary record in the read chain.
 
Thanks
Sagar
 
-----Original Message-----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
Sent: Wednesday, November 30, 2005 1:31 PM
To: Goparaju, Vidyasagar; powerh-l at lists.sowder.com
Subject: RE: Powerhouse/AIX- MS-SQL Server locking issues
 
It's a big topic, and you could start by typing the string below at Google's search page,
 
site:lists.sowder.com powerh-l autocommit sql server
 
Regards, Joe. 
  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com [mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of Goparaju, Vidyasagar
Sent: 30 November 2005 19:21
To: powerh-l at lists.sowder.com
Subject: RE: Powerhouse/AIX- MS-SQL Server locking issues
 
Hi Listers,
 
We have successfully migrated our application from VMS/RMS environment to AIX/Oracle. Except some performance issues in some areas we look good there.
 
Now we are on to AIX/MS-SQL Server environment under the same version of Powerhouse PH.8.43.D1 and running the same code with minor changes to fix some compilation errors. 

We are having major problems with locking and deadlocks in this environment.
 
I have experimented with some transactions within Quick, but nothing really works. Not sure whether we need any changes on the ODBC connection, database end or Powerhouse.
 
Any suggestions would be greatly appreciated.
 
Thanks
Sagar
TradePoint Systems
 
STATEMENT OF CONFIDENTIALITY:
The information contained in this electronic message is intended for the exclusive use of the addressee(s) and may contain confidential information.  If you are not the intended recipient of this email, be advised you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited.  Please notify TradePoint Systems LLC immediately at (603) 889-3200 and destroy all copies of this message and any attachments.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20051130/d7cabe58/attachment.htm