IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Load - Sort Or order BY


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Nileshkul

New User


Joined: 09 May 2016
Posts: 30
Location: India

PostPosted: Tue May 03, 2022 3:05 am
Reply with quote

I have a DB2 load utility which has input from cursor to get data from table A and load it in table B. Both the tables are having similar structure, just different schema/division/tablespace etc.
So there is no ORDER BY in cursor and DB2 load specified with SORTKEYS and NUMRECS. Will adding ORDER BY in cursor be any helpful to speed up the LOAD process? Sorry if I missing something here.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2915
Location: NYC,USA

PostPosted: Thu May 05, 2022 6:48 am
Reply with quote

Just unload table a and load table b
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Need suggestion on a sort card DFSORT/ICETOOL 10
No new posts Sort with JOINKEYS using two VB files DFSORT/ICETOOL 1
No new posts SORT - To repeat a string in same col... SYNCSORT 3
No new posts question on Outrec and sort #Digvijay DFSORT/ICETOOL 20
No new posts SORT ERROR PARAMETER VALUE EXCEEDS M... DFSORT/ICETOOL 12
Search our Forums:

Back to Top