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: 1190
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: 1190
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 write multiple lines in PS file in cobol Balu5491 COBOL Programming 7 Wed Mar 07, 2018 10:27 am
No new posts Using multiple routines at exit 6 in ... Randy Horowitz All Other Mainframe Topics 2 Sat Feb 10, 2018 11:57 pm
No new posts Sum the fields in particular format f... sharana64 DFSORT/ICETOOL 9 Fri Jan 05, 2018 1:11 am
No new posts Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am

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