how to Rebulid an index?

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

I have loaded a DB2 table by using load utility.

The job got abended and when i tried to submit the job it's saying a message like rebuild is pending for index.

could any body tell me how to rebuild the index? In the net, i found info like if we use LOAD with REPLACE option it will rebuild the index.

My doubt is...

Consider i am having 10 records in a table.... If i try to load some 20 records by using LOAD with REPLACE option, will it affect the previous
20 records.

thanks,
Nagendran.R

plkanth_526 · New User Joined: 01 Jun 2008 Posts: 7 Location: Bangalore

Using load replace index will be built but the data already present in the table will be deleted(10 rows will be deleted) and 20 rows will be loaded.

If you want to retain all the rows and index to be built use load resume.With load resume default is index build.

plkanth_526 · New User Joined: 01 Jun 2008 Posts: 7 Location: Bangalore

please read the above as 20 records will be present and 10 records already present will be deleted.

sorry for typo

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

hi,

thank you...

If we use LOAD with RESUME YES will it retain all the original rows without deleting.

thanks,
Nagu

plkanth_526 · New User Joined: 01 Jun 2008 Posts: 7 Location: Bangalore

yes...Load resume will append the rows to the existing rows.