How DB2 load works

[it_simpy]

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
)

[it_simpy]

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

[The Boss]

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

[it_simpy]

Thanks a lot. It is really helpful.