RE: [sqr-users] SQRW not responding?????

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

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