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: 43
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: 2963
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 JCL SORT to compress the student's de... DFSORT/ICETOOL 7
No new posts WER999A - UNSUCCESSFUL SORT 8ED U Ab... SYNCSORT 5
No new posts COBOL Ascending and descending sort n... COBOL Programming 5
No new posts SORT deletes the SORTOUT file DFSORT/ICETOOL 8
No new posts Creating CSV file from Variable recs ... DFSORT/ICETOOL 11
Search our Forums:

Back to Top