MVSFORUMS.com

[satyenderd]

Hi all,

Herein I am facing a problem while unloading the data from Production.
I am trying to unload the data quering on 2 tables using the below query in DSNTIAUL utility. Table1 is having around 98726051 rows and Table2 is having 43535826. I used the parameter TIME=1410 also in the job statement. But still I am unable to unload the job, even after 3 hrs.
Could anyone pls help me in this regard.

Thanks in advance.

SELECT *
FROM
table1
WHERE RDNDTE IN
(SELECT RDNDTE
FROM
table2
WHERE DATE(RDNDTE) >= CURRENT DATE - 5 YEARS);
_________________
Satya

[CZerfas]

Hello Satya,

performance questions in DB2 always have multiple sides. First, you should give DB2 the choice about the access path to your data by coding
SELECT T1.*
FROM table1 T1, table2 T2
WHERE T1.RDNDTE = T2.RDNDTE
AND DATE(T2.RDNTE) >= ....
;

Facing the number of rows you have to deal with, there are of course many other factors relevant:
- size of your bufferpool
- concurrent traffic in your bufferpool
- I assume, the tables aren't sorted in RDNDTE order
- If you can afford it, eliminate DB2 locking using WITH UR at the end of your Select
- ....

good luck
Christian

[vkphani]

satyenderd,

Kolusu had given soultion in the below link.

http://www.mvsforums.com/helpboards/viewtopic.php?t=10022

[Bill Dennis]

Satya,

Be aware that TIME=1410 allows you nearly 24 hours of CPU time, so your parameter is probably being changed by some system setting. Either a JES2 JOBCLASS default or system exit.

Regardless, you need to make your query as efficient as possible.
_________________
Regards,
Bill Dennis

Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity.

[vkphani]

You can also try running the job by removing TIME parameter.

[satyenderd]

Million thanks to all of you.

I will try with the query provided by Kolusu and CZerfas.

Good day to all of you.
_________________
Satya