load a Table using LOAD UTILITY provided by db2. LOAD REPLACE replace old

How do you Load a table ?? and what is Load replace ?

Question Posted / sasi

2 Answers
33381 Views
Xansa, I also Faced
E-Mail Answers

Answer Posted / sasi

load a Table using LOAD UTILITY provided by db2.
LOAD REPLACE
replace old data in the Table(resets a tablespace and
related indexes to empty before loading)

Is This Answer Correct ?

18 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What parameters are used to control the free space in DB2?

1006

How can you do the explain of a dynamic sql statement?

1011

What is dbrm in db2 database?

1032

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2778

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

List some fields from sqlca?

1000

How does db2 sample database connect?

969

Why cursor is used in db2?

984

How can you quickly find out the # of rows updated after an update statement?

983

What is the use of with ur in db2?

995

What is the meaning concurrency in the db2 database?

1054

What is ibm db2 connect?

927

Explain the benefits you can get from mainframe connect?

910

How do I add a column to a table in db2?

1048

Explain about mirror activator disk mirroring?

954