RE: [sqr-users] SQR locking table

["Leonard, Kyle" <KyleLeonard@texashealth.org>]

Thanks for the reply.

The nolock would work for the individual SQR but there are two problems:
        1. Nolock introduces the possiblity of selecting bad data
        2. The real problem is that this SQR is running and locking
other processes (BQYs, Java Apps) from selecting or updating the table.

How do we get the SQR to update and release the lock while the SQR
continues to perform its other processing?

Thanks
 

-----Original Message-----
From: sqr-users-bounces+kyleleonard=texashealth.org@sqrug.org
[mailto:sqr-users-bounces+kyleleonard=texashealth.org@sqrug.org] On
Behalf Of ashwin reddy
Sent: Tuesday, April 17, 2007 12:04 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] SQR locking table

try putting a nolock in your sql and i hope it will work for  u .....
   
  SELECT * FROM tablename WITH (NOLOCK)

  
"Leonard, Kyle" <KyleLeonard@texashealth.org> wrote:
  Using SQR 8.5 against a MS SQL Server 2000 database.



We have an SQR utility which uses a table to identify and run reports.
The SQR calls a stored procedure which updates or inserts into a table
to kick off other processes to run. Recently we have noticed that the
table is locked until the SQR finishes processing keeping the other
processes from running. 



We've added Commits to both the SQR and the stored procedure without any
effect. Searching the archive has not lead to a solution.



Can anyone shed some light on what else might be occurring and how we
might be able to remove the lock immediately after the update/insert?



Thanks



_________________________________________ 

Kyle J. Leonard

Sr. Programmer Analyst

Financial Services

Texas Health Resources







The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL,
and exempt from disclosure under applicable law. If you are not the
intended recipient, you are prohibited from copying, distributing, or
using the information. Please contact the sender immediately by return
e-mail and delete the original message from your system.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


       
---------------------------------
 Yahoo! Mail is the world's favourite email. Don't settle for less, sign
up for your freeaccount today.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users




The information contained in this message and any attachments is intended only 
for the use of the individual or entity to which it is addressed, and may 
contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from 
disclosure under applicable law.  If you are not the intended recipient, you 
are prohibited from copying, distributing, or using the information.  Please 
contact the sender immediately by return e-mail and delete the original message 
from your system.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users