Page 1 of 1

Rebuild Table on Check In Files on IBM i

Posted: Wed Nov 23, 2016 7:39 am
by jyoung
If I create a file via "Load Other File".
When I check in that File what do the options "Rebuild table" and "Rebuild indexes and views" do?

The documentation states
to force the generation and compilation of the table, indexes and OAM.
I understand the OAM is going to be recreated but is it going to do something to the actual file and indexes?

Re: Rebuild Table on Check In Files on IBM i

Posted: Wed Nov 23, 2016 9:05 am
by KevinW
If you loaded the other file from the IBM i then these two options do nothing.

If you loaded the other file from elsewhere then these two options will do as they state.

Think about it. If the file exists in the IBM i data base and LANSA says it is maintained by "OTHER" then LANSA won't maintain it, apart from LANSA's access to it - the definitions held in LANSA and the generated OAM. If it is changed outside of LANSA then it will probably need to be reloaded and the OAM regenerated.

Re: Rebuild Table on Check In Files on IBM i

Posted: Wed Nov 23, 2016 9:10 am
by jyoung
That is what I had assumed, but the last thing I wanted to do was to wipe out a File on the IBM i.

Thanks,
Joe