[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?????
At one time I use to get a SQR log with information in it. Now it
is blank.
Here is what use to be in it:
[1;1H (SQR 5528) ODBC SQL dbftch error -911 in cusor 3:
[IBM] [CLI Driver] [DB2/6000] SQL0911N The current transaction
has been rolled back because of a dedlock or timeout.
Reason code "68" SQLSTATE=40001
Error on line 219:
(SQR 3725) Bad return fetching row from database.
SQRW: Program Aborting
Here is line the code:
212 !-------------------------------------------
213 ! Count-Temp
214 !-------------------------------------------
215
216 begin-procedure Count-Temp
217 #debug do debug-msg('Count-Temp')
218
219 begin-select
220
221 count(*) &temp.count
222 from ps_sss_RES_temp temp
223
224 end-select
225
226 End-Procedure !Count-Temp
!-------------------------------------------
! Delete-Temp
!-------------------------------------------
begin-procedure Delete-Temp
#debug do debug-msg('Delete-Temp')
do Count-Temp
if &temp.count > 0
begin-SQL
delete from ps_sss_RES_temp
end-SQL
end-if
End-Procedure ! Delete-Temp
The SQR does a count of ps_sss_RES_temp and if there are any records
then it deletes them from ps_sss_RES_temp in
procedure Delete-Temp.
Thanks Ken
From: Ken Katchur/SKSOCSRV@SKSOCSRV on 10/29/2003 04:08 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?????
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