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
 

 

Diff between FULL and PARTIAL unloads

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

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Mon Dec 10, 2007 3:53 pm    Post subject: Diff between FULL and PARTIAL unloads
Reply with quote

Dear Experts,

I have a small confusion over Unloads.

I came across 2 words "FULL UNLOAD" and "PARTIAL UNLOAD" while going through my project specifications.

I presume like this:

FULL UNLOAD : Unload all the data from a table
(Select col1, col2, col3 from TABLE)

PARTIAL UNLOAD : Unload a part of the data based on some selection criteria.
(Select col1, col2, col3 from TABLE WHERE cond-1 and cond-2)

Can anyone suggest whether I am on right track or out of track.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Dec 11, 2007 4:56 am    Post subject:
Reply with quote

Hello,

I'd suggest there are multiple "partials".

Some, not all of the rows.

Some, not all of the columns.

Combinations of the above.

Yes, i believe you are on the right track icon_smile.gif
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Tue Dec 11, 2007 2:02 pm    Post subject: Re:
Reply with quote

Hi dick,

thanks for ur reply.

As you said above, I got business requirement on which criteria we need to take the unloads. They just need data only from a particular data which will be in another control table and some other project specific requirement. I have started working on that.

I am requesting you for any technical papaers or links related to partila unloads to get more knowledge on this area.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Dec 11, 2007 11:04 pm    Post subject:
Reply with quote

You're welcome icon_smile.gif

I believe partial unloads are kinda like reports - it just depends on what you need to meet your requirement. Rows/columns would be custom selected for the requirement.

I'm not aware of any special papers or web sites that would help.

Possibly, i do not understand the question. If you provide more info on what yo are looking for, someone may have suggestions.
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Wed Dec 12, 2007 4:52 pm    Post subject: Reply to: Diff between FULL and PARTIAL unloads
Reply with quote

Hi dick,

I am looking for some technical papers or web-links on LOAD and UNLOAD utilities, as I have been working on BMC Utilities all the time as part of my project.

So I think it is the right time to get more and more knowledge on this area. If anybody can help me out on this, I can do some research on these two utilities.

If there are any DBA's in our group, they can be sort out this.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Dec 12, 2007 10:34 pm    Post subject:
Reply with quote

Hello M K K,

At the top of each web page there is a "Manuals" link. There is an entire section of database manuals and many of the current versions of DB2 are available. The manual you may be most interested in is the Utility Guide.

Both LOAD and UNLOAD are convered extensively.
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Thu Dec 13, 2007 10:39 am    Post subject:
Reply with quote

Yes dick,

The Utility Guide is very helpful and contains much more information.

Thanks a lot.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Dec 13, 2007 10:37 pm    Post subject: Reply to: Diff between FULL and PARTIAL unloads
Reply with quote

You're welcome icon_smile.gif

We're here if there are questions.

d
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 Append to file, but also remove old r... Garry Carroll JCL & VSAM 3 Mon Jan 25, 2016 8:05 pm
No new posts Full time job & hobbies/second jo... vasanthz General Talk & Fun Stuff 5 Wed Feb 18, 2015 10:06 pm
No new posts DFSMSdss full volume backups JCL when... Alan Playford IBM Tools 3 Thu Feb 05, 2015 4:50 pm
No new posts Compare PD Values with same storage &... Shrinika Rajendran JCL & VSAM 5 Wed Nov 05, 2014 3:17 pm
No new posts Read VSAM file based on a partial key seahawk789 JCL & VSAM 6 Tue Aug 19, 2014 10:26 am


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