Re: Locking problem

[Peter Alan Burton <pburton@BRIO.COM>]

Mashon,

This issue was addressed in SQR 6.0

Peter

On 9 Jan 2001, at 12:12, Mashon Wessling wrote:

Date sent:              Tue, 9 Jan 2001 12:12:02 -0500
Send reply to:          sqr-users@list.iex.net
From:                   Mashon Wessling <WESSLIM@DOMINOS.COM>
Subject:                Locking problem
To:                     SQR-USERS@list.iex.net

> Hi all!
>
> I am a DBA for a PeopleSoft/Informix environment.  We have been running into
> a problem lately where an sqr compile/runtime statement is causing locking
> problems and major delays in our database.  I was hoping that someone had
> heard of this and/or has a solution.
>
> Our problem is this:
>
> SQR performs the following SQL statement at runtime "select distinct user
> from systables".  Because this happens everytime an SQR runs, it is very
> likely that an SQR will have to wait if another process is accessing
> systables.  This happens often to us, especially if we are doing any kind of
> system maintenance i.e. index creation, table alters, etc...
>
> Is there anything that can be done?
>
> Thanks for your help.
>
> Mashon Wessling
> Lead Technical Systems Specialist
> Domino's Pizza LLC
>
> Domino's Pizza Vision:
> Exceptional people on a mission to be the best pizza delivery company in the
> world.
>
> Domino's Pizza Guiding Principles:
> In the moment of choice:
> 1. We demand integrity.
> 2. Our people come first.
> 3. We take great care of our customers.
> 4. We make Perfect 10 pizza every day.
> 5. We operate with smart hustle and positive energy.
>
>