Q1)What are all the Reorg varieties ?
Ans: Online reorg and offline reorg.
Offline reorg: To run an offline reorg we need to mention SHRLEVEL NONE in the utility cntl card. In offline reorg other users/processes will not be having any access to the tablespace.
Online reorg: SHRLEVEL REFERENCE or SHRLEVEL CHANGE will give other users/processes read access or read-write access respectively.
Q2) What are all the reorg phases explain them?
Ans: UTILINIT-UNLOAD-RELOAD-SORT-BUILD-LOG-SWITCH-BUILD2-UTILTERM
you need to tell what happens in each phase.
Q3) What is the difference between LOAD RESUME YES and LOAD RESUME NO ?
Ans:
No comments:
Post a Comment