SEO

#1 (**permalink**) 02-27-2008, 11:48 AM

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
)

#2 (**permalink**) 02-27-2008, 11:48 AM

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

#3 (**permalink**) 02-27-2008, 11:48 AM

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.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

#4 (**permalink**) 02-27-2008, 11:49 AM

Thanks a lot. It is really helpful.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How DB2 load works