[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Locking problem
- Subject: Locking problem
- From: Mashon Wessling <WESSLIM@DOMINOS.COM>
- Date: Tue, 9 Jan 2001 12:12:02 -0500
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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4207.2601" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><FONT face=Arial size=2>Hi all!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Our problem is this:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is there anything that can be done?
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks for your help.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Mashon Wessling</FONT></DIV>
<DIV><FONT face=Arial size=2>Lead Technical Systems Specialist </FONT></DIV>
<DIV><FONT face=Arial size=2>Domino's Pizza LLC</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Domino's Pizza Vision:<BR>Exceptional people on a
mission to be the best pizza delivery company in the world.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Domino's Pizza Guiding Principles:<BR>In the moment
of choice:<BR>1. We demand integrity.<BR>2. Our people come first.<BR>3. We take
great care of our customers.<BR>4. We make Perfect 10 pizza every day.<BR>5. We
operate with smart hustle and positive energy.</FONT></DIV></BODY></HTML>