Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Do an unload multiple partitions are not consecutiv

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
theone1987

New User


Joined: 14 Sep 2009
Posts: 60
Location: Milan

PostPosted: Tue Mar 23, 2010 3:50 pm    Post subject: Do an unload multiple partitions are not consecutiv
Reply with quote

Hello everyone,
I wonder if you can do an unload multiple partitions are not consecutive.
Now I make two separate unload for each partition.
I know that you can do if the partitions are consecutive.
I should do the unload of the partition 13 and 18. can I do it with a single unload?

thanks
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Mar 23, 2010 4:23 pm    Post subject:
Reply with quote

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.ugref/db2z_unloadsyntax.htm

example 7 is using listdef with partitions,
just don't use template &part for output dsn
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Mar 23, 2010 4:27 pm    Post subject:
Reply with quote

Hello There,

I think it can be achieve using LISTDEF. You can specify partition 13 & 18 in list like
Code:

LISTDEF UNLDLIST
INCLUDE TABLESPACE TDB1.TSP1 PARTLEVEL(13)
INCLUDE TABLESPACE TDB1.TSP1 PARTLEVEL(18)



And then

Code:
UNLOAD LIST UNLDLIST
UNLDDN UNLDDS


But not sure what benefit you will get if you loaded them consecutive rather than Separate .Would you please let me know why you want them to unload together?
Back to top
View user's profile Send private message
theone1987

New User


Joined: 14 Sep 2009
Posts: 60
Location: Milan

PostPosted: Tue Mar 23, 2010 5:02 pm    Post subject:
Reply with quote

guptae wrote:

But not sure what benefit you will get if you loaded them consecutive rather than Separate .Would you please let me know why you want them to unload together?


because if I unload from the partition 13 to 18, I unload data of 6 partitions. using LISTDEF I'll unload data of only 2 partitions. I'd saving a lot of CPU.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Mar 23, 2010 5:20 pm    Post subject:
Reply with quote

I meant why you want to unload 13 & 18 th partition together rather to unload them seperately
Back to top
View user's profile Send private message
theone1987

New User


Joined: 14 Sep 2009
Posts: 60
Location: Milan

PostPosted: Tue Mar 23, 2010 7:05 pm    Post subject:
Reply with quote

guptae wrote:
I meant why you want to unload 13 & 18 th partition together rather to unload them seperately


I do so that, the job (which is quite long) is as clear and understandable as possible. there is no other reason.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us