[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] SQRW not responding?????
If the problem is in the compiler or the operating system, changing from
desktop to server might help. If the problem is slow database access, being
on the server will speed that up, but going from 1000 hours to 100 hours
won't help enough. I'd start by assuming that the problem is in my SQR
program and use some display statements.
I just reread your original message, Ken, and it suddenly hit me how little
information you gave us. Why do you press "Ctrl-Alt-Del?" We've assumed
it's because you're not getting any signs of life from your program. Is
that it or do you just want to interrupt your program? If you're getting no
signs of life, do you mean you get something then nothing further, or you
get nothing at all? When you say a different SQR works, do you mean
Ctrl-Alt-Del works or the SQR program performs its task successfully?
-----Original Message-----
From: Katchur, Ken DCRE [mailto:KKatchur@dcre.gov.sk.ca]
Sent: Wednesday, October 29, 2003 2:08 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQRW not responding?????
I am running this from my workstation desktop (client). Would it
make a difference if it was run through the server?
Thanks Ken
From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov> on
10/29/2003 03:21 PM
Please respond to sqr-users@sqrug.org@SMTP@Exchange
To: sqr-users@sqrug.org@SMTP@Exchange
cc:
Subject: RE: [sqr-users] SQRW not responding?????
This could also be an infinite loop. In general, I'd insert show or
display
statements throughout the program; "show 1", "show 2", etc. See
which ones
appear in the SQRw window. That will tell you how far your program
got, and
let you focus on the code that is hanging up.
-----Original Message-----
From: Larry Roux [mailto:LRoux@syr.edu]
Sent: Wednesday, October 29, 2003 12:46 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQRW not responding?????
This sounds like a runaway select still. If you do not have a
display then
the spf would not get built.
Try having your DBA look to see what the process is doing while the
job is
running. My guess is that it is sticking on one statement. Your
machine
would lock up due to the large result set filling up memory.
******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************
>>> KKatchur@dcre.gov.sk.ca 10/29/03 02:43PM >>>
Th .spf file never gets built. The one from yesterday is
still
there from when I ran the same SQR against another database. I have
to a
end task to end the SQRW. And sometimes that does not work and my
workstation locks up and I have to do a hard re-boot.
Thanks Ken
From: "Sahani, Dev" <Dev.Sahani@FMR.COM> on 10/29/2003
11:46 AM
Please respond to sqr-users@sqrug.org@SMTP@Exchange
To: sqr-users@sqrug.org@SMTP@Exchange
cc:
Subject: RE: [sqr-users] SQRW not responding?????
And if that's happening, you will notice this .spf file (in
the
folder that
you are executing the job from) growing in size till the
point that
you kill
the job
-Dev Rishi Sahani
__________________________
FESCo DB Systems -- Development
Fidelity Investments
-----Original Message-----
From: Larry Roux [mailto:LRoux@syr.edu]
Sent: Wednesday, October 29, 2003 12:36 PM
To: KKatchur@dcre.gov.sk.ca; sqr-users@sqrug.org
Subject: Re: [sqr-users] SQRW not responding?????
Could there be a run-away select statement? I would think
that if
you have
a cartesian join somewhere you might see that happen.
******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************
>>> KKatchur@dcre.gov.sk.ca 10/29/03 12:17PM >>>
I am running a SQR through SQRW on my desktop and when I do
a
Crtl+Alt+delete it says SQRW is not responding.
When I run a different SQR with the same database and
username it
works! Any
help would be appreciated.
Thanks in advance
Ken
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users