How DB2 load works

[it_simpy@yahoo.com]

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.Table Name
(
Table Definition
)

[it_simpy@yahoo.com]

Re: How DB2 load works


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.Table Name
(
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]

Re: How DB2 load works

it_simpy@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.Table Name
(
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/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.ugref/chload.htm

or download the "Utility Guide & Reference" in either BookManager or PDF
format at:

http://www-306.ibm.com/software/data/db2/zos/v8books.html

--
Jeroen

[it_simpy@yahoo.com]

Re: How DB2 load works

Thanks a lot. It is really helpful.