IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Facing the problem when running the sql Query(SPUFI)


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sambasivarao

New User


Joined: 10 Jul 2006
Posts: 47
Location: Bangalore

PostPosted: Wed Dec 20, 2006 2:21 pm
Reply with quote

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
View user's profile Send private message
bhattabhinav

New User


Joined: 01 Nov 2006
Posts: 6

PostPosted: Wed Dec 20, 2006 4:35 pm
Reply with quote

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
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 5:55 pm
Reply with quote

.........or have a look at the architecture of your query icon_wink.gif
Back to top
View user's profile Send private message
ravi17s
Warnings : 1

New User


Joined: 15 Aug 2003
Posts: 57

PostPosted: Wed Dec 20, 2006 6:14 pm
Reply with quote

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
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 7:24 pm
Reply with quote

Post the charactaristics of the tables and the query than we can give more advise.
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Wed Dec 20, 2006 9:15 pm
Reply with quote

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
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Wed Dec 20, 2006 10:29 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Dec 21, 2006 1:51 am
Reply with quote

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
View user's profile Send private message
RamsIBM

New User


Joined: 08 Jan 2007
Posts: 53
Location: Chennai

PostPosted: Tue Jan 09, 2007 7:37 pm
Reply with quote

You might have executed this querey in production online region...
run this query in production batch.... most properly it will work
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Tue Jan 09, 2007 7:47 pm
Reply with quote

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 icon_evil.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Running REXX through JOB CLIST & REXX 13
No new posts DELETE SPUFI DB2 1
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top