DB2 UTILITIES - DB2 UTILITIES------------------------------...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: DB2 UTILITIES------------------------------ 1 . CHECK DATA COMMANDS Using this utility used with tables having parent-child relationship, by using this utility we can get all the relation violated records in a like table. if u give the delete option=yes , the violated records will be deleted in the child table. The delete=no , the child table still having the violated records. CHECK DATA TABLESPACE EDSDB.TRG7ETS FOR EXCEPTION IN TRG007.EMPLOY USE TRG007.LEXEMP DELETE YES --------------------------------------------------------------------------------------------------------------------------------- 2. COPY UTILITY This utility is used to make full image copies. COPY TABLESPACE EDSDB.TRG007TS FULL YES SHRLEVEL CHANGE--------------------------------------------------------------------------------------------------------------------------------- 3. INCREMENTAL COPY UTILITY This utility records the changes only as incremental image copy COPY TABLESPACE EDSDB.TRG007TS FULL NO SHRLEVEL CHANGE--------------------------------------------------------------------------------------------------------------------------------- 4. LOAD DATA UTILITY This utility is used to load the data in to tables RESUME =YES : Resumes all the records from 1st to last RESUME=NO : It won't resumes old records from first....
View Full Document

Page1 / 3

DB2 UTILITIES - DB2 UTILITIES------------------------------...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online