Hello,
I am loading data in to DB2 Tables. The Source is a sorted sequential file and all my target tables are sorted except for one. Is there a way to correct this without using a sort stage ?
Thanks
Hazmar
Sort
Moderators: chulett, rschirm, roy
Re: Sort
What is that supposed to mean? Is it a 'DB2 thing' where tables can be... 'sorted'?cosec wrote:and all my target tables are sorted except for one.
Or are we just talking about doing an initial load sorted in a fashion that matches the PK of the target table?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Re: Sort
What do you mean by "Is there a way to correct this without using a sort stage ?". Can you shed some light on it.cosec wrote:Hello,
I am loading data in to DB2 Tables. The Source is a sorted sequential file and all my target tables are sorted except for one. Is there a way to correct this without using a sort stage ?
Thanks
Hazmar
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
You can set the APT_NO_SORT_INSERTION parameter and in the sort stage set the "don't sort previousley sorted" option. You also need to make sure that the job runs in sequential mode. Otherwise partitioning may mess up the order.
If you need to run it in parallel mode then you will need to pick the sorted collection method in your DB stage. This will do some sorting, but it's not as bad as a total resort because it will only do a single pass on the data.
If you need to run it in parallel mode then you will need to pick the sorted collection method in your DB stage. This will do some sorting, but it's not as bad as a total resort because it will only do a single pass on the data.
Mike