Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Facing the problem when running the sql Query(SPUFI)

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Facing the problem when running the sql Query(SPUFI)
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    Post subject:
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: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 5:55 pm    Post subject:
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    Post subject: Re: Facing the problem when running the sql Query(SPUFI)
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: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 7:24 pm    Post subject:
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: 680
Location: NJ

PostPosted: Wed Dec 20, 2006 9:15 pm    Post subject: Re: Facing the problem when running the sql Query(SPUFI)
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    Post subject: Re: Facing the problem when running the sql Query(SPUFI)
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

Site Director


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

PostPosted: Thu Dec 21, 2006 1:51 am    Post subject:
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    Post subject:
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: 1105
Location: The Netherlands at Hole 19

PostPosted: Tue Jan 09, 2007 7:47 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am
No new posts Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us