Quote:
Originally Posted by db2champ
I am ok with LOAD but I have still confusion on that.
(1) I know about LOAD that i will no log the transaction but do we have to rebuild/reorag after load operation.
(2) What is backup pending mode which is said by Mr. Feldman?
(3) what is the mean of SET INTEGRITY after the LOAD as said by Mr. Feldman.
I am using db2 9.5 Version.
|
(1). No.
(2). It means that if you do not use NONRECOVERABLE or COPY YES options with the LOAD, you must do a backup (of at least the tablespace) after the LOAD, otherwise the table will not be accessable.
(3). It means that constraints such as foreign keys may need to be verified after the LOAD (DB2 does not check these contraints during the LOAD) so that the table can be made accessable. Primary Keys and Unique Indexes are checked during the LOAD, so no SET INTEGRITY is required to verify these.
Please refer to the DB2 documentation for more informaiton on LOAD, BACKUP, and SET INTEGRITY.