View previous topic :: View next topic
|
Author |
Message |
sambasivarao
New User
Joined: 10 Jul 2006 Posts: 47 Location: Bangalore
|
|
|
|
Hi all,
Iam trying to running one SQL Query. In that SQL Query Iam using 4 tables.
At the time of running the query in SPUFI, Iam getting the problem like
CPU TIME LIMIT HAS BEEN EXCEEDED.A SINGLE ONE MINUTE EXTENSION WILL BE GRANTED. PLEASE LOGOFF SHORTLY.
Iam getting the above message.
Can Any one help me how to overcome this situation in SPUFI when running an SQL Query.
Thanks in advance to all of you.
THanks and Regards,
Samba. |
|
Back to top |
|
|
bhattabhinav
New User
Joined: 01 Nov 2006 Posts: 6
|
|
|
|
Hi Samba,
by the look of the error, i'm guessing that you're getting -911 sql code, that is time out, you should probably talk to your admin guys to let your query run for some more time. or increase the allotted DB2 run time for a single user. it usually happens when the DB2 resource is overcrowded. thats what i know atlest. in my opinion just talk to your mainframe admin guys. |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
.........or have a look at the architecture of your query |
|
Back to top |
|
|
ravi17s Warnings : 1 New User
Joined: 15 Aug 2003 Posts: 57
|
|
|
|
Submit the query in the Batch Job and Find out the error.
But your warning messages are terryfying
CPU TIME LIMIT HAS BEEN EXCEEDED.A SINGLE ONE MINUTE EXTENSION WILL BE GRANTED. PLEASE LOGOFF SHORTLY. |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
Post the charactaristics of the tables and the query than we can give more advise. |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi,
This can be done with Admin guy .. You can ask them to increase ASUTIME ... may be you can request to double it if necessary ... Else one more thing which you can do is ask them how it was abended and where the table went with confict action. With their reason you can grasp the next action to be taken on the final run. Let me know if any queries ... |
|
Back to top |
|
|
vijayamadhuri
Active User
Joined: 06 Apr 2005 Posts: 180
|
|
|
|
Hello,
I think there is a problem with the query .Refine u r where clause and see if u have joined u r tables properly with the right key's
if everthing looks fine first run u r query in test version and see if u r getting what u want |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Not all queries should be run from the terminal. Queries that must access a high volume of rows should be run in batch.
It is NOT a good idea to simply allow more time. Very large queries running online cause widespread performance problems.
In addition to "real" large queries, there are many artificial large queries - those that generate a cartesian product on large tables, those that do not access the desired rows via keys, etc.
If you post your problem query, we can look for opportunities to tune it. |
|
Back to top |
|
|
RamsIBM
New User
Joined: 08 Jan 2007 Posts: 53 Location: Chennai
|
|
|
|
You might have executed this querey in production online region...
run this query in production batch.... most properly it will work |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
Like dick and I posted before we need the query to give some support but......TS put his question here 20 dec 2006 and never came back |
|
Back to top |
|
|
|