|
View previous topic :: View next topic
|
| Author |
Message |
aneeta
New User
Joined: 08 Dec 2005
Posts: 48
Location: Chennai
|
|
|
|
Hi All,
One of my direct unload from table job is running for a long time.it joins 3 huge tables (300Million records in each table) and extracts the data based on conditions.
Query:
-----------
Select c.f1,x.f2,C.F3,P.F4,P.F5,..................
from cind c
left outer join cind1 x
on c.cind_id=x.cind1_id
left outer join cind2 p
on c.cind_id=p.add_id
and p.name='Primary'
where substr(C.name,1,1) between ' ' and 'A'
with ur;
The unload is done using DSNTIAUL with IKJEFT01.
This job is running for a long time and using excessive CPU and DB2 resource.Can you help me optimise the job?
I can change the job to any other improved utility suggested for unloading these 3 huge join tables. |
|
| Back to top |
|
 |
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
"This job is running for a long time and using excessive CPU and DB2 resource."
This is a bit vague -- care to elaborate? |
|
| Back to top |
|
|
aneeta
New User
Joined: 08 Dec 2005
Posts: 48
Location: Chennai
|
|
|
|
Yes..this job runs for 5-6hrs to complete.Moreover after running for 4 hours it abends with -904(resource unavailable) and when restarted completes successfully.This process then takes 10hrs to complete.
Thanks
Aneeta |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
How long does it take to unload only the necessary colums from the 3 tables screening out anything that can be excluded immediately (i.e. p.name = "prinary", etc? |
|
| Back to top |
|
|
|
|
