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
 

 

Want to know the work process for DB2 load utility

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

New User


Joined: 22 Jan 2008
Posts: 53
Location: china

PostPosted: Tue Aug 05, 2008 8:59 pm    Post subject: Want to know the work process for DB2 load utility
Reply with quote

Wanna know about DB2 load utility DSNUPROC 's process, i know first is the initial , then do the reload, then sort and build...

but i am not sure when it does the RELOAD, what happend in fact? does the data are loaded into the table already?
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 Aug 06, 2008 2:56 am    Post subject:
Reply with quote

Hello,

At the top of the web page is a link to "IBM Manuals". Among the documentation listed are manuals for several releases of DB2.

From the DB2 version you are using, open the Utilities Guide and search for DSNUPROC (the yellow flashlight/tubelight). All of the documentation is there as well as many examples.

If you find something you do not understand, post what you found back here along with your question about it.

Someone will be able to help.

Most likely, the reason there have been no replies to your questions is that your questions were not understood.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1530
Location: Andromeda Galaxy

PostPosted: Wed Aug 06, 2008 12:06 pm    Post subject:
Reply with quote

Hi joe song

This is the best place to start

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

Regards,
Prem
Back to top
View user's profile Send private message
Joe_Song
Currently Banned

New User


Joined: 22 Jan 2008
Posts: 53
Location: china

PostPosted: Wed Aug 06, 2008 1:21 pm    Post subject: Hi
Reply with quote

My question is in load different phases , what (RE)LOAD will do? i can't understand the explain in the doc. I mean what the (RE)LOAD is doing in the load phase?

it put the data to a temporary file or it loads the data to the table in reload phase?
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Wed Aug 06, 2008 8:05 pm    Post subject:
Reply with quote

It just LOADS the data into the table without checking any constraints. The records will be eliminated if any during Build phase if am right.

It could be different when INDEXES are built paralley using SORTDEVT parameter.

RELOAD is just LOAD. I guess IBM wants to differentiate between the LOAD utility name and diff steps involved in LOAD. (thus RELOAD).
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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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