Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to Rebulid an index?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Jun 26, 2008 6:57 pm    Post subject: how to Rebulid an index?
Reply with quote

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
Back to top
View user's profile Send private message

plkanth_526

New User


Joined: 01 Jun 2008
Posts: 7
Location: Bangalore

PostPosted: Fri Jun 27, 2008 11:32 am    Post subject: Reply to: how to Rebulid an index?
Reply with quote

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.
Back to top
View user's profile Send private message
plkanth_526

New User


Joined: 01 Jun 2008
Posts: 7
Location: Bangalore

PostPosted: Fri Jun 27, 2008 11:43 am    Post subject: Reply to: how to Rebulid an index?
Reply with quote

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

sorry for typo
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Fri Jun 27, 2008 11:47 am    Post subject: Reply to: how to Rebulid an index?
Reply with quote

hi,

thank you...

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


thanks,
Nagu
Back to top
View user's profile Send private message
plkanth_526

New User


Joined: 01 Jun 2008
Posts: 7
Location: Bangalore

PostPosted: Mon Jun 30, 2008 3:33 pm    Post subject: Reply to: how to Rebulid an index?
Reply with quote

yes...Load resume will append the rows to the existing rows.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm
No new posts Rebuilding IMS secondary index withou... Hooman24 IMS DB/DC 6 Tue Mar 29, 2016 12:22 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us