Unload from table running long

aneeta · New User Joined: 08 Dec 2005 Posts: 44 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.

Terry Heinze · Posted: Sun Oct 19, 2008 6:47 am Post subject:

"This job is running for a long time and using excessive CPU and DB2 resource."
This is a bit vague -- care to elaborate?

aneeta · New User Joined: 08 Dec 2005 Posts: 44 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

dick scherrer · Posted: Sun Oct 19, 2008 11:31 am Post subject:

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?