Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us