MVSFORUMS.com

kolusu · Posted: Thu Apr 27, 2006 4:57 am Post subject:

issac1029,

why do you think it is a sql that is causing the problem? Each Jobcalss has a time limit defined in your system. Make sure that you are running the job in the right class. Also check if your pgm is in an infinite loop.

Hope this helps...

Cheers

KOlusu
_________________
Kolusu
www.linkedin.com/in/kolusu

schintala · Posted: Thu Apr 27, 2006 8:03 am Post subject:

S322 code nothing to do with DB2 time. It depends job class defined in your shop. MVS cpu time is different from DB2 CPU time. If it all your SQL fails out of time resources, you will get corresponding SQL error code of -905.

hariavinash · Beginner Joined: 21 Jan 2005 Posts: 52 Topics: 7

issac1029,

this is a timeout error. like Kolusu suggested check for possible program looping. another way to go about this is code a TIME parameter in your jcl/proc and rerun the job. if there is a TIME parameter give longer time and try out.

cheers

issac1029 · Intermediate Joined: 10 Dec 2005 Posts: 159 Topics: 75

1)
This problem has been solved by add one more constraint

key include a ,b,c:
a
b
c
d
e
f

my orginal sql:

select ...... from ..... where a=xx and c=xx

my new orginal sql:(it runs well)

select ...... from ..... where a =xx and c=xx and f='x'

I think it's because the num of record wihch satisfied the 'where' condition are too large.But some one told me that if one of the key(a,b,c) have not been defined in index also can cause timeout,I am confuse about that.

2)another question :If I define 'f' which is not a part of the unique key,if i use

Manas Biswal · Posted: Mon May 08, 2006 3:45 pm Post subject:

issac1029,

I am not very clear on your question, but if you mean to ask that defining a,b,c and f in a composite index would improve performance, then in your particular case (your SQL), YES...it would.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)