By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,745 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

How DB2 load works

P: n/a
Hi,

I used to load the Db2 database in mainframe using the following
commands

LOAD DATA LOG NO REPLACE NOCOPYPEND ENFORCE CONSTRAINTS DISCARDS 1
INDDN SYSREC00 INTO TABLE
DBCreator.TableName
(
Table Definition
)

Feb 22 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a

I used to load the Db2 database in mainframe using the following
commands

LOAD DATA LOG NO REPLACE NOCOPYPEND ENFORCE CONSTRAINTS DISCARDS 1
INDDN SYSREC00 INTO TABLE
DBCreator.TableName
(
Table Definition
)

But I am not sure what each and every parameters are used to and how
exactly the load function is happening in Database.

When I monitored the utility that I used to load it showed me two
phases
1. Reload
2. Sort

But I read there is 4 steps in load function. Could you explain it
with detail or some references which explains the same.

Thank you

Feb 22 '07 #2

P: n/a
it******@yahoo.com wrote:
I used to load the Db2 database in mainframe using the following
commands

LOAD DATA LOG NO REPLACE NOCOPYPEND ENFORCE CONSTRAINTS DISCARDS 1
INDDN SYSREC00 INTO TABLE
DBCreator.TableName
(
Table Definition
)

But I am not sure what each and every parameters are used to and how
exactly the load function is happening in Database.

When I monitored the utility that I used to load it showed me two
phases
1. Reload
2. Sort

But I read there is 4 steps in load function. Could you explain it
with detail or some references which explains the same.

Thank you
4? More like 10 or so.
Check the Infocenter:
http://publib.boulder.ibm.com/infoce...ref/chload.htm

or download the "Utility Guide & Reference" in either BookManager or PDF
format at:
http://www-306.ibm.com/software/data...s/v8books.html

--
Jeroen
Feb 22 '07 #3

P: n/a
Thanks a lot. It is really helpful.

Feb 23 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.